General Journal Posting error - "The transaction on voucher do not balance as per ..."

(0) Share

Report

Posted on by Community Member

Hello Brains Trust,

This one is stressing and distressing me. I have loaded a rather large GJ and it is validated with no issues. However, when I go to post it, I get the below error for every single one of those vouchers. I have, in my screenshot below, collapsed them to show a simple voucher.

I have done the following to try to solve them:

- Journal balances at the total level

- Every voucher has been checked and they all balance as well including the one below

- I re-entered the amounts for the below 4 lines manually, in case it was picking up perhaps stray decimals, but it still errors

- Compared to a successfully posted journal and could not find any difference

- I've threatened it with deletion... It's got nerves of titanium!

Please help! It is month end (coz when else would this fail me) and panic is setting in.

Regards

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hello Satrangi,

If you already ensured that the number have only 2 decimals then I only know the 'post and transfer' button trick.

Try if you can post and transfer those lines in a new journal that can be posted.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hi Ludwig,

Thank you for this suggestion. I tried it with the journal and only one of 117 vouchers actually posted.

Not the one I made changes to, I might add.

I have gone through and checked what it is about this voucher that is different, however, I am stumped. I can't see anything different.

Was this reply helpful? Yes No
MYGz 2,131 on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hi Satrangi,

If you have a systemadmin role, Check amountcurcredit, amountcurdebit fields in LedgerJournalTrans table if there are additional decimals present.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Good Morning Satrangi,

How did you do the upload? Through DIXF or with the help of the Excel add in for GL journal uploads?

Did the upload work previously?

The only thing left that comes to my mind is applying the Excel rounding function to the data that you upload to the journals to ensure that there is no issue with the decimal places.

If this does not work, ask a colleague if he/she can do the upload and if also this one does not work then you might have to create a new Excel template as it might have been corrupted.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hi MYGz,

I do have access and looked at this table as you suggested. The whole lot is at 2 decimal places. I guess that clears my worry of what if there are trailing decimals. Now the question is what else it could be.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hi Ludwig,

Yes, the load was via DIXF. In fact, the load file was over 21k lines. I broke it down into 11 smaller journals and loaded each one of them, making sure they all balanced at voucher level. 10 out of the 11 have posted. This one is the only one that is giving me an error.

I do understand what you mean about corrupted files. I will try and load a "fresh" one and see if it works.

Was this reply helpful? Yes No
MYGz 2,131 on at

Like (0)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Not yet. If you are seeing only 2 decimals in ledgerjournaltrans then you will have to look for it from SQL server management studio.

Write and run this query:

Select journalnum,voucher, amountcurdebit,amountcurcredit from MicrosoftDynamicsAX.dbo.LedgerJournalTrans where journalnum='Insert_your_journal_batch_number'

MicrosoftDynamicsAX or whatever is the name of your ax database.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: General Journal Posting error - "The transaction on voucher do not balance as per ..."

Hi everyone,

The strangest this happened. I had an AX consultant in the office yesterday so I decided to show this journal to him. He validated the journal and then clicked post to see the error but it just posted instead! No changes were made as I had not touched the journal at all since the day before! How strange is it that the journal would post with no issues without any changes?

Was this reply helpful? Yes No