Forum Discussion

Phurby's avatar
6 years ago

API error 37003 line total is unbalanced

When using the API (I'm working on an item bill) I am unable to modify a line item total, or add a new item. I end up with the error code 37003  which says "The line total is unbalanced". Is there any way for the API to get around this or is it intended that the API is unable to modify a line item?

 

Thanks, Phu

  • If I remember correctly, I found that the line total is not actually required when posting to the API (although the doc says it is) and can cause 'Line Total Is Unbalanced' Errors.

     

    Set the BillQuantity but not the Total. AccountRight will calculate the total itself.

     

    John.

  • If I remember correctly, I found that the line total is not actually required when posting to the API (although the doc says it is) and can cause 'Line Total Is Unbalanced' Errors.

     

    Set the BillQuantity but not the Total. AccountRight will calculate the total itself.

     

    John.

    • Phurby's avatar
      Phurby

      That did the trick. I had just taken the API requirements documentation as gospel, which had stated the Total is a required field. Removing the Total and setting the BillQuantity and UnitPrice instead allowed me to proceed with the update without any errors.

       

      Thanks very much,

      Phu