Nav 3.7 Sales Tax

gra8ful10

Hi All. It appears that the Max Amount/Qty in the Tax Detail table applies to the entire Invoice Amount. I need it to be based on each individual item amounts.

Example:

Tax Detail:
Tax Below Maximum = 1.00
Max Amount/Qty = 8000.00
Tax Above Maximum = 0.00

Sales Lines:
Item 1 Amount = $7999.00
Item 2 Amount = $100.00

Navision does not tax this invoice since the total amount is over $8000. I need it to tax since neither item is over $8000.

Has anyone ever done this before or have any suggestions?

Thanks in advance!!!

ara3n

So you are saying that If you purchase the same Item of qty 1000 but you put it on 2 lines instead of one you don't want to calculate tax on it?
but if you put it on one line you do want to calculate tax on?

gra8ful10

I still want to calc the sales tax, but I wanted calculated on a per item or per line basis instead of on a per invoice basis.

NC has a sales tax that is calculated on a per item basis up to $8,000.

What is happening now is if I order 2 items at $7,000 = $14,000. Navision only taxes $8,000. Where is should tax the entire $14,000.

Thanks,

Alex_Chow

You need to setup a different Tax Group Code for the items that are taxed differently.

After you setup the different Tax Group Code, you'll need to make the changes accordingly on the Tax Details.

ara3n

I just tested it in 4.0 SP2. Create the same item on 2 lines with same tax group. and Navision calculated it on both lines. You might want to look at that.

[Edit]. It still calculates tax on 8000 and not 1400. So you need two tax group codes. Or make a modification to automatically create the additional tax group codes.

Lizard is dead right.

Alex_Chow

ara3n wrote:

Lizard is dead right.