What Is a Transaction Writer Report?
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 (GL55.1) and run the report using Transaction Writer Report (GL256). 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
LGE has created a Transaction Writer report for all vendor accrual transactions. They use vendor number as primary sort for the report and batch number as a secondary sort. This report is a tool they use at month-end to reconcile Accounts Payable to General Ledger.
They also use Transaction Writer to create audit work papers and transaction listings to analyze business issues. The following sample shows a portion of a Transaction Writer report that is used to track balances for inventory accounts.
GL256 Date xx/xx/xx TRAN-AU-ACCT - Trans. Listing by AU/Account Page 1
Time 10:17 For Period 01 - 01 Fiscal Year xxxx
Acct Unit List POST-AU-4321 Posting AU - Company 4321
Accounts 010000 - 099999
JE # ACCT UNIT ACCT ACCT DESCRIPTION/STATUS TRN DATE PST DATE PD TRAN AMOUNT
-------- --------------- ------ ------------------------------ -------- -------- -- -----------
00000001 101 011200 Cash-Checking 01/15/98 01/31/98 01
Monthly Sales Posted GL 100.00
00000032 101 011200 Cash-Checking 01/10/98 01/31/98 01
Misc. Medical Expense Posted GL 1,150.00-
00000035 101 011200 Cash-Checking 01/15/98 01/31/98 01
Adjustment to Beg. Balances Posted GL 1,150.00
00000049 101 011200 Cash-Checking 01/31/98 01/31/98 01
Cash from Cash Sales Posted GL 5,000,000.00
00000051 101 011200 Cash-Checking 01/15/98 01/31/98 01
Monthly Sales Unreleased GL 100.00
00000008 101 011300 Cash-Other 01/28/98 01/31/98 01
Misc. Cash Sales Posted GL 2,000,000.00
00000004 101 011300 Cash-Other 01/28/98 01/31/98 01
Monthly billing Posted GL 800.00-
00000049 101 011400 Cash-Payroll 01/31/98 01/31/98 01
Deposited Cash for PA Posted GL 5,500,000.00
00000014 101 012100 Accounts Receivable-Trade 01/31/98 01/31/98 01
post revenue to activities Posted GL 1,000,000.00
00000035 101 012100 Accounts Receivable-Trade 01/15/98 01/31/98 01
Adjustment to Beg. Balances Posted GL 3,000.00-
00000041 101 015100 Stock-Medical Supplies 01/31/98 01/31/98 01
Move entries FR 15600 to 15100 Posted GL 453,650.00
015600 Receipts - Recvd not invoiced 01/31/98 01/31/98 01
Move entries FR 15600 to 22000 Posted GL 498.00
01/31/98 01/31/98 01
Move entries FR 15600 to 22000 Posted GL 330.00
01/31/98 01/31/98 01
Move entries FR 15600 to 15100 Posted GL 453,650.00-
00000050 101 016000 Prepaid Expenses 01/31/98 01/31/98 01
Prepaid Insurance Unreleased GL 50,000.00
00000015 101 021200 Accounts Payable 01/31/98 01/31/98 01