Share
Report
20Hello,
I am in the process of uploading opening balances prior to Go Live and I have some questions related to upload the balances to D365 FinOps and create a reconciliation.
I was following the blog (+) Migrate Opening Balances From Ax2012 To D365 F&O - Dynamics 365 Finance Forum Community Forum However, it does not resolve to my question.
In the specific case of customers balances. Steps that I followed are
- Upload in GL journal the value from Trial balance to the ledger Account receivables against ledger account 99999. For example 100000
- Debit – Ledger account "99999" = 100000
- Credit – Ledger account “Account Receivables” with the total value from Trial Balance = 100000
- Upload Customer open transactions
- Debit – Ledger account 99999 = 30000
- Credit – GL Journal account type "Customer" with the open transactions (Without VAT) to hit the customer balance (Customer posting profile) = 30000
- Reallocation journal
- Debit – Ledger account “Account Receivables” with the value from Customer open transactions = 30000
- Credit – Ledger account "99999" = 30000
After the transactions I run 2 reports
- Customer aging report - Which is matching to the customer opening balance = 30000
- Customer to ledger reconciliation report - There is a difference of 40000
- Customer Balance = 30000
- Ledger (Account receivable) = 70000
How do I reconcile the Customer to ledger reconciliation report if I do not have the detail of the closed transactions?
All responses (
Answers (
