Dynamics Community Forum Thread Details

Wrong data in Ledger reconciliation report after changing customer group

Hi Team,

I have a scenario that difficult to understand, please help to take a look on this:

After changing Customer group, the Customer to Ledger reconciliation report shows the wrong difference between Customer and Ledger.

Here is the step I have taken:

Go to All Customers > Choose a customer. It has a default Customer Group as ‘10’ posting to the 130100 main account.

Raise a free text invoice for this customer.
Run the Customer to ledger reconciliation report.
Go to All Customer > Choose this customer > Change the Customer Group to ‘90’ which is posting to the 1333300 main account.
Rerun the Customer ledger reconciliation report.

8865.Result.PNG

- As I can see:

The transaction has moved from the main account of 1300100 to the new main account posting (133300) which is correct.
However, the balances have not transferred.
130100 shows the ledger balance with no customer balance and therefore calculates the obvious discrepancy.
133300 is wrong and where the issue lies. The customer balance is there from the recent change in Customer group, but the ledger balance is not present. The difference column does not calculate the differential between these too.

The expected result should be:

6138.Expected-result.png