Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OE tax error

Status
Not open for further replies.

xeaon

Programmer
Aug 19, 2003
10
CA
I'm developping and order input form with the xapi...

Everithing seems to be alright except for execution time
but for now my concern is on the tax calculation...

I have some miscalculation with the xapi, so i try to created a order with accpac directly just to be sure the probleme is in my code...

but the fact is that when i create an OrderEntry with accpac the seconds item(parts) detail have a wrong basetaxe for the second taxe (tvq)(quebec canada, using tps and tvq taxe)

** the right way to calculate this

10$ * 0.07 = 0.7 (tps)
0.7+10 = 10.7
10.7 * 0.075 = 0.8025 (tvq)
10.7+0.8025 = 11.50
total : 11.50
tx total : 1.5025



*** IN ACCPAC
taxebase1 (tps) 10$ good
taxeamount1 0.70$ good
taxebase2 (tvq) 21.30$ bad (should be (10.70$))
taxeamount2 1.60$ bad




Ive done this 10 times and with different customer using the same tax class...

if i post the OrderEntry then ship all and print the invoice.. still the wrong tax amount.....

I'm preaty sure the customer and taxe class are ok because i double check them with a ACCPAC consultant...
And the first item(parts) have the right amount of taxe...

That is realy strange....
and if the accpac OE don't work properly i cannot validate myself on my xapi code...

if someone have an idea...

thanks in advance

my ACCPAC consultant would probably support me on this, but i seek the solution for myself too

 
I found the solution,

In Common service -> tax Service --> Tax Group

Choose the tax group...
Set the Tax Calculation method to 'Calculatetax by detail'
instead of by summary...

for thoose who might have the same problem...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top