Forum Discussion

Eliane's avatar
Eliane
Trusted Cover User
5 years ago

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

  • Jesh_D's avatar
    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's avatar
      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's avatar
      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's avatar
      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's avatar
        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

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content