Forum Discussion

Phurby's avatar
Phurby
User
5 years ago
Solved

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

  • John_Dinning's avatar
    John_Dinning
    5 years ago

    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.

2 Replies

Sort By
Replies have been turned off for this discussion
  • John_Dinning's avatar
    John_Dinning
    Trusted User
    5 years ago

    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
      User
      5 years ago

      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

Related content