I have an Item PO, which now I want to turn to Bill. Some items are to be backordered, I have adjusted the quantities to reflect the backorder under Bill, Received & Backorder columns, the value of the invoice is correct, but upon recording it tells me "Error: an unbalanced transaction may not be recorded". Everything balances, what is it going on about? Thanks! Elle

If anyone goes through this issue in the future, I found the answer myself. As it turned out, the bill was not ticked GST inclusive (it doesn't have to be, MYOB please fix this). But after reading this post: https://community.myob.com/t5/AccountRight-Sales-and-purchases/Unbalanced-Transaction-when-trying-to-record-a-purchase/td-p/447263 I decided to tick it and to manually enter the values, even though they were already there. When I manually entered the values while Tax Inclusive was not ticked - it didn't work, it only worked when I ticked it. Done, I have backorder and hopefully no more issues when I receive the bill for it. Thanks, Eliane

Eliane

Trusted Cover User

5 years ago

Solved

Turning Order into Bill Error

I have an Item PO, which now I want to turn to Bill. Some items are to be backordered, I have adjusted the quantities to reflect the backorder under Bill, Received & Backorder columns, the value of the invoice is correct, but upon recording it tells me "Error: an unbalanced transaction may not be recorded".

Everything balances, what is it going on about?

Thanks!

Elle

Eliane
5 years ago
If anyone goes through this issue in the future, I found the answer myself.

As it turned out, the bill was not ticked GST inclusive (it doesn't have to be, MYOB please fix this).

But after reading this post: https://community.myob.com/t5/AccountRight-Sales-and-purchases/Unbalanced-Transaction-when-trying-to-record-a-purchase/td-p/447263 I decided to tick it and to manually enter the values, even though they were already there. When I manually entered the values while Tax Inclusive was not ticked - it didn't work, it only worked when I ticked it.

Done, I have backorder and hopefully no more issues when I receive the bill for it.

Thanks,

Eliane

6 Replies

Replies have been turned off for this discussion

Jesh_D
Former Staff
5 years ago
Hi Eliane

Thank you for your post.

Typically with these 'An unbalanced transaction may not be recorded' errors are the result of 3 decimal places in the line item causing the transaction to be unbalanced, although we may not see this extra decimal it is calculating. The way around it is to click in the field and manually type the amounts. This should bypass the issue.

Please let us know how you get on and if you require further assistance.
Eliane
Trusted Cover User
5 years ago
Hi Jesh_D

Thanks for replying, but I tried that just now, it didn't work.

I typed in the per kg price and the total for each line.

There's a backorder for this PO, so we only want to record the bill for what's received. The quantity on the backorder column is correct.

What else could be wrong? And what else can I try?

Thanks!
Eliane
Trusted Cover User
5 years ago
Jesh_D

In addition, I have noticed that when I am on Bill window and I change the bill column to what's received, the backorder for one of the items automatically adjusts to the correct backorder figure, however the other item does not, I have to manually type in there. Would this be the culprit? Why does one item do it and the other doesn't?

Thanks!
Eliane
Trusted Cover User
5 years ago
Jesh_D

Anyone know how to fix this problem? I'd like to record the PO as a bill.

Thanks!
Eliane
Trusted Cover User
5 years ago
If anyone goes through this issue in the future, I found the answer myself.

As it turned out, the bill was not ticked GST inclusive (it doesn't have to be, MYOB please fix this).

But after reading this post: https://community.myob.com/t5/AccountRight-Sales-and-purchases/Unbalanced-Transaction-when-trying-to-record-a-purchase/td-p/447263 I decided to tick it and to manually enter the values, even though they were already there. When I manually entered the values while Tax Inclusive was not ticked - it didn't work, it only worked when I ticked it.

Done, I have backorder and hopefully no more issues when I receive the bill for it.

Thanks,

Eliane
Jesh_D
Former Staff
5 years ago
Hi Eliane

I do apologise for not responding sooner. The post you had found was my next point of call, so I am glad that it has worked and that the error is resolved. If, however, this pesky error comes back please do let us know and will take another look at it.

Forum Discussion

Turning Order into Bill Error

6 Replies

Looking for something else?

Related content

Purchase Orders - Turn Off Automatic Numbering

Turning off automatic invoice reminders

Turn off multi currency

Item Purchase Order Validation Errors

ValidationException error on recurring purchase order

ATO Lodgement Errors

Can't see purchase order list

Converting Purchase order to a bill ( Error)