Search
  • 365 Finance Architec

Automated Accounting Part 5, Intercompany Customer Payments




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.

https://www.365financearchitect.com/post/automated-accounting-intercompany-ledger-journals


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


5. Vouchers

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).


47 views1 comment

Recent Posts

See All