Hello Guys,
In AX 2012 / Axapta - Under Sales Ledger, Report - Customer Aging. How can i derive this Balance calculation which is used in Customer Ageing report. The system name for Balance = RemainAmount
CustTrans.RemainAmountCur()
Hi mveetee,
Try something like this -
CUSTTRANS.AMOUNTMST - CUSTTRANS.SETTLEAMOUNTMST
Thanks for the reply. I'm recreating Customer Ageing report by using SQL. I know their is custom report already, but my Sales team want a report to be created with SQL. I managed to get every fields and all my calculation are coming correct except Balance, where I'm struggling to find the right total against each customer. I'm using AMOUNTMST from CustTrans, but their is still some error. So ideally would be good to know "Balance" back end calculation. Any help will be much appreciated. Regards
Hi mveetee,
The balance is calculated in the report. CustTrans.RemainAmountCur() will get you the balance per transaction.
Could you please state your exact requirement here?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (