Difference in Customer account statements

(0) Share

Report

Posted on by Community Member

I have one Export Customer. I am matching his closing balance of year 14-15. I checked his figure on different reports and customer transaction, there is having some difference in that.

Customer currency is GBP and my reporting, accounting currency is INR .

1. Customer account statement : 14054335 INR

2. Internal account statement : 16687035 INR

3. Customer Balance List : 16687035 INR

4. Customer Transaction in period 14-15 : Net 16687035 INR

5. When i goes for settlement of a customer till 31-03-2015 : 14054335 INR

I am not understanding how system is taking all those different figure in all cases.

When i checked in account statements reports for open transaction it is showing 5 open sales order but Now i already cancelled those sales order and their status is not opened now.
But they still coming in open transaction on account statements report.

It is really become very confusing to me . Please help me out to solve out and understand those things.

It is also happening some other ledgers account in trial balance. System showing figure in closing balance is different form its net transaction balance at that time period.

THanks is advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Is it possible that you provide some more details on how what parameters you selected when you run the reports?

Also here some screenprints might help.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shivendra,

When there are transactions settled with a wrong date, you can have some differences, but I was always assuming that the Customer account statement and internal account statement were running the same logic.

Assuming you have an invoice e.g. posted on December 20, 2015 and the payment is on March 12, 2016. It is possible with a wrong user action to post the settlement on December 20, 2015 or another date. In that case a report can show a wrong balance. Can you check the settlement dates for this customer?

For the trial balance, you can rebuild the balances from the Dimension Sets. Then see if that solves the problem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I already done the Rebuild balances.

My question is for opening transaction in account statement reports after closing the open sales order why it is still showing them in open.

Customer account statement and internal account statement both showing those sales order in open one but internal is taking their amount in total one and Customer AS is not taking their amount in total.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shivendra,

I assume you mean an open invoice with "open sales order"? If you have settled this invoice, what date was the payment posted and what settlement date is used?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I guess the problem is with CustTrans_W table data being not populated for some of the records. which is causing the issue in Customer balance list report

Was this reply helpful? Yes No