Ledger Account discrepancies with Account and financial dimension

(0) Share

Report

Posted on by Mounir Ahmad

145

Hi

later I used a class to delete all transactions, but notice some discrepancies for posted voucher.

pop-up for account segment was right but voucher post not the same as Pop-up, check below.

any suggestion

All responses (5)

Answers (1)

Suggested answer

MhaU on at

Like (0)

Report

RE: Ledger Account discrepancies with Account and financial dimension

Dear Mounir Ahmad,

Apologies for the delay.

The best practice to apply is not to delete data from dimension tables. This is something that generates data integrity issues.
Mounir Ahmad 145 on at

Like (0)

Report

RE: Ledger Account discrepancies with Account and financial dimension

Dear Mihaela Ursu

how to verify this issue will not accrue next time?
Verified answer

MhaU on at

Like (1)

Report

RE: Ledger Account discreteness with Account and financial dimension

Dear Mounir Ahmad,

Can you please check data from tables GENERALJOURNALACCOUNTENTRY and DIMENSIONATTRIBUTEVALUECOMBINATION? I guess the discrepancy comes from financial dimensions. Some data integrity issues you might have created while deleting transactions depending on which tables you affected.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Ledger Account discreteness with Account and financial dimension

Good morning Mounir Ahmad,

Can you let us know what class you used for deleting the transactions?

Also, can you specify why you deleted them?

Some additional information on the screenprint that you shared would also help because it can hardly be read.

Many thanks,

Ludwig
SouravDam 11,723 on at

Like (0)

Report

RE: Ledger Account discreteness with Account and financial dimension

Hello Mounir Ahmad,

Appreciate if you kindly elaborate!

After deleting all transactions; where you are seeing these transaction details?

Best regards,
Sourav Dam