NAV: Intercompany Transactions
- Veronika Zagrapanova (Deactivated)
- Lucie Odehnalová
Overview
This document is a quick reference guide explaining typical scenarios with regards to Intercompany transactions.
Intercompany
The aim of the Intercompany functionality is to help users to transfer transactions between two companies in the same organisation.
Scenario 1: Bank Account in Company BE receiving a payment of EUR 10,500 from Customer FC to cover invoices outputted from Company NL.
In NAV, select Company BE and go to the Intercompany General Journal
Change/Select the Batch Name other than Default e.g. ICO-FA-A
Record the transaction by populating the following fields:
Posting Date
Document Type – set as Payment
Document No. – this should load automatically. If not, please click on the button “Renumber Document Numbers”
Account Type – must be equal to IC Partner
Account No. – select the Company that you wish to transfer the amount to, in this case it’s 201 NL Netherlands. The IC Partner Code column should automatically populate with the same value. If this does not happen, please raise an issue with support.
Description – please include a meaningful Description that allows other users to understand the transactions. In most cases, this should match the description from the bank statement.
Currency Code – in this scenario we are using EUR
Amount – enter the actual amount to be transferred as a negative value
Bal. Account Type – select Bank Account
Bal. Account No. – select the Bank Account in BE, in this case it’s BBE15
IC Partner G/L Account No. – select the Trade Receivables control account 10810
Country Dimension – Please select a value if required
Division Dimension – Please select a value if required
Customer Group Dimension – Please select a value if required
Post the transaction
As part of this manual, I have included a change so that on posting of a transaction into another company, NAV/ Business Central automatically sends the transaction to the other company, without the need to go to the Intercompany Outbox Transactions. This means that if we now go into Company NL, we should see the transaction in the Intercompany Inbox, as shown below:
Accept the transaction from the screen and transfer the transaction onto the journal, using the Complete Line Actions button:
Populate the highlighted fields above with the correct values and click OK. NAV/BC will transfer such record into the selected journal as shown below:
Update the second line with Customer No. in the Account No. field.
If the client has also provided a Remittance, then you can also apply the payment to the corresponding ledger entries for the customer from within the journal, before posting the actual payment. In this case, please use the Apply Entries button:
Scenario 2: Transferring a Customer transaction in Company BE of EUR 5,600 to another Customer account in Company NL
In this case, the funds were already posted into the Customer account in BE, thus the main difference from scenario 1 is that we are transferring the value from a customer account instead of a bank account.
In company BE, open the Intercompany Journal and create the following transaction:
Posting date
Document Type – set as Refund
Document No. – this should load automatically if the correct journal is selected. If not, please click on the button “Renumber Document Numbers” or raise a support ticket.
Account Type – must be equal to IC Partner
Account No. – select the Company that you wish to transfer the amount to, in this case it’s 201 NL Netherlands. The IC Partner Code column should automatically populate with the same value. If this does not happen, please raise an issue with support.
Description – please include a meaningful Description that allows other users to understand the transactions.
Currency Code – in this scenario we are using EUR
Amount – enter the actual amount to be transferred as a negative value
Bal. Account Type – select Customer
Bal. Account No. – select the Customer No.
IC Partner G/L Account No. – select the Trade Receivables control account 10810.
Country Dimension – Please select a value if required
Division Dimension – Please select a value if required
Customer Group Dimension – Please select a value if required
Post the transaction
Open Company NL
Go to the Intercompany Inbox Transactions
Select Accept and click on the Complete Line Actions button
Open the Intercompany Journal to view the generated transactions:
Populate the second entry with the correct Customer No., inputting it into the Account No. field.
Update the Document Type field from Refund to Payment for both entries:
If the client has also provided a Remittance, then you can also apply the payment to the corresponding ledger entries for the customer from within the journal, before posting the actual payment. In this case, please use the Apply Entries button.
Post the entries and verify that the correct result has been achieved.
Scenario 3: Bank Account inCompany BE receiving a payment of EUR 8,200 from Customer FC to cover invoices outputted from Company NL. This transaction has yielded a bank charge of EUR 8.05. In summary, the Statement Amount shows as EUR 8,191.95, Bank Charge is EUR 8.05 and Customer Payment Amount is EUR 8,200.
This example is the same as Scenario 1, having said that it will involve an additional transaction due to the Bank Charge incurred.
In NAV, select Company BE and go to the Intercompany General Journal
Change/Select the Batch Name other than Default e.g. ICO-FA-A
Record the 1st transaction by populating the following fields:
Posting Date
Document Type – set as Payment
Document No. – this should load automatically. If not, please click on the button “Renumber Document Numbers”
Account Type – must be equal to IC Partner
Account No. – select the Company that you wish to transfer the amount to, in this case it’s 201 NL Netherlands. The IC Partner Code column should automatically populate with the same value. If this does not happen, please raise an issue with support.
Description – please include a meaningful Description that allows other users to understand the transactions. In most cases, this should match the description from the bank statement.
Currency Code – in this scenario we are using EUR
Amount – enter the actual amount to be transferred as a negative value
Bal. Account Type – select Bank Account
Bal. Account No. – select the Bank Account in BE, in this case it’s BBE15
IC Partner G/L Account No. – select the Trade Receivables control account 10810
Country Dimension – Please select a value if required
Division Dimension – Please select a value if required
Customer Group Dimension – Please select a value if required
Record the 2nd transaction by populating the following fields:
Posting date
Posting Date
Document Type – set as Payment
Document No. – this should load automatically. If not, please click on the button “Renumber Document Numbers”
Account Type – must be equal to G/L Account
Account No. – Please select the G/L Account for Bank Charges. This should be Account No. 82110
Description – please include a meaningful Description that allows other users to understand the transactions. In most cases, this should match the description from the bank statement.
Currency Code – in this scenario we are using EUR
Amount – enter the actual amount to for the Bank Charge as a positive value
Bal. Account Type – select Bank Account
Bal. Account No. – select the Bank Account in BE, in this case it’s BBE15
Country Dimension – Please select a value if required
Division Dimension – Please select a value if required
Customer Group Dimension – Please select a value if required
Post the transactions
Go to company NL, and load the Intercompany Inbox
Accept the transaction from the screen and transfer the transaction onto the journal, using the Complete Line Actions button:
Populate the highlighted fields above with the correct values and click OK. NAV will transfer such record into the selected journal as shown below:
Update the second line with the Customer No. in the Account No. field.
If the client has also provided a Remittance, then you can also apply the payment to the corresponding ledger entries for the customer from within the journal, before posting the actual payment. In this case, please use the Apply Entries button:
Post the Journal