G/L Interface Posting List | Contents | SCVs | Search | Glossary | Reports | XML | Index | General Ledger Control Report |
Chapter 42: Printing the General Ledger Control Report (PGLC)
Purpose: Use the General Ledger Control Report to compare various transaction totals to their associated General Ledger postings for a range of dates.
This report is broken out by transaction total, G/L total, and total out of balance for each journal source.
General Ledger Control Report Screen
How to display this screen: Enter PGLC in the Fast path field at the top of any menu or select Print G/L Control Report from a menu.
GLR0054 ENTER General Ledger Control Report 10/16/98 9:07:37 The KL Mail Order Company
Start date . . . . . . . . . 091598
End date . . . . . . . . . . 101598
F3=Exit F9=Submit F12=Exit |
Field |
Description |
Start date |
The first date to include on the report. Numeric, 6 positions (MMDDYY format); required. |
End date |
The last date to include on the report. Numeric, 6 positions (MMDDYY format); required. |
For more information: See General Ledger Overview provides an overview of general ledger number setup and transactions.
Files that provide the transaction totals for each journal source:
If a journal source is out of balance, you can query the related file to research the discrepancy.
For Journal Source... |
Transaction Totals from... |
Sale/Merchandise Sale |
Invoice Ship To file |
Sale/Freight |
Invoice Ship To file |
Sale/Additional Freight |
Invoice Ship To file |
Sale/Additional Charge |
Invoice Ship To file |
Sale/Handling |
Invoice Ship To file |
Sale/Tax |
Invoice Ship To file |
Sale/GST |
Invoice Ship To file |
Sale/PST |
Invoice Ship To file |
Sale/Cash/Check |
Invoice Payment Method file (pay category 1) |
Sale/Credit Card |
Invoice Payment Method file (pay category 2) |
Sale/Coupon/GC |
Invoice Payment Method file (pay category 5) |
Sale/A/R |
Invoice Payment Method file (pay category 3) |
Sale/COD |
Invoice Payment Method file (pay category 4) |
Cash/A/R |
Cash Receipts Header file (A/R amount) |
Cash/Sundry Debit |
Cash Receipts Sundry file |
Cash/Sundry Credit |
Cash Receipts Sundry file |
Cash/Credit Card Deposit |
Cash Receipts Header file (credit card amount) |
Cash/Deferred Liability |
Cash Receipts Header file (deferred liability amount) |
Coupon/Deferred Liability |
General Ledger Adjustment file |
A/R |
A/R Open Item file |
A/R Adjustment |
A/R Cash Receipts file (debit invoice amount) |
Refund/Cancel |
General Ledger Adjustment file |
Refund/Refund |
General Ledger Adjustment file |
Refund/Write Off |
General Ledger Adjustment file |
A/P Purchases |
A/P Invoice Detail History file |
A/P Cash |
A/P Invoice Detail History file |
A/P Expense |
A/P Invoice Detail History file |
A/P Disbursements |
A/P Invoice Detail History file |
A/P Disbursements Offset |
A/P Invoice Detail History file |
Inventory Value |
Item Transaction History file |
Inventory Offset |
Item Transaction History file |
Delivery Confirmation |
Order Line History file (OLH quantity) Order Detail file (ODT price) The system uses this calculation to determine the transaction and G/L totals: OLH quantity x ODT price |
Delivery Confirmation Offset |
Order Line History file (OLH quantity) Order Detail file (ODT price) The system uses this calculation to determine the transaction and G/L totals: OLH quantity x ODT price |
G/L Interface Posting List | Contents | SCVs | Search | Glossary | Reports | XML | Index | General Ledger Control Report |
AP_APPC CWDirect 18.0 August 2015 OTN