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.
Note: 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 must be converted before accounts payable vouchers and vouchers before payments. Accounts receivable memos and invoices must be 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 followed by the before and after tax information for each line item, such as taxable status, tax environment, 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. Messages that appear at the end of a transaction apply to the entire transaction; those 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 you should analyze and address before you resume live GTM processing. Troubleshooting the Transaction Conversion lists some common problems along with explanations. 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 must be the same in both 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, it is advisable to 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 tax calculations are what you expect.
Converted transactions may have minor differences in before/after tax amounts. These 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 see 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 an untranslatable value.

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 new 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 new records for GTM.

How the Conversion Changes Transaction Records
The following information is provided to assist developers and others who require technical information on 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 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
 
Table
Summary of Changes
ard_det
For debit/credit memos, txusaarm.p sets ard_tax and ard_tax_at.
ar_mstr
For debit/credit memos, txusaarm.p sets ar_tax_env using txtxeget.p.
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.
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.
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.
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.
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.
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.
prh_hist
txusapo.p sets prh_taxc to blank if 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, to blank.
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.
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.
rma_mstr
txusarma.p sets rma_taxc from rma_taxc or from the class file, if any.
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.
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.
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.
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.
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.
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).
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.
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.