Automated Accounting Part 5, Intercompany Customer Payments
Updated: Aug 29
Today we will expand on https://www.365financearchitect.com/post/automated-accounting-intercompany-ledger-journals by adding functionality for Recording Cash Receipts in one company, on behalf of Accounts Receivable in another company.
1. Chart of Accounts
The Chart of Accounts setup will be the same as prior post.
2. Intercompany accounting
In addition to the Intercompany setup we did previously (same as the link above) you may want to edit some of settings for Centralized Payments. You can setup like the exhibit, or change based on your preference.
General ledger > Posting setup > Intercompany accounting > Centralized payments
3. Journal Names
Create a Customer Payment Journal as exhibited.
General ledger > Journal setup > Journal names (new)
4. Customer Payment Journal
Create a Customer Payment Journal
Right Click and choose Insert Fields to add a field for "Account Type" to the Customer Payment journal lines.
In this scenario, we will
post journal in Company US01,
deposit in Company US01.
credit the Customer in US02.
Create a new CustPay journal with the following lines and click "Post".
You can used any currency that is setup in your system. I chose to use GBP.
Accounts receivable > Customers > Payments > Customer payment journal
Within the journal click "Voucher" to see the US01 voucher.
Click "Related Vouchers" to see the voucher in US02.
Note: My focus is on the "Transaction" currency, thus I have hidden the "Amount" field.
The "Amount" field will display the related 'Accounting' currency values for your system.
In summary, Dynamics 365 has :
automatically coded the entry to the Bank and Customer accounts in the proper companies, automatically filled in the lines for the corresponding Intercompany Receivable and Payable accounts, and
automatically posted the journal in the related company (US02).