Turning Order into Bill Error

[Eliane]

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

[Jesh_D]

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]

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]

@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]

@Jesh_D  

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

Thanks!

[Eliane · Accepted solution]

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... 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]

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.