Transaction Writer report overview
A Transaction Writer report lets you create user-defined transaction reports with two 132-character lines of information for each transaction. You define the report options using Transaction Writer (AC55.1) and run the report using Transaction Writer Report (AC256). The options you define for a report determine:
-
which transaction and attribute fields print
-
which transactions are selected for the report
-
how selected transactions are sorted and totaled
-
the appearance of the column headings for the report
-
the output format (CSV file or print copy) of the report
Example 1
LGE Corporation noticed that one of their activity's outsourcing costs are close to exceeding the budget and they want to collect more information for a detailed analysis. They create a Transaction Writer report of all Accounts Payable transactions, sorting and totaling by vendor. They use this report to identify the vendors with the highest costs and to identify the specific transactions with those vendors that are the most costly.
Example 2
You are analyzing activity billing and you want to see the billable transactions that are on hold. You can create a Transaction Writer report that selects only transactions where the billable flag is set to Hold.
Date xx/xx/xx Company 4321 - LGE Corporation USD Page 1
Time 10:26 LGEREPORT - LGE Transaction Report Sort Accounting Unit, Account
For Period 01 - 01 Ending January 31, xxxx Type Amounts
Activity Transactions Only
Accounting Unit 101 Corporate Resp Controller Level 01-01
Transaction Desc Sy Jrnl Ent SC Debit Credit Balance
----------------------------------------------------------------------------- ----- ------ -------
Account 11200-0000 Cash-Checking 0.00
Monthly Sales GL N 1 JE 100.00
Misc. Medical Expens GL N 32 JE 1,150.00
Adjustment to Beg. B GL N 35 JE 1,150.00
Cash from Cash Sales GL N 49 JE 5,000,000.00
Monthly Sales GL N 51 JE 100.00
Total Activity Account 5,001,350.00 1,150.00 5,000,200.00
11200-0000 Cash-Checking Total 5,000,200.00
------------------------------------------------------------------------------------------------------------------------------
Account 11300-0000 Cash-Other 0.00
Monthly billing GL N 4 JE 800.00
Misc. Cash Sales GL N 8 JE 2,000,000.00
Total Activity Account 2,000,000.00 800.00 1,999,200.00
11300-0000 Cash-Other Total 1,999,200.00
------------------------------------------------------------------------------------------------------------------------------
Account 11400-0000 Cash-Payroll 0.00
Deposited Cash for P GL N 49 JE 5,500,000.00
Total Activity Account 5,500,000.00 5,500,000.00
11400-0000 Cash-Payroll Total 5,500,000.00
------------------------------------------------------------------------------------------------------------------------------
Account 12100-0000 Accounts Receivable-Trade 0.00
6 mos advance billin RJ N 3 JE 3,000.00
post revenue to acti GL N 14 JE 1,000,000.00
Adjustment to Beg. B GL N 35 JE 3,000.00
Total Activity Account 1,003,000.00 3,000.00 1,000,000.00