| Please can anybody help with this errorDocument No. 2024BACKLOG is out of balance by -1,129,162.5. Please check that Posting Date, Document Type, Document No. and Amount are correct for each line. |
|---|
I import an excel file into the journal for post and i am getting that error, on my excel the debit and credit are balance.
Please help someone…………….
Peter - to eliminate that the import is missing an unexpected field to populate create a manual journal entry duplicating an entry you are importing and view all the table fields that are populated - just to eliminate a field that may not be being populated by your import.
Best Regards
John Grant - Innovia Consulting
Hi Peter,
This is a classic import error in Dynamics 365! That specific imbalance amount is usually caused by the system misinterpreting the data formatting, even if your Excel looks balanced.
Try these quick checks, as they solve the issue 90% of the time:
Check Number Formatting (The #1 Culprit): In your Excel file, ensure the Amount columns use only the single correct decimal separator for your Dynamics environment and remove all thousands separators (commas or periods). The system is likely misreading your millions value.
Verify Balancing Account: Confirm that every single line in the template has both the Balancing Account Type and Balancing Account No. fields are correctly populated.
I hope one of these quick fixes solves it! This methodology worked for our previous projects; might it work for you as well? If you still need deep technical help with your journal template or custom code, please feel free to shoot an email directly to me at hardik.gupta@allgrowtech.com. Good luck!
Hi @Peter_Ayeyemi,
This error arrises because you have cheked the option “Force doc. balance” in the general journal template you are using:
If this option is checked, the general journal lines must be balanced for each “Posting Date” & “Document Type” & “Document no.”.
And as @Hardik_Gupta said, is important that, if you have some line with a “Balance Account No.”, you don’t have to sum this line to check if all lines are balanced (this lines are auto balanced).
Best regards.
Posting Date, Document Type, Document No. and Amount - System validates the journal before posting based on these combination. I wont suggest to disable that flag on journal template. Make sure system is in sync with these 4 columns and you will be good to go.
