Skip to Content
0
Former Member
Jun 03, 2010 at 03:08 PM

Sales Tax Calc (Line Item level calc versus header level calc)

264 Views

Hello,

My company utilizes vertex to calculate sales and use tax in our sales orders that are created via resource related billing (DP96).

We store tax code O1 using condition type UTXJ for each SD Contract.

Condition types XR1 thru XR6 receive the sales tax calculations/amounts from vertex for EACH line in the billing request.

See below example of calculated tax amount per line item

Line1 of Bilreq: NetVal 2.25 X tax rate for XR1 .05 = sales tax of 0.11 (rounded up to 2 decimal places)

Line2 of Bilreq: NetVal 2.25 X tax rate for XR1 .05 = sales tax of 0.11 (rounded up to 2 decimal places)

Totals 4.50 0.22

When our invoice(billing document) is sent to our customer which shows just totals our customer sees:

Net Amout: 4.50

tax rate .05

Sales Tax Amt: 0.22

When our customer multiplies 4.50 by .05 they come up to 0.23

So they are questioning why the calculation is incorrect and they want it to match to the penny.

Anyone have any suggestions to solve this problem.

Any help is greatly appreciated.

Thanks,

Ermanno Incollingo