T-10012: Sales Tax Amount Difference

jversusj · 2008-11-20

We had a rare INCONSISTENT issue and we were able to resolve it by correcting a half-cent tax amount. Posting the invoice created a record in table 10012 Sales Tax Amount Difference.

I cannot find much info about this table. Nothing in the Online Help (F1) of NAV and no threads here. Does any follow-up work have to be done to the record inserted into this table? Is it ill-advised to delete the lone record in the table? We had to grant users permissions to read this table only after inserting this 1 record, causing ourselves a bit of an unexpected headache.

Alex_Chow · 2008-11-20

It's used for sales tax calculation in the US localization.

jversusj · 2008-11-20

Thank you very much.

if it is involved in calculation, should records stay in there forever? should they be auto-purged like they are in the Sales Tax Amount Line table? Should the accounting department report against what is in this table?

i had to increase a Tax Amount by 0.005 to get around a CONSISTENT error. The invoice posted along with all correct Value Entries, CLE, G/L entries, and i cannot find any use for the record entered into this table. How are other end Users processing the data sitting in this table?

Alex_Chow · 2008-11-20

No, this table is a temporary table. It will never have records in there. It's used for calculation purpose.

jversusj · 2008-11-21

well.... um, it is not temporary for us. There is a record sitting in there after the posting of the invoice.

are you sure you are thinking about Sales Tax Amount Difference and not Sales Tax Amount Line - which does appear to be temporary?

in any case, it seems like this record probably isn't important and accounting does not have to do anything with it. thanks!

T-10012: Sales Tax Amount Difference

Answers

Categories