https://netsuiteprofessionals.com logo
Join Slack
Powered by
Tax tables in NS have lots of values and the tax r...
# suitescript
c
Tax tables in NS have lots of values and the tax rate can be different depending on the customer so looking up the tax value appears to be hard, that may be way it was done this way in the first place.
b
id imagine the best answer is to properly setup taxes so that the taxcode is sourced properly
c
I've got a functional consultant telling me it's not possible as the tax rate is different depending on several variables
and I would have to write all the logic myself which is just further hardcoding legislation into the script.
b
the code you shares looks like an attempt to hardcode the tax rate to 10%
c
Yes thats correct
b
it is very easy to do that with netsuite
its also very wrong
c
Which is standard GST
I would have thought I could just search for the ST GST rate and that would return 10% or something?
b
you should be able to setup your nexus to hardcode whichever tax code you want
id say is wrong, but its not hard to hardcode a script to set the taxcode to a default value
as long as you dont setup netsuite to default a different tax code
c
What are you saying is wrong? The hardcode nexus solution or the value in the script?
Clearly whatever the answer is, I don't want 1*1 in the script
Maybe this is why people use avalara
b
which you have sounds extra wrong
less wrong but still wrong is just hardcoding the taxcode in script
you can do the same thing by setting up taxes to always choose the same tax code
thats potentially wrong depending on the country
c
I dont' see how this can be done 'properly'.
custom field : 'price incl GST' on the item record fixes this I guess.
b
so far, your question sounds like 
how do i hardcode a taxcode
c
@battk that's the only option I'm being given by the functional consultants
I want to pull the value from NS but I'm being told it's too complicated and maybe no possible.
I don't understand tax configuration in NS enough to argue so it's difficult to claim something is wrong if I get a ton of jargon thrown back at me which I can't answer to
b
Australia Tax Topics is a small topic
its honestly harder to set it up to charge different tax codes since by default the tax setup for Australia will use the 10% TS-AU tax for everything
c
The issue is, we're putting the base price into the SO but that's going in as a GROSS amount; it needs GST adding
unless it's an international purchase then it needs to show as GST free but the base price still needs GST adding to it as the item is priced the same for domestic and international customers.
So the price of the item is the same for domestic and international orders, domestic orders will have to give the 10% to the tax man though so it can be shown on an invoice, the foreign customers would not want to see GST on the invoice.
b
you enter in a base price for an item
and then you have a different price level for your foreign customers
c
That would avoid having to work out the grossamt
I'll pitch that idea.
Shot down - all sales are in AUD so can't set foreign currency price
b
price level is unrelated to currency
c
big long response on why that is too much overhead
mostly around customers having multiple price levels
b
will double the amount of price levels
maintenance will remain about the same if you keep the markup constant
c
Pffft
probs just quit and go back to SAP
Sounds horrendous from the explanation I'm getting on this end
I feel like they should pay someone specifically for this issue so I'm dropping it.
b
the problem with multiplying price is that it is very easy to get updates wrong
3 Views
Open in Slack
PreviousNext
Powered by