QAD 2017 Enterprise Edition > Installation-Conversion > Conversion Guide > GTM Conversions > Converting US Taxes to GTM > Converting Transaction Records
  
Converting Transaction Records
Once you finish converting master records, you can convert the following transaction records:
• Purchase orders and receipts
• Accounts payable vouchers and payments
• Service contracts, calls, and return material authorizations
• Sales quotes and orders
• Accounts receivable memos, invoices, and payments
In GTM, every transaction subject to tax has a transaction tax detail record. This record stores the information used to calculate tax.
Note: If you already have GTM transaction records in the database when you perform transaction conversion, the conversion process updates them using the current default tax values. Values replaced in these records include tax environment, class, usage, and so on.
USA to GTM–Transactions
To convert existing transaction records, run USA to GTM–Transactions (2.13.22.7).

USA to GTM–Transactions (2.13.22.7)
In addition to updating transactions, this program generates an audit trail for verification of changes.
Important: Before you run USA to GTM–Transactions, do the following:
• Run USA to GTM–Setup (2.13.22.5) and USA to GTM–Masters (2.13.22.6).
• Avoid record-contention conflicts with other users. Shut down the database and restart it when no other users are on the system.
You can convert all records, a range of records, or individual records. The program converts records in the same order they display on the screen. For separate audit trail reports, run the report separately for each type of record.
Note: In some cases, the record sequence is important. Purchasing transactions are converted before accounts payable vouchers and vouchers before payments. Accounts receivable memos and invoices are converted before payments.
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.
See Defining Custom Tax Exemption Codes.
Transaction Audit Trail
The transaction 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 transaction number and name and the before and after tax information for each line item. The tax information includes taxable status, tax environment, and tax class. Groups of converted records print in the same order as the screen selection criteria with a page break separating each group.
Warning and error messages identify potential conversion issues. Messages that appear at the end of a transaction apply to the entire transaction; messages that appear between the Before and After line apply only to that line.
Purchasing Audit Trail and Service Calls Audit Trail show representative audit trail formats.

Purchasing Audit Trail

Service Calls Audit Trail
Troubleshooting Transaction Conversion
The error messages in the audit trail identify conditions to analyze and address before resuming live GTM processing. Troubleshooting the Transaction Conversion lists a common error along with an explanation. Before you make corrections, restore the database from backup.

Troubleshooting the Transaction Conversion
 
Error
Explanation
Detail tax environment must match header.
In accounts payable vouchers and accounts receivable debit/credit memos, the tax environment are the same in the header and detail lines.
Warning Do not resume live processing until the transaction conversion audit trail is free of errors. Do not correct transaction records programmatically. This approach often causes additional problems.
In addition to examining the audit trail, review the Tax Detail by Transaction Report (2.13.15.3). This report shows the tax environments, tax types, and tax amounts for the converted records. Verify that the tax calculations are as expected.
Converted transactions can have minor differences in before/after tax amounts. The differences occur because GTM uses a different calculation algorithm or rounding method than your source version. To synchronize the general ledger with converted transactions, record adjusting entries.
To eliminate ambiguity, the audit trail shows before and after values for purchasing, accounts payable, and accounts receivable records by their Progress database field name, not their screen label. For example, the audit trail displays voucher line types in the vod_type column.
As you interpret the audit trail for the transaction conversion, it can be helpful to reference USA to GTM, Purchasing Transactions through USA to GTM, AR DR/CR Memos. These tables summarize the nature of before/after tax values.
Note: In these tables, quotation marks indicate a value that cannot be translated.

USA to GTM, Purchasing Transactions
 
Status
Tax System
pod_taxable
prh_tax_at
Taxable
USA
Yes
“y”
 
GTM
Yes
“Yes”
Non-taxable
USA
No
“n” or blank1
 
GTM
No
Blank
1 An item is non-taxable if pod_taxable is n (No). If the transaction is non-taxable, the tax exemption code is optional.


USA to GTM, AP Voucher Receiver Lines
 
Status
Amt
Tax System
Tax
TxC
vod_type
vod_tax
vod_tax_at
Taxable
Item
USA
No
Blank
“R”
Blank
“y”
 
 
GTM
Yes
Tax class
“R”
Blank
“Yes”
 
Tax
USA
No
Blank
Blank
“y”
Blank
 
 
GTM
No
Blank
“T”
“t”
“No”
Non-taxable
Item
USA
No
Exemption code or blank1
“R”
Blank
Blank
 
 
GTM
No
Tax class
“R”
Blank
Blank
 
Tax2
USA
No
Blank
Blank
“y”
Blank
 
 
GTM
–
–
–
–
–
1 An item is non-taxable if its taxable status is No. If the transaction is non-taxable, the tax exemption code is optional.

2 The conversion deletes US tax lines resulting from non-taxable amounts.


USA to GTM, AP Voucher Memo Lines
 
Status
Amt
Tax System
Tax
TxC
vod_type
vod_tax
vod_tax_at
Taxable
Item
USA
No
Blank
Blank
Blank
Y
 
 
GTM
Yes
Tax class
Blank
Blank
“Yes”
 
Tax
USA
No
Blank
Blank
y
Blank
 
 
GTM
No
Blank
“T”
“t”
“No”
Non-taxable
Item
USA
No
Blank
Blank
Blank
n or blank1
 
 
GTM
No
Tax class
Blank
Blank
“No”
 
Tax2
USA
No
Blank
Blank
y
Blank
 
 
GTM
–
–
–
–
–
1 An item is non-taxable if its taxable status is n (No). If the transaction is non-taxable, the tax exemption code is optional.

2 The conversion deletes USA tax lines resulting from non-taxable amounts.


USA to GTM, AR Invoices
 
Status
Amt
Tax System
ard_tax
ard_tax_at
ard_taxc
Taxable
Item
USA
Blank
Blank
Blank
 
 
GTM
Blank
Tax class
Tax class
 
Tax
USA
Blank
Blank
Blank
 
 
GTM
“t”
“No”
Blank
Non-taxable
Item
USA
Blank
Blank
Blank
 
 
GTM
Blank
Tax class
Tax class
 
Tax1
USA
–
–
–
 
 
GTM
–
–
–
1 In the US tax system, no tax records are created for non-taxable amounts, so the conversion creates no records for GTM.


USA to GTM, AR DR/CR Memos
 
Status
Amt
Tax System
ard_tax
ard_tax_at
ard_taxc
Taxable
Item
USA
Blank
“y”
Blank
 
 
GTM
Blank
“Yes”
Tax class
 
Tax
USA
“y”
Blank
Blank
 
 
GTM
“t”
“No”
Blank
Non-taxable
Item
USA
Blank
“n”
Blank
 
 
GTM
Blank
“No”
Tax class
 
Tax1
USA
–
–
–
 
 
GTM
–
–
–
1 In the US tax system, no tax records are created for non-taxable amounts, so the conversion creates no records for GTM.

How the Conversion Changes Transaction Records
The following is a detailed description of how the transaction conversion updates the database.
The menu-level program for USA to GTM–Transactions is txusatrn.p. This program calls subprograms that set the GTM tax values in the individual database records. For all transactions, the conversion also generates corresponding tax detail records in the Tax Detail (tx2d_det) table.
When setting the GTM tax class value, these programs can set the existing tax exemption code value or retrieve an alternate value from a class file.
See Defining Custom Tax Exemption Codes.
Changes to Transaction Records lists the affected database tables and summarizes the changes.

Changes to Transaction Records
 
Tables
Summary of Changes
Accounts Receivable Detail (ard_det)
For debit/credit memos, txusaarm.p sets ard_tax and ard_tax_at.
Accounts Receivable Master (ar_mstr)
For debit/credit memos, txusaarm.p sets ar_tax_env using txtxeget.p.
Service/Support Call Master (ca_mstr)
txusaca.p sets ca_taxc and ca_tax_usage from ca_taxc or from the class file, if any. It also sets ca_tax_env using txtxeget.p.
Invoice History Detail (idh_hist)
txusaari.p sets idh_taxc and idh_tax_usage from idh_taxc or from the class file, if any. It also sets idh_tax_env using txtxeget.p.
Invoice History Master (ih_hist)
txusaari.p sets ih_taxc and ih_tax_usage from ih_taxc or from the class file, if any. It also sets ih_tax_env using txtxeget.p.
Service/Support Call Item Detail (itm_det)
If itm_prefix is CA and itm_type is any value except INV, txusaca.p sets itm_taxc and itm_tax_usage from itm_taxc or from the class file, if any. It also sets itm_tax_env using txtxeget.p.
Purchase Order Detail (pod_det)
If pod_taxable is Yes, txusapo.p sets pod_taxc to blank and sets pod_tax_env using txtxeget.p. If pod_taxable is No, txusapo.p sets pod_tax_env from po_tax_env.
Purchase Order Master (po_mstr)
txusapo.p sets po_tax_pct[1], po_tax_pct[2], and po_tax_pct[3] to 0. It sets po_tax_usage from ad_tax_usage and po_taxc from ad_taxc. It also sets po_tax_env using txtxeget.p.
Purchase Order Receipt History (prh_hist)
txusapo.p sets prh_taxc to blank when prh_tax_at is “y.” It also sets prh_tax_env from pod_tax_env. If pod_taxable is Yes, txusapo.p sets prh_tax_at to “Yes”; otherwise, it is set to blank.
Sales Quotation Detail (qod_det)
txusaqo.p sets qod_taxc and qod_tax_usage from qod_taxc or from the class file, if any. It also sets qod_tax_env using txtxeget.p.
Sales Quotation Master (qo_mstr)
txusaqo.p sets qo_tax_pct[1], qo_tax_pct[2], and qo_tax_pct[3] to 0. txusaqo.p also sets qo_taxc and qo_tax_usage from qo_taxc or from the class file, if any. It also sets qo_tax_env using txtxeget.p.
Return Material Authorization Master (rma_mstr)
txusarma.p sets rma_taxc from rma_taxc or from the class file, if any.
Service Contract Detail (sad_det)
txusasc.p sets sad_taxc and sad_tax_usage from sad_taxc or from the class file, if any. txusasc.p sets sad_tax_env from sa_site and sa_taxc using txtxeget.p.
Service Contract Master (sa_mstr)
txusasc.p sets sa_tax_pct[1], sa_tax_pct[2], and sa_tax_pct[3] to 0. It sets sa_taxc and sa_tax_usage from sa_taxc or from the class file, if any. It also sets sa_tax_env using txtxeget.p.
Service/Support Billing Detail (sfb_det)
txusaca.p sets sfb_taxc and sfb_tax_usage from sfb_taxc or from the class file, if any. txusaca.p sets sfb_tax_env using txtxeget.p.
Sales Order Detail (sod_det)
txusaso.p sets sod_taxc and sod_tax_usage from sod_taxc or from the class file if any. txusaso.p sets sod_tax_env using txtxeget.p.
Sales Order Master (so_mstr)
txusaso.p sets so_tax_pct[1], so_tax_pct[2], and so_tax_pct[3] to 0. txusaso.p sets so_taxc and so_tax_usage from so_taxc or from the class file, if any. txusaso.p sets so_tax_env using txtxeget.p.
Tax Detail (tx2d_det)
txusapo.p creates tax details for purchase orders (GTM transaction type 20), receivers (21), reconciliations (23), and returns (25).
txusaapv.p creates tax details for vouchers (22) and recurring vouchers (32).
txusaapp.p creates tax details for accounts payable tax on discount at payment (29).
txusaqo.p creates tax details for sales quotes (10).
txusaso.p creates tax details for invoiced service calls (38), return material authorizations (36), sales orders (11), and pending invoices (13).
txusaarm.p creates tax details for debit/credit memos (18).
txusaari.p creates tax details for invoices (16).
txusaarp.p creates tax details for accounts receivable tax on discount at payment (19).
txusasc.p creates tax details for service quotes (33) and service contracts (34).
Voucher Detail (vod_det)
txusaapv.p sets vod_taxable, vod_taxc, vod_tax_usage, vod_tax, vod_tax_at, vod_type, and vod_tax_env. If vod_type is “r” and vod_tax_at is “Y”, vod_taxc is set to blank.
Voucher Master (vo_mstr)
For vouchers, txusaapv.p sets vo_tax_pct[1], vo_tax_pct[2], and vo_tax_pct[3] to 0. It also sets vo_taxable, vo_taxc, vo_tax_usage, and vo_tax_env.