Converting Master Records

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.

For each type of record, you can convert all records, a range of records, or individual records. The program converts records in the same order as the options on the screen. For separate audit trails, run the report separately for each type of record.

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 and the before and after tax information. This tax information includes country code, tax zone code, taxable status, whether tax is included in item amounts, tax class, and tax usage.

The error messages in the audit trail identify conditions to analyze and address before you convert transactions. Troubleshooting the Master Conversion lists some common errors along with explanations. Restore the database from backup before making corrections.


Error	Explanation
Tax class cannot be converted.	Class file does not contain a VAT class that matches the one in the master record.
Blank tax class not allowed.	VAT class is blank in the class file.
Tax class cannot exceed 3 characters (xxx).	VAT class in the class file is longer than three characters. Message shows the first three characters.
Tax class does not exist (x).	VAT class in the class file is not in the VAT master.
Tax class is not unique (x).	VAT class 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.
Tax usage cannot exceed 8 characters (xxxxxxxx).	GTM tax usage in the class file is longer than eight characters. Message shows the first eight characters.
Tax usage does not exist (xxxxxxxx).	GTM tax usage in the class file does not exist in the GTM tax usage master.
Tax class/tax usage combination is not unique (xxx xxxxxxxx).	GTM tax class and tax usage combination occurs in multiple places in the class file.

The menu-level program for VAT to GTM–Masters is txvatmst.p. This program calls subprograms that set the GTM tax values in the individual database tables. These programs can set the existing VAT class value or retrieve an alternate value from a class file.


Table	Summary of Changes
Address Master (ad_mstr)	In supplier records, txvatvd.p sets ad_taxable from vd_taxable. It also sets ad_taxc and ad_tax_usage from ad_taxc or from the class file with AP usage, if any. In customer records, txvatcm.p sets ad_taxable from cm_taxable and ad_tax_in from cm_tax_in. It also sets cm_taxc, ad_taxc, and ad_tax_usage from cm_taxc and from the class file with AR tax usage, if any. In all address records, txvatct.p sets ad_ctry from ad_country and the other way around. txvatzn.p calls txtxzget.p to set ad_tax_zone.
Service Category Master (fsc_mstr)	txvatfsc.p sets fsc_taxc from fsc_taxc or from the AR tax usage, if any.
Product Line Master (pl_mstr)	txvatpl.p sets pl_taxc from pl_taxc or from the class file if any.
Item Master (pt_mstr)	txvatpt.p sets pt_taxc from pt_taxc or from the class file if any.
Service Agreement Terms and Conditions Master (sv_mstr)	txvatsv.p sets sv_taxc from sv_taxc or from the class file with AR tax usage, if any.
Trailer Master (trl_mstr)	txvattrl.p sets trl_taxc from trl_taxc or from the class file, if any.