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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!
Hi mveetee,

Try something like this -

CUSTTRANS.AMOUNTMST - CUSTTRANS.SETTLEAMOUNTMST

Was this reply helpful? Yes No