We are importing D365 Finance and Operations tables into Azure SQL DB for internal datawarehouse reporting.
The list of tables
1. CUSTTABLE
2. CUSTTRANS
3. CUSTTRANSOPEN
4. CUSTSETTLEMENTS
5. GENERALJOURMALENTRY
6. GENERALJOURNALACCOUNTENTRY
and many other.
I want to create Customer Aging report as off certain date.
To get the customer balance, I am Aggregating AMOUNTMST
How can I get the balance by Transaction (I mean by voucher)?
I have noticed that an account is showing Outstanding Balance as ZERO but if I see the transactions, there is a balance of around £500. This is due to that 2 vouchers were settled(SETTLEAMOUNTMST) higher than the AMOUNTMST.
How do I get the transaction balance? There might be EXCHADJUSTMENTs.
What is the formula for the transaction level balance?
I don't know precisely the outcome requirement, but my suggestion is to use as DataSouce the CustTrans.
You can use all the transaction type, or add the possibility to filter based at least the transaction type (Customer, sales order, payment, etc..).
Why the STD report isn't good?
The difference can all us to be more specific on the feedback.
From OOB function you can already have the balance at a certain date:
Thank you,
Giorgio
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
65
Share
Report
All responses (
Answers (
