Setting up the Master Data Tables

Several information and parameters must be maintained in Tax Engine before each BOD can be created. If there are information or parameters that are missing or with inconsistent format, a rejection can occur during program checks between SOR and Tax Engine.

For example, in the AddressBOD, the fields Country, State, and City must be completed first in the Tax Engine Master Data sessions. The AddressBOD is used in these BODs:

  • LocationDepartmentBOD

  • LocationWarehouseBOD

  • SupplierPartyMasterBOD

  • CustomerPartyMasterBOD

  • ShipFromPartyMasterBOD

  • ShipToPartyMasterBOD

  • BillFromPartyMasterBOD

  • BillToPartyMasterBOD

Database restriction will occur if the content of the BOD does not match with the database definitions or when the data is not found on reference table. In this example, the relevant addresses for your Business Partners will not be generated if data is not found or is inconsistent on reference table for Addresses.

Also, in the Master Data General Parameters session, the Identification Codes for your Addresses, Warehouse, Department, Business Partner, and Item must be defined.

Fields that are mandatory for each type of BODs used in the Tax Engine are listed below.

CurrencyExchangeRateMasterBOD:

  • Currency

  • Currency Base

  • Effective Date

  • Exchange Rate Type

ItemMasterBOD

  • Unit

  • Item Group

  • Item Type

  • Identification Code in the Master Data General Parameters, if applicable.

Master Data Tables are grouped into three categories:

  • Logistic Tables

  • Financial Tables

  • Fiscal Tables

When the Tax Engine receives data, such as the Item Data and Business Partners Data, from the SOR, this data is written as Identification Codes and a new internal code is created in the Tax Engine. The series prefix and code length of the Tax Engine’s internal codes can be defined through Master Data General Parameters.

You must design a coding system first before you create records and enter codes. When a coding system is in use, it is difficult to change the coding system later. You can define ID series and length for this data:

  • Warehouses

  • Departments

  • Addresses

  • Business Partners

  • Items

Depending on how you want to manage your data, you may also use your ERP's identification codes as the internal codes to be used in the Tax Engine.

You may also define suffixes for the following Master Data to effectively manage your data:

  • Supplier Party

  • Customer Party

  • ShipFrom Party

  • ShipTo Party

  • BillFrom Party

  • BillTo Party

The internal codes are used inside the Tax Engine, while the identification codes are used in the return BOD XML. Changing the master data in the Tax Engine does not cause a BOD to be published.