7 Self-Assessed Tax Code Substitution

In order to support self-assessed Reverse Charge VAT or Acquisition VAT taxes may need to pass different tax codes than the standard tax code associated with an item in a tax region as part of the IMCS to Financials AP integration.   To facilitate this requirement, a new feature has been added. An Invoice Matching table (IM_SELF_ASSESS_TAX_CODE_XREF) holds a cross reference of tax data to be used in this process. This data is populated by the retailer as part of the implementation through scripts developed by the retailer. The table holds several values including:

• The Invoice Matching Transaction Code (allowable values are: TAXACO and TAXACQ, TAXRVC, TAXRVO)

• The Standard Tax Code for an item in a tax region

• The Substitute Tax Code to be used instead of the Standard Tax Code (must be a valid tax code in Merchandising)

• An Effective date for the record

When data is populated in this table and Invoice Matching posts an invoice that needs to have either of the self-assessed types of taxes (Acquisition VAT or Reverse Charge VAT), the Invoice Matching posting process will determine whether the table has a record set up for the Invoice Matching Tax Transaction Code and Standard Tax Code that Invoice Matching would normally populate. If the process finds a matching record, it will substitute the Substitute Tax Code in the posting line in place of the Standard Tax Code. If the process does not find a matching record in the table based on the Invoice Matching Tax Transaction Code and Standard Tax Code, then the posting process will use the Standard Tax code in the posting line.

Steps to Enable

In order to populate this table you need to develop a script to populate this table. In pre-production environments, you can run the script using APEX Data Viewer. For production, please submit the script via an SR to have it run in your production environment.