Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Description of the process that you must complete before you post multicurrency intercompany transactions in Microsoft Dynamics GP

Description of the process that you must complete before you post multicurrency intercompany transactions in Microsoft Dynamics GP

View products that this article applies to.

INTRODUCTION

This article describes a process that you must complete before you post intercompany transactions in Microsoft Dynamics GP when each company has a different functional currency.

↑ Back to the top

MORE INFORMATION

Consider the following scenario. You want to post an intercompany transaction. The companies are the TWO originating company and the TEST destination company. The Z-US$ currency is the functional currency for the TWO originating company. The Z-C$ currency is the functional currency for the TEST destination company.

Before you post the multicurrency intercompany transactions, follow these steps:
1. Grant both of the companies access to the different currencies and exchange tables. To do this, follow these steps:
a. On the Tools menu, point to Setup , point to System , and then click Multicurrency Access .
b. In the Currencies area, click Z-US$ .
c. In the table next to the Currencies area, click to select the Access check box for both the TWO originating company and the TEST destination company.
d. In the Exchange Table IDs area, click an exchange table identifier, and then click to select the Access check box in the table next to the Exchange Table IDs area for both the TWO originating company and the TEST destination company.
e. Repeat step 1d for each exchange table identifier.
f. In the Currencies area, click Z-C$ .
g. In the table next to the Currencies area, click to select the Access check box for both the TWO originating company and the TEST destination company.
h. In the Exchange Table IDs area, click an exchange table identifier, and then click to select the Access check box in the table next to the Exchange Table IDs area for both the TWO originating company and the TEST destination company.
i. Repeat step 1h for each exchange table identifier.
j. Click OK to close the Multicurrency Access Setup window.
2. Use the Intercompany Setup window to establish an intercompany relationship between the two companies. To do this, follow these steps:
a. On the Tools menu, point to Setup , point to System , and then click Intercompany .
b. Click the lookup button next to the Originating Company ID field, click TWO in the Companies window, and then click Select .
c. In the Destination Company Name area, click TEST .
d. In the Originating Company area, click the lookup button next to the Due to field, click an account that you want to use in the Intercompany Accounts window, and then click Select .
e. In the Originating Company area, click the lookup button next to the Due From field, click an account that you want to use in the Intercompany Accounts window, and then click Select .
f. In the Destination Company area, click the lookup button next to the Due to field, click an account that you want to use in the Intercompany Accounts window, and then click Select .
g. In the Destination Company area, click the lookup button next to the Due From field, click an account that you want to use in the Intercompany Accounts window, and then click Select .
h. Click Save .
i. Close the Intercompany Setup window.
Note The accounts will be posted in their respective functional currencies. Therefore, you do not have to assign currencies to these accounts.
3. Use the Multicurrency Exchange Rate Table Setup window to set up an exchange table identifier for the Z-US$ currency. To do this, follow these steps:
a. On the Tools menu, point to Setup , point to System , and then click Exchange Table .
b. In the Multicurrency Exchange Rate Table Setup window, set up an exchange table identifier for the Z-US$ currency.
c. Click Save .
Note You can complete step 3 in either the originating company or the destination company.
4. Use the Select Multicurrency Rate Types window to assign rate types to the exchange table identifier. To do this, follow these steps:
a. On the Tools menu, point to Setup , point to Financial , and then click Rate Types .
b. Click the lookup button next to the Exchange Table ID field, select an exchange table identifier in the Exchange Tables window, and then click Select .
c. In the Select Multicurrency Rate Types window, click the appropriate rate type in the Available Rate Types area, and then click Insert .
d. Click Save .
Note You must complete step 4 in the destination company.
After you complete this process, you can post an intercompany transaction in the originating company.

↑ Back to the top

Article Info
Article ID : 917720
Revision : 1
Created on : 3/1/2017
Published on : 3/1/2017
Exists online : False
Views : 167