Hi Guys. can you help me please to solve the following error in celigo: “Failed to save record because Transaction was not in balance. Total = xxx” this error prevent the invoice to be created, when i investigated i found that the tax code is not importing properly. is there anyway to fix this issue?? thanks --------------------------Request Data-------------------------------- importing record: {"nlobjRecordType":"invoice","nlobjFieldIds":{"celigo_nlobjTransformId":"456772","celigo_nlobjTransformType":"salesorder","shippingtaxcode":-8,"shippingtax1rate":0},"nlobjSublistIds":{"item":{"lines":[{"line":"1","taxcode":-8,"taxrate1":7.00087511}]}},"documentIndex":5,"INTEGRATOR_IO_MAPPER":true} nlapi calls registered for $R: r = nlapiTransformRecord("salesorder", 677626, "invoice", {}); r.setFieldValue("shippingtaxcode", -8); r.setFieldValue("shippingtax1rate", 0); r.selectLineItem("item", 1); r.setCurrentLineItemValue("item", "line", "1"); r.setCurrentLineItemValue("item", "taxcode", -8); r.setCurrentLineItemValue("item", "taxrate1", 7.00087511); r.commitLineItem("item"); nlapiSubmitRecord(r, false, false); ----------------------------------------------------------------------

I'm guessing this didn't work? https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1688665555566239