Finance | Project Operations, Human Resources, ...

Customer Ageing report Balance Function calculation

(0) Share

Report

Posted on by Community Member

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

All responses (3)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report
RE: AX 2012 Customer Ageing report Balance Function calculation

Hi mveetee,

Try something like this -

CUSTTRANS.AMOUNTMST - CUSTTRANS.SETTLEAMOUNTMST
Community Member on at

Like (0)

Report

RE: AX 2012 Customer Ageing report Balance Function calculation

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
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: AX 2012 Customer Ageing report Balance Function calculation

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?