Home intercompany accounting microsoft dynamics gp multicurrency streamlining processes

Streamline Intercompany Transactions: Essential Steps in Dynamics GP Multicurrency

Updated: • 0 • min read
Table of Contents

Intercompany transactions are a fundamental aspect of managing finances across multiple legal entities within a single organization. These transactions, which can involve anything from shared expenses and management fees to inventory transfers and loan settlements, become significantly more complex when the involved companies operate using different functional currencies. Microsoft Dynamics GP provides robust features to handle these complexities, but proper setup is paramount to ensure accurate financial reporting and seamless transaction processing. This guide outlines the critical steps required within Dynamics GP to successfully post intercompany transactions when the originating and destination companies have distinct functional currencies.

Dynamics GP Multicurrency Intercompany

Consider a common scenario where an organization has two distinct companies set up in Dynamics GP. Let’s call the originating company “TWO” and the destination company “TEST”. Further, assume that the TWO company’s functional currency is the US Dollar (Z-US$), while the TEST company’s functional currency is the Canadian Dollar (Z-C$). Posting a transaction from TWO to TEST requires Dynamics GP to handle the conversion between these two functional currencies correctly, ensuring that the debits and credits balance within each company’s respective books and that the financial impact is accurately reflected in their functional currencies. This necessitates careful configuration of multicurrency settings, intercompany relationships, and exchange rate information.

Before attempting to post any intercompany transactions between TWO (Z-US$) and TEST (Z-C$), you must ensure that the system is configured to recognize and process transactions involving both currencies and the relationship between these two entities. The following steps detail the necessary configurations within Dynamics GP.

Step 1: Granting Multicurrency Access

The first foundational step is to ensure that both the originating and destination companies have access to the specific currencies and associated exchange rate tables that will be used in the intercompany transactions. In our scenario, this means granting both the TWO and TEST companies access to both the Z-US$ and Z-C$ currencies and any relevant exchange rate tables. Without this explicit access, the system will not allow transactions involving these currencies between these companies.

To configure this access, navigate within Dynamics GP using the system menu.

  1. Access the Multicurrency Access window. From the Tools menu, point to Setup, then System, and click Multicurrency Access. This window serves as the central point for controlling which companies can interact with which currencies and exchange rate data.
  2. In the Currencies area, select the first functional currency involved. Following our example, click on Z-US$.
  3. Observe the table adjacent to the Currencies area. This table lists all available companies. For each company that needs access to the selected currency – in this case, both the TWO originating company and the TEST destination company – click to select the Access check box. Enabling this checkbox authorizes the company to process transactions in, and hold balances in, the selected currency.
  4. Move to the Exchange Table IDs area. Exchange tables contain the specific exchange rates used for currency conversion. Select an exchange table identifier that is relevant for converting to or from Z-US$. In the table next to the Exchange Table IDs area, click to select the Access check box for both the TWO originating company and the TEST destination company for this selected exchange table ID. This step grants companies permission to use the rates defined within that specific table.
  5. If multiple exchange tables are relevant for transactions involving Z-US$ (perhaps one for spot rates, one for average rates, etc.), repeat step 1d for each relevant exchange table identifier. It is crucial that all necessary exchange tables are made accessible to both companies.
  6. Now, repeat the process for the second functional currency involved in the intercompany scenario. In the Currencies area, click on Z-C$.
  7. Just as with Z-US$, 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. This ensures both entities can handle Canadian Dollars.
  8. Finally, return to the Exchange Table IDs area. Select an exchange table identifier relevant for converting to or from Z-C$. In the table next to the Exchange Table IDs area, click to select the Access check box for both the TWO originating company and the TEST destination company for this selected exchange table ID.
  9. Repeat step 1h for any other exchange table identifiers needed for transactions involving Z-C$.
  10. Once you have granted access to all necessary currencies (Z-US$ and Z-C$) and their corresponding exchange tables for both companies (TWO and TEST), click OK to close the Multicurrency Access Setup window and save your changes.

Failure to grant appropriate access in this window is a common reason for errors when attempting to enter or post multicurrency intercompany transactions. Ensure that every currency and every exchange table potentially involved in the transaction flow between the companies has access granted to both entities.

Step 2: Establishing the Intercompany Relationship

With the multicurrency access configured, the next essential step is to define the intercompany relationship itself within Dynamics GP. This involves specifying which companies can transact with each other and, critically, which General Ledger accounts will be used to record the “Due To” and “Due From” balances that arise from these transactions. These accounts represent the reciprocal obligations between the entities – one company owes the other (“Due To”), while the other is owed by the first (“Due From”).

The Intercompany Setup window is where you define these relationships.

  1. Open the Intercompany Setup window. Go to the Tools menu, point to Setup, then System, and click Intercompany. This window displays existing intercompany relationships and allows for the creation of new ones.
  2. Identify the originating company. Click the lookup button next to the Originating Company ID field. In the Companies window that appears, select TWO (our originating company in the scenario) and click Select. This populates the originating company details in the setup window.
  3. Specify the destination company for this relationship. In the Destination Company Name area (or similar field depending on the GP version), click on the name TEST. This links the TWO originating company to the TEST destination company for intercompany transactions.
  4. Configure the “Due To” and “Due From” accounts for the originating company (TWO). In the Originating Company area, click the lookup button next to the Due to field. Select the appropriate General Ledger account from the Intercompany Accounts window that represents money owed by TWO to TEST. Click Select. This account will be used to record the liability in the originating company’s books.
  5. Still in the Originating Company area, click the lookup button next to the Due From field. Select the appropriate General Ledger account that represents money owed to TWO by TEST. Click Select. This account will be used to record the asset in the originating company’s books.
  6. Next, configure the reciprocal “Due To” and “Due From” accounts for the destination company (TEST). In the Destination Company area, click the lookup button next to the Due to field. Select the General Ledger account that represents money owed by TEST to TWO. Click Select. This is the liability account in the destination company.
  7. Finally, in the Destination Company area, click the lookup button next to the Due From field. Select the General Ledger account that represents money owed to TEST by TWO. Click Select. This is the asset account in the destination company. It’s crucial that the Due To account in one company matches the Due From account in the other from a logical perspective, ensuring that the intercompany balances offset across the entities (when viewed in a consolidated context).
  8. Once all four accounts (Due To and Due From for both Originating and Destination companies) have been selected, click Save to store this intercompany relationship configuration.
  9. Close the Intercompany Setup window.

It’s important to understand the currency context for these intercompany accounts. Dynamics GP will post the intercompany ‘Due To’ and ‘Due From’ entries in the respective functional currencies of the originating and destination companies. This is why you do not need to assign specific transaction currencies to these GL accounts within the Chart of Accounts setup. The system handles the translation based on the functional currencies of the entities involved and the exchange rates available. The balances in these accounts will always reflect the intercompany position in the company’s own functional currency.

Step 3: Setting Up Multicurrency Exchange Rate Tables

For Dynamics GP to accurately convert amounts between different currencies during an intercompany transaction, it needs access to current and correct exchange rates. This information is stored within Multicurrency Exchange Rate Tables. While you granted access to these tables in Step 1, you must ensure the tables themselves contain the necessary rate information for the currency pair involved (Z-US$ and Z-C$) and for the relevant dates.

This setup can typically be completed from either the originating or the destination company database, as exchange rate tables are often shared system-wide or can be maintained centrally.

  1. Navigate to the Multicurrency Exchange Rate Table Setup window. From the Tools menu, point to Setup, then System, and click Exchange Table.
  2. In the Multicurrency Exchange Rate Table Setup window, you will either create a new exchange table identifier or select an existing one. If creating a new one, provide a unique ID and description. If using an existing one, select it.
  3. Within the selected exchange table, define the exchange rates. You need to specify the currency ID (e.g., Z-US$ or Z-C$), the rate method (e.g., Average, Spot, Buy, Sell), and crucially, the specific exchange rates effective for different dates. For an intercompany transaction between Z-US$ (functional for TWO) and Z-C$ (functional for TEST), you need rates that allow conversion between these two currencies. The system will use these rates based on the transaction date. Ensure rates are entered for the direction of conversion needed (e.g., Z-US$ to Z-C$ and potentially Z-C$ to Z-US$).
  4. Click Save to store the exchange table configuration and the rates you’ve entered.

Maintaining accurate and up-to-date exchange rates is critical for precise intercompany accounting. Outdated or incorrect rates can lead to discrepancies in intercompany balances and inaccurate financial reporting. The rate method selected (e.g., ‘Average’ or ‘Spot’) will determine how the rate is applied and can impact the calculated functional currency amounts and any resulting realized or unrealized gains/losses.

Step 4: Assigning Rate Types to Exchange Tables

While you define rates within an exchange table, Dynamics GP uses ‘Rate Types’ to categorize how rates are used (e.g., for sales, purchases, average calculations, etc.) and to link specific business processes to the appropriate exchange tables. For intercompany transactions involving multicurrency, you must associate the exchange table(s) you configured in Step 3 with the relevant rate types used by the intercompany process. This tells Dynamics GP which table to look at when it needs an exchange rate for an intercompany transaction involving those currencies and rate types.

This step is particularly important and must be completed from the destination company database (TEST in our scenario).

  1. Access the Select Multicurrency Rate Types window. From the Tools menu, point to Setup, then Financial, and click Rate Types. This opens a window displaying existing rate types and their associated exchange tables.
  2. Identify the exchange table you configured in Step 3. Click the lookup button next to the Exchange Table ID field. In the Exchange Tables window, select the exchange table identifier you intend to use for multicurrency intercompany transactions between TWO and TEST (e.g., the table containing Z-US$/Z-C$ rates). Click Select.
  3. Once the exchange table is selected, the Select Multicurrency Rate Types window will show available rate types. In the Available Rate Types area, find the rate type(s) relevant for intercompany transactions. Common rate types might be ‘Average’, ‘Spot’, or specific types configured for GL transactions. Click on the appropriate rate type(s) you wish to associate with the selected exchange table.
  4. Click Insert. This moves the selected rate type from the ‘Available Rate Types’ list to the ‘Selected Rate Types’ list, effectively linking that rate type to the chosen exchange table. This tells Dynamics GP: “When you need a rate for this type of transaction, look in this exchange table.”
  5. Click Save to apply the changes.

By assigning the relevant rate types to the configured exchange table within the destination company, you ensure that Dynamics GP knows where to find the necessary currency exchange rates when processing an intercompany transaction initiated from the originating company and destined for this entity. This linkage is essential for the system to perform the correct currency conversions.

The Intercompany Posting Process with Multicurrency

Once these foundational setup steps are complete, you are ready to post multicurrency intercompany transactions. When you enter an intercompany transaction in the originating company (TWO), specifying amounts that will affect the destination company (TEST), Dynamics GP performs the following key actions upon posting:

  1. Recording in Originating Company: The transaction is recorded in the originating company’s books (TWO) using its functional currency (Z-US$). The intercompany ‘Due From’ or ‘Due To’ account is updated accordingly in Z-US$.
  2. Sending to Destination Company: Dynamics GP automatically generates a corresponding transaction for the destination company (TEST).
  3. Currency Translation: The amounts designated for the destination company are translated from the originating company’s functional currency (Z-US$) into the destination company’s functional currency (Z-C$). This translation uses the exchange rate determined by the transaction date and the rate type linked to the exchange table configured in the previous steps.
  4. Recording in Destination Company: The translated transaction is recorded in the destination company’s books (TEST) using its functional currency (Z-C$). The reciprocal intercompany ‘Due To’ or ‘Due From’ account is updated in Z-C$.

Because the transaction is translated into each company’s functional currency using the defined exchange rates, the individual company’s financial statements will accurately reflect the transaction in their own currency. Any difference that arises from the exchange rate used at the time of posting versus a different rate used later for reconciliation (e.g., at month-end) will be reflected as a realized or unrealized currency gain or loss in the respective company’s financials, depending on how the intercompany account is set up and managed.

Successfully navigating these setup steps ensures that Dynamics GP can automate the complex currency conversions required for cross-entity transactions, streamlining the intercompany process and maintaining data integrity across your organization’s disparate financial entities.

Common Considerations and Best Practices

While the steps above cover the core setup, consider the following points for a robust multicurrency intercompany environment:

  • Exchange Rate Maintenance: Establish a clear process for regularly updating exchange rates in your exchange tables. Relying on outdated rates will lead to inaccurate translations and potential reconciliation headaches.
  • Rate Methods: Carefully choose the appropriate rate method (e.g., Spot, Average) for your intercompany transactions based on accounting standards and internal policies. Ensure consistency in how rates are applied.
  • Intercompany Account Reconciliation: Despite the automated posting, regularly reconcile the intercompany ‘Due To’ and ‘Due From’ accounts between entities. Variances can arise from various factors, including exchange rate fluctuations between transaction date and reporting date, or errors in setup.
  • Historical Rates: Understand how Dynamics GP handles historical rates. For certain transaction types (like fixed assets or historical cost basis items), you might need to use specific historical exchange rates rather than current ones.
  • Reporting and Consolidation: Ensure your reporting tools and consolidation processes are equipped to handle multicurrency data from entities with different functional currencies. The accurately posted functional currency amounts from these steps are the foundation for accurate consolidated financials.

By diligently following these essential steps and incorporating best practices, you can significantly streamline your multicurrency intercompany transaction processing within Microsoft Dynamics GP, leading to improved efficiency and accuracy in your cross-entity financial operations.

Have you implemented multicurrency intercompany transactions in Dynamics GP? What challenges did you face during setup, and what strategies did you find most effective? Share your experiences and tips in the comments below!

Post a Comment