Customer Balance and Total Amount MST vary in Customer balance form

(2) Share

Report

Posted on by Community Member

Dear all,

Been struggling with this issue on Dynamics Ax 2009. Customer balance is different from total MST balance. What can be responsible for this please. I even have this variance in customer accounts that transact in only default currency.

Sales Ledger Module/Customer details/Balance Button

thanks in anticipation

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sachin Ahuja 360 on at

Like (0)

Report

Can you please share the screenshot where you are seeing this difference?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks

Was this reply helpful? Yes No
Sachin Ahuja 360 on at

Like (0)

Report

These two balances are calculated from Customer Transactions and Customer Open Transactions.

You can copy the transactions from both the tables and can check where is the mistake.

I have also faced the same scenario in past and found Difference was lying in open transactions and corrected through data fix.

Reason of this was customization done to the invoice posting process.

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Hi ,

Can i know what is the difference between Customer Transactions and Customer Open Transactions ?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Sachin,

Can you please specify what difference you got in open transactions and how did you correct it through data fix?

Regards,

Was this reply helpful? Yes No
E. R. 739 on at

Like (0)

Report

I am facing the same issue, can anyone help? I already found the invoice amount in the custtrans table which is settled (not available in custtransopen table) but in the customer balance form it is counted. please help!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Elie,

We have the same issue when performed settlement for Vendor. Vendor Balance form shows different result for accounting currency. The issue was not fixed yet but we found that the difference incurred automatically as the exchange rate adjustment.

Hope this information can help you to investigate.

Was this reply helpful? Yes No