T-10012: Sales Tax Amount Difference

jversusj

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

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

jversusj

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

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

jversusj

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!