Hi -
I'm creating vendor bills with the SOAP API for a company. Some are created successfully, and some fail with the message please enter value(s) for tax code.
I'm wondering what the difference could be. I compared one successful and one that failed. The only thing different on the two invoices that I'm setting as far as I can tell are different vendors, and different Other Charge Purchase items for the lines.
Any ideas of what it could be or how to figure this out? This has been a longstanding integration where the way we create other charge purchase items has not changed and has worked across 20+ different clients / netsuite accounts, but some of these errors are coming up recently. This is a Canadian client. Thanks!
When I load some related data with suiteQL:
- There's no tax info at all on the different 1st items for either
- The default tax item on the 2 vendors are the same
- Subsidiaries are the same on vendor bill
- Vendor bill forms are the same
- Accounting periods are the same
- Currency is the same
- project getting set on the lines is the same
Vendor Bill Post requests (successful, then failure)
successful:
unsafe:soapenv:Body
<tranId>12436</tranId>
<tranDate>2025-09-30T00:00:00</tranDate>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>517811.00</rate>
<amount xsi:type='xsd:double'>517811.00</amount>
<description xsi:type='xsd:string'>Building C - Structural Package</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>517881.00</rate>
<amount xsi:type='xsd:double'>517881.00</amount>
<description xsi:type='xsd:string'>Building D - Structural Package</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>517780.00</rate>
<amount xsi:type='xsd:double'>517780.00</amount>
<description xsi:type='xsd:string'>Podium - Structural Package</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>38815.00</rate>
<amount xsi:type='xsd:double'>38815.00</amount>
<description xsi:type='xsd:string'>Condovilla - Structural Package</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>4296.00</rate>
<amount xsi:type='xsd:double'>4296.00</amount>
<description xsi:type='xsd:string'>Aligns W. C.O. Summary</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>-159658.30</rate>
<amount xsi:type='xsd:double'>-159658.30</amount>
<description xsi:type='xsd:string'>RETAINAGE</description>
</soapenv:Body>
FAILED:`
unsafe:soapenv:Body
<tranId>PSI776141C</tranId>
<tranDate>2025-09-30T00:00:00</tranDate>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>284718.00</rate>
<amount xsi:type='xsd:double'>284718.00</amount>
<description xsi:type='xsd:string'>Masonry Reinforcements</description>
<quantity xsi:type='xsd:double'>1</quantity>
<rate xsi:type='xsd:double'>-28471.80</rate>
<amount xsi:type='xsd:double'>-28471.80</amount>
<description xsi:type='xsd:string'>RETAINAGE</description>
</soapenv:Body>
<add xsi:type='platformMsgs:AddRequest'><record xsi:type='tranPurch:VendorBill'><currency xsi:type='platformCore:RecordRef' internalId='1'/><customForm xsi:type='platformCore:RecordRef' internalId='50'/><entity xsi:type='platformCore:RecordRef' internalId='902'/><postingPeriod xsi:type='platformCore:RecordRef' internalId='22'/><subsidiary xsi:type='platformCore:RecordRef' internalId='3'/><itemList xsi:type='tranPurch:VendorBillItemList'><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='732'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='732'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='732'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='732'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='732'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='328'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item></itemList></record></add><add xsi:type='platformMsgs:AddRequest'><record xsi:type='tranPurch:VendorBill'><currency xsi:type='platformCore:RecordRef' internalId='1'/><customForm xsi:type='platformCore:RecordRef' internalId='50'/><entity xsi:type='platformCore:RecordRef' internalId='569'/><postingPeriod xsi:type='platformCore:RecordRef' internalId='22'/><subsidiary xsi:type='platformCore:RecordRef' internalId='3'/><itemList xsi:type='tranPurch:VendorBillItemList'><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='1131'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item><item xsi:type='tranPurch:VendorBillItem'><item xsi:type='platformCore:RecordRef' internalId='328'/><customer xsi:type='platformCore:RecordRef' internalId='1640'/></item></itemList></record></add>