General Ledger Download Audit Report
How to print: The system generates this report when you populate the General Ledger Summary Download File (IXGLDS) (if the G/L Download Type (G03) system control value is set to SUMMARY). Use this report to review the total transaction amounts included in the summary download file, and the total number of General Ledger Interface records captured.
Note: This report includes all records that are currently in the download file. If you did not clear the download file before using the Generate General Ledger Download File menu option, the report includes newly added and previously existing records.
CWDirect 3.5 General Ledger Download Audit Report EKAPLAN GLX0088 2/16/99 12:52:35 Page 1 EZK Mail Order Selection Criteria: Date: . . . . . : 02/28/98 Excluded Division: Cross Journal Journal Transaction # GL Date Reference Number Source Source Description Amount Records 02/16/98 6786786 D Sale/Merchandise discount $ 10.00 1 4545454 3 Sale/Cash/Check $ 11.00- 1 1234567 T Sale/Tax $ 1.00 1 02/16/98 Totals: Debits $ 11.00- Credits $ 11.00 02/19/98 6786786 D Sale/Merchandise discount $ 20.00 1 2342342 4 Sale/Coupon/Gift Certif. $ 22.00- 1 1234567 T Sale/Tax $ 2.00 1 02/19/98 Totals: Debits $ 22.00- Credits $ 22.00 02/20/98 6786786 D Sale/Merchandise discount $ 10.08- 1 7897897 R Sale/Merchandise return $ 20.00 1 1231231 6 Sale/Accounts Receivable $ 10.92- 1 1234567 T Sale/Tax $ 1.00 1 02/20/98 Totals: Debits $ 21.00- Credits $ 21.00 02/26/98 2323232 8 Rfnd/Refund $ 13.00 1 8989898 8 Rfnd/Refund $ 13.00- 2 02/26/98 Totals: Debits $ 13.00- Credits $ 13.00 Grand totals Debits $ 67.00- Credits $ 67.00 Total Number of Download Records Created : 12 Total Number of G/L Records Selected . . : 13 |
Contents:
• latest date to include on the report (the date you selected at the prompt screen)
• excluded division, if any, from the Division to Exclude from General Ledger Download File (F68) system control value
• date when each transaction took place
• cross reference number from the General Ledger Interface file. The cross reference number is derived from the Chart of Accounts (Working with Chart of Accounts (WCA))
• code for the journal source
• description of the journal source
• total transaction amount for the date, cross reference, and journal source. This amount is net of credits; negative amounts are indicated with a minus sign.
• total number of General Ledger Interface records that are summarized in the download record
• total debits and credits for each date
• total debits and credits for all records in the download file
• total number of records in the download file
• total number of General Ledger Interface records that are summarized in the download file
| Chapter 21: Generating the General Ledger Download File (GGLD) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 22: Generating the Point of Sale Download File (GGPD) |
SO02_09r CWDirect 18.0 August 2015 OTN