API error 37003 line total is unbalanced

[Phurby]

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 · Accepted solution]

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]

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