General Ledger Interface Summary | Contents | SCVs | Search | Glossary | Reports | Database | Solutions | XML | Index | General Ledger Control Report |
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.
Batched A/P invoices: If the Batch Entry of A/P Invoices (F02) system control value is selected, A/P invoices are entered in batch mode using the Enter A/P Invoices Screen (When Using Batching). In this situation, the system does not include batched A/P invoices on the General Ledger Control Report until the batch has been accepted. See Accepting or Rejecting a Batch for more information on how to accept a batch of A/P invoices.
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.
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.
Tables that provide the transaction totals for each journal source:
If a journal source is out of balance, you can query the related table to research the discrepancy.
For Journal Source... |
Transaction Totals from... |
Sale/Merchandise Sale |
Invoice Ship To table |
Sale/Freight |
Invoice Ship To table |
Sale/Additional Freight |
Invoice Ship To table |
Sale/Additional Charge |
Invoice Ship To table |
Sale/Handling |
Invoice Ship To table |
Sale/Tax |
Invoice Ship To table |
Sale/GST |
Invoice Ship To table |
Sale/PST |
Invoice Ship To table |
Sale/Cash/Check |
Invoice Payment Method table (pay category Cash/Check) |
Sale/Credit Card |
Invoice Payment Method table (pay category Credit Card) |
Sale/Coupon/GC |
Invoice Payment Method table (pay category Coupon/Credit) |
Sale/A/R |
Invoice Payment Method table (pay category A/R) |
Sale/COD |
Invoice Payment Method table (pay category COD) |
Cash/A/R |
Cash Receipts Header table (A/R amount) |
Cash/Sundry Debit |
Cash Receipts Sundry table |
Cash/Sundry Credit |
Cash Receipts Sundry table |
Cash/Credit Card Deposit |
Cash Receipts Header table (credit card amount) |
Cash/Deferred Liability |
Cash Receipts Header table (deferred liability amount) |
Coupon/Deferred Liability |
General Ledger Adjustment table |
A/R |
A/R Open Item table |
A/R Adjustment |
A/R Cash Receipts table (debit invoice amount) |
Refund/Cancel |
General Ledger Adjustment table |
Refund/Refund |
General Ledger Adjustment table |
Refund/Write Off |
General Ledger Adjustment table |
A/P Purchases |
A/P Invoice Detail History table |
A/P Cash |
A/P Invoice Detail History table |
A/P Expense |
A/P Invoice Detail History table |
A/P Disbursements |
A/P Invoice Detail History table |
A/P Disbursements Offset |
A/P Invoice Detail History table |
Inventory Value |
Item Transaction History table Note: The report does not include records whose GL Post Date is zero. |
Inventory Offset |
Item Transaction History table Note: The report does not include records whose GL Post Date is zero. |