General Ledger Control Report | Contents | SCVs | Search | Glossary | Reports | Database | Solutions | XML | Index | Display General Ledger Exceptions (DGLE) |
Resetting the General Ledger Interface Table (RGLI)
Purpose: Use Resetting the General Ledger Interface Table to clear the General Ledger Interface table and recreate postings based on updated or corrected information.
Note: You cannot run the reset for any period in which you have generated a general ledger download table. The Date posted field indicates that a General Ledger Interface record has been downloaded. See Generating the General Ledger Download Table (GGLD).
When to run the reset: Normally, you use this menu option only if the general ledger is out of balance. You can use the General Ledger Control Report to determine if any journal sources are out of balance.
You can also use the reset if you change the setting of a system control value that affects how G/L transactions post.
You should not attempt to run the reset for the current date if there is any ongoing activity that could affect the general ledger, or if the asynchronous jobs are still active.
Periodic function: You can also use the GLRESET periodic function (PFR0117) to reset the General Ledger Interface table. This periodic function:
• Runs for the prior date
• Uses the division from the A/P Invoice Upload Division (H70)
• Uses the bank from the A/P Invoice Upload Bank (H71)
If either of the above system control values is blank, the function writes an error to the APP.log file. See Logs for more information.
For more information: See How to Schedule a Job for information on how to schedule a periodic process.
In this topic:
• Reset General Ledger Interface Screen
Reset General Ledger Interface Screen
How to display this screen: Enter RGLI in the Fast path field at the top of any menu or select Reset General Ledger Interface Table from a menu.
Field |
Description |
Start date |
The first date to include in the reset. Numeric, 6 positions (MMDDYY format); required. |
End date |
The last date to include in the reset. You should not attempt to run the reset for the current date if the asynchronous jobs are still active. Numeric, 6 positions (MMDDYY format); required. |
Bank |
The bank code to use for deriving the G/L account number for the credit posting for A/P disbursements. The system uses the A/P cash general ledger number. Bank codes are defined in and validated against the Bank table. See Working with Banks (WBNK). Alphanumeric, 3 positions; required. |
Division |
The division to use for A/P postings. The system uses this division and its associated entity when recreating the general ledger postings for accounts payable purchases and disbursements; however, if there was a Division specified for the warehouse when you received the purchase order related to the A/P activity, the system uses this division instead. See the description of the Division field under Creating and Maintaining Warehouses (WWHS) for more information. Division codes are defined in and validated against the Division table. See Working with Divisions (WDIV). Alphanumeric, 2 positions; required. |
Submit to batch |
This flag controls whether you submit a batch job or run the reset interactively. Valid values are: Selected (default) = Submit a batch job Unselected = Run the reset interactively. You will need to wait at the screen until the reset is complete. |
In general, the system clears the general ledger records for the specified period and rebuilds the records from the records in the Item Transaction History table, bypassing any records whose GL Post Date is zero.
Update |
Source of Information |
Clears the General Ledger Interface table and General Ledger Detail table for the specified date range |
N/A |
Resets sales transactions Note: The system does not include invoices in the general ledger reset whose Processed date in the Invoice Header table is 0, indicating the Delay Billing Updates (K85) system control value is selected and the invoice has not yet been included in the Delay Billing Update Process. |
Invoice Ship To table Invoice Header table Invoice Detail table Order Header table Invoice Detail Charge table Order Additional Charge table |
Tax rates |
Effective dates for the SCF or postal code |
Order transaction amounts |
Invoice Payment Method table |
Credit card deposits |
• If the Deferred and Installment Billing (F51) system control value is unselected, from the Invoice Payment Method table (total of freight, additional freight, tax, handling, and merchandise, based on the division associated with the source code on the order header) • If the Deferred and Installment Billing (F51) system control value is selected, from the CC Deposit History table. For G/L account numbers: Bank table (debit transactions) or Pay Type table (credit transactions) |
A/P payments |
For transaction amount: A/P Invoice Detail History (calculated by multiplying the cost * units) For G/L account number: A/P Invoice Header Division and entity: entry at the Reset General Ledger Interface prompt screen (only if the division was originally supplied at a prompt screen, as in A/P entry or A/P check generation) |
Void transactions for A/P checks |
A/P Check table G/L account number: A/P Invoice Header table |
A/R transactions |
A/R Header and Detail tables |
G/L adjustments |
G/L Adjustments table |
Changes to G/L account numbers |
New number from appropriate table. The exception is inventory transactions, which use the G/L number that is stored in the Item Transaction History table |