Where VAT and taxes are stored after R42565

[panobois]

Hi,

After running R42565, I want to run some customs UBE to give me for each client the Gross Amount per invoice made by R42565. This must include the invoice that are not yet updated (not yet processed by R42800).
It seems logical that the R42800 have not to re-calculate the taxes because it can be some time elapsed between R42565 and R42800 and the parameters of the system can change between those two moments (in our case, it can be 15 days). So that's why I think that R42800 must take the taxes amounts from one table to put them in the F03Bxx and F0911 tables. But from where it takes thoses amounts of taxes ?

Any idea ?

Thanks!

Currently B7332 SP17.1 on NT4/SP6a and SQL7/SP3, and soon on ERP 8.0

 

[andyklee]

Taxes are not stored in the F0018 until after the Sales Update process runs.
While tax rates can change between the invoice date and the sales update
date, there are effective dates on tax areas, so the same result should
occur. I believe the order date is the date used to calculate taxes.

There is another way to do taxes, using Advanced Pricing. If you choose to
go that route, the taxes are in the Price History file immediately upon
entry of the order. Most companies that sell bulk product use Advanced
Pricing for taxes as the tax system doesn't handle per unit taxes. However
there are some issues to do with calculating the terms discount net of
taxes, that are not handled particularly well by the software if you are
using Advanced Pricing for taxes.

Andy Klee
www.JDETips.com