You’re offline. This is a read only version of the page.
156
Hello All,
Unable to complete year end closure in UAT as the Trial balance is imbalance. I have identified the two entries giving rise to the difference as these transactions. they are sale order transactions normally integrated in AX from CRM. The transaction appeared posted correctly in members account and reviewing the vouchers, it appears the income general ledger side of the transactions were not posted.. However, when checking the General Journal Account Entry table, both sides of the transaction ( Sales journal to customer and income side to income ledger code appeared.
I have run the consistency check and this hasn't shown any error.
Please how else can I investigate this issue. Production environment has closed successfully as we don't have same data in both environments
Any tips will be appreciated.
Thanks
Fade
Hello Fade,
Have you been able to make some progress with this issue and have you been able to get it fixed in the meantime?
Best regards,
Ludwig
Dear Fade
Thank you for posting this issue to our community.
Please let us know if you already rebuild balances for all dimensions sets.
Please provide further more details, you mean that in Trial balance you see some imbalances but in GeneralJournalAccountEntry and DimensionAttributeValueCombination tables all looks good but even so in TB you see some issues.
It would be best if you open a Support Request to have a better look on the data.
Hi Fade,
I do understand that you don't have this issue in production, but only in UAT. What is the exact difference amount? You can check if it is caused by decimal rounding. If so, you need to adjust the integration to round the amount on 2 decimals when you put the value in AX.
Hello Fade,
Can you share details about the two entries that you identified?
Do you have some transactions pending in the subledger journal not yet transferred form in GL?
Best regards,
Ludwig
#1
Martin Dráb
445
Most Valuable Professional
#2
Abhilash Warrier
310
#3
Saalim Ansari
261
Share
Report
All responses (
Answers (
