I am attempting to create an invoice via a restlet...
# suitescript
t
I am attempting to create an invoice via a restlet and getting that the transaciton is unbalanced and the unbalanced amount matches to the total tax charged. Does anyone have any ideas if there are settings I have missed in NetSuite to get this working?
Copy code
{
  "item": [
    {
      "quantity": 1,
      "rate": 6.99,
      "amount": 6.99,
      "item": "367",
      "istaxable": true,
      "taxrate1": 8.25
    },
    {
      "quantity": 1,
      "rate": 0,
      "amount": 0,
      "item": "267",
      "istaxable": false,
      "taxrate1": null
    },
    {
      "quantity": 1,
      "rate": 0,
      "amount": 0,
      "item": "300",
      "istaxable": false,
      "taxrate1": null
    },
    {
      "quantity": 1,
      "rate": 0,
      "amount": 0,
      "item": "292",
      "istaxable": false,
      "taxrate1": null
    },
    {
      "quantity": 1,
      "rate": 4.59,
      "amount": 4.59,
      "item": "448",
      "istaxable": true,
      "taxrate1": 8.25
    },
    {
      "quantity": 1,
      "rate": 5.29,
      "amount": 5.29,
      "item": "788",
      "istaxable": true,
      "taxrate1": 8.25
    },
    {
      "quantity": 1,
      "rate": 0,
      "amount": 0,
      "item": "1059",
      "istaxable": false,
      "taxrate1": null
    },
    {
      "quantity": 1,
      "rate": 0,
      "amount": 0,
      "item": "1067",
      "istaxable": false,
      "taxrate1": null
    }
  ],
  "trandate": "2020-12-11",
  "location": "204",
  "subsidiary": "5",
  "entity": "2845"
}
b
no good comes from messing with tax rates
t
I am pushing data from the POS system which is in control of tax collection, payments and a few other things, we need to send by item for inventory control and GL tracking 😞
I think I have found it now tho. The customer hasn't setup all of their tax tables properly yet