tax error - audit data - table ETXDCJ with wrong data

[Former Member]

Hi,

I am working on audit_data file that external tax system receives from SAP. table entries in 'ETXDCJ' are fed to audit_data file which are wrong. Please let me know how this table gets the entries. Any transaction or steps that I need to know to replicate the issue. We have this wrong tax data issue only for certain sales document type not for all. Please let me know.

Thanking you

Ram.

[Former Member]

External tax calculation is a setting that you have to enable in configuration. Every document has a tax procedure and pricing procedure assigned to it. So when you create a sales order, based on these two your prices and taxes are calculated. I am not how it works, but I think the external tax calculating software will calculate and send tax documents back to SAP. These are the ones that get stored in the table ETXDCJ,ETXDCH and ETXDCI. This update function module seems to be inserting it EXTERNAL_TAX_DOC_INSERT_DB.

What is it that you are calling error? Are calculations wrong, or is it something else? Are you sure it is document type not cutomer or state that is influencing this? Look in config for the external tax calculation under 'Financial Accoutning Global Settings' as follows:

Implementation Guide for R/3 Customizing (IMG)
-->Financial Accounting
   -->Financial Accounting Global Settings
      -->Tax on Sales/Purchases
         -->External Tax Calculation

I am wondering if your issue is with the tax jurisdictions and your condition table entries. If you are sure that it is always with a particular document type, compare the document type settings with another one that is working.

If this helps, please don't forget to reward.

Srinivas

[Former Member]

Srinivas..Thank you for the help, let me go through your comments.

Regards

Ram.

[Former Member]

Srinivas...You are right, ppl here recently made changes to tax/pricing procedures for doc type in question and I am still going through these changes to figure out something.

Tax data is showing up incorrectly in audit_file as follows:

Audit File|General Ledger|Audit File if Correct

State Tax 256.26 -256.26 256.26

County Tax 580.26 -149.21 149.21

City Tax 165.79 -165.79 165.79

Regards

Ram.

[Former Member]

Looks like your county tax is the one that has changed.

Check the config here

Implementation Guide for R/3 Customizing (IMG)
-->Sales and Distribution
   -->Basic Functions
      -->Taxes
         -->Define Tax Determination Rules
         -->Define Tax Relevancy Of Master Records

In there, check if UTX1 and UTX2 are added or changed. Also check if new counties are added. Check if the delivering plant has a new county code.

It is combination of any of these that could affect the taxes. But looking at the data you gave, you may be able to narrow it down to county tax. Also, check if there are any user exits used while calculating taxes. In US, you will be using TAXWARE or VERTEX for external tax calculations(at least these are supported by SAP). Check if their jurisdictions and SAP jurisdiction codes are out of sync.

Hope this helps. Please don't forget to reward and close when resolved.

Srinivas

[Former Member]

Srinivas..SAP side / SD documents are showing taxes (conditions) correctly, only audit file is getting wrong data, as you mentioned table 'etxdcj' is getting wrong entries from external tax calc system. Does external tax system has its own logic to calculate taxes?.

Regards

Ram.