https://netsuiteprofessionals.com logo
Join SlackCommunities
Powered by
Hi, we have an external application that will crea...
# general
j
Hi, we have an external application that will create Netsuite Sale Order. I don't know if anyone could help me with this. So basically when create the Sale Order, sometime we have a case where the Line Item has 1 yen extra. From the Screenshot on the left here is the payload that our App sent which is "tax1Amt":"1045.0", "grossAmt":"11500.0" => on the right is the Sale Order where the Line Item somehow got 1 yen extra. We pretty confident that we sent the correct payload from our app. So my question is if anyone has faced this issue, if not, what steps would we recommend to debug this kind if issue??? Thank you!!!
n
I am facing same issue but in AU order 😕
j
Almost certainly Netsuite is calculating the tax amount itself, using a 10% rate, and it is rounding up (because 1045.5 rounded to 0 decimal places is 1046, usually)
You might find it works if you swap around the tax1amt and rate fields (it could be that entering the rate is triggering a tax recalc, but not sure how Netsuite handles payloads like this)
j
ah, thanks Jon => will try this
b
the gross amount you are sending is higher priority than the amount and the tax amount
since you didnt specify the tax rate, its using the default tax rate in combination with the gross amount to calculate the amount
n
its because these values are already calculated and sent right the way they are, but NS is calculating again. Is there any option to disable this recalc someway somehow?
b
you can force it to be correct by not setting the gross amount
n
hmmm
b
although any solution that ignores how netsuite handles rates tends to fail for other related transactions down the line
or honestly any edit
n
yeap
j
weird tho, we do provide the default taxCode -> does this mean the grossAmt will refer to the tax rate in taxCode or this taxCode is not related?
b
your request is providing redundant information
if you had mismatching information, for example if the amount was 1, tax amount 2 and gross amount 4, then there would be a mismatch since 1 + 2 != 4
netsuite makes a choice about which numbers to use
in this case, it acts like if you had only set the gross amount
which means it uses the tax rate on the line to calculate the amount
you didnt set any, so it will use the tax rate from the tax code
you can override that behavior by setting taxRate1, but it tends to be a flawed approach
netsuite will still try to calculate the correct amount on transactions related to the sales order, like a cash sale or invoice
j
got it. thank you!!!
hi @battk one thing I cannot wrap my head around is the increased 1 yen. so the above screenshot is using 10% consumption tax -> if we do provide grossAmt and netsuite will do the tax itself our setting for tax in the screenshot below Our Application we send GrossAMT 11500 -> if we do that math: 11500/1.1 = 10454.5455 (rounded to 10455) so the tax amount calc by netsuite will be 11500 - 10455 = 1045 so the expecteded outcome should be tax: 1045 and gross amt: 11500 => so why there is a 1 yen extra in here??? does when doing 
11500/1.1 = 10454.5455)
it rounded to 10454 somehow??
b
an amount of 10455 has 1046 tax (1045.5 rounded up) for a gross amount of 11501
m
You can change the tax rounding method under "Set Up Taxes" page
b
you can probably do the same exercise in the ui
set the rate (or amount) for one line, and for the other set the gross amount instead
j
noice -> thank you so much with this info -> we understand much more about Netsuite doing tax now @battk!!!!! 👍
4 Views
Open in Slack
PreviousNext
Powered by