Converting Master Records
Once you finish the GTM setup, the next activity is to update tax settings in the following master records:
|
• Suppliers
|
• Trailer codes
|
|
• Customers
|
• Service categories
|
|
• Product lines
|
• Service agreement terms
|
|
• Items
|
|
GTM has additional fields and may require new values for existing fields.
USA to GTM–Masters
To convert master records, run USA to GTM–Masters (2.13.22.6).
USA to GTM–Masters (2.13.22.6)
In addition to updating the tax settings in the master records, this program assigns tax zone codes to supplier, customer, and company address records. For verification of changes, the program generates an audit trail.
Important: Before you run USA to GTM–Masters, do the following:
• Run USA to GTM–Setup (2.13.22.5).
• To avoid record-contention conflicts with other users, shut down the database. Restart it with no other users on the system.
For each type of record, you can convert all records, a range of records, or individual records. This program converts records in the same order as the options on the screen. For separate audit trail reports, run the report separately for each type of record.
If you created a class file during the setup step, specify its name in the Class File field. Display Status, Output, and Batch ID are the same as in the setup program.
Master Conversion Audit Trail
The master conversion prints a report of changed records. The format varies depending on the records included in the conversion. For each group of converted records, the report shows the record number and name followed by the before and after tax information, such as country code, tax zone code, taxable status, whether tax is included in item amounts, and tax class.
Groups of converted records are printed in the same order as the screen selection criteria, and each group is separated by a page break. Warning and error messages identify potential conversion problems.
Customer Audit Trail
Countries for Addresses Audit Trail
Troubleshooting the Master Conversion
The error messages in the audit trail identify conditions you should analyze and address before you convert transactions.
Troubleshooting the Master Conversion lists some common problems along with explanations. Before you make corrections, restore the database from backup.
Warning Do not proceed to the transaction conversion until the master conversion audit trail is free of errors.
Troubleshooting the Master Conversion
Error | Explanation |
Tax class cannot be converted. | Class file does not contain a tax exemption that matches the one in the master record. |
Blank tax class not allowed. | Tax exemption is blank in the class file. |
Tax class cannot exceed 3 characters (xxx). | Tax exemption in the class file is longer than three characters. The message shows the first three characters. |
Tax class does not exist (x). | Tax exemption in the class file not in the US tax master. |
Tax class is not unique (x). | Tax exemption occurs in multiple places in the class file. |
Tax class does not exist (xxx). | GTM tax class in the class file does not exist in the GTM tax class master. |
x, and xxx are placeholders for the actual codes displayed in the error message. |
How the Conversion Changes Master Records
The following is provided to assist developers and others who require technical information on how the master conversion updates the database.
The menu-level program for USA to GTM–Masters, txusamst.p, sets the GTM tax values in the individual tables.
When setting the GTM tax class value, the programs can set the existing tax exemption code or retrieve an alternate from a class file.
Changes to Master Records lists the affected database tables and summarizes the changes.
Changes to Master Records
Tables | Summary of Changes |
ad_mstr | In supplier records, txusavd.p sets ad_taxable from vd_taxable. It also sets ad_taxc and ad_tax_usage to blank. In customer records, txusacm.p sets ad_taxable from cm_taxable and ad_tax_in from cm_tax_in. It also sets cm_taxc, ad_taxc, cm_taxc, and ad_tax_usage from cm_taxc or from the AR class file, if any. In all address records, txusact.p sets ad_ctry from ad_country and visa versa. txusazn.p calls txtxzget.p to set ad_tax_zone. |
fsc_mstr | txusafsc.p sets fsc_taxc from fsc_taxc or from the AR class file if any. |
pl_mstr | txusapl.p sets pl_taxc from pl_taxc or from the class file, if any. |
pt_mstr | txusapt.p sets pt_taxc from pt_taxc or from the class file, if any. |
sv_mstr | txusasv.p sets sv_taxc and sv_tax_usage from sv_taxc or from the AR class file, if any. |
trl_mstr | txusatrl.p sets trl_taxc from trl_taxc or from the class file, if any. |
