Breaking Out a Summarized GL Transaction

Posted on: August 20, 2008 | By: SuperUser Account | QAD Distribution

Recently, a client had the Summarized Journal flag set to “Yes” in the Inventory Control File (3.24). This functionality allows the system to create one summarized journal transaction for each combination of date, entity, account, sub-account, cost center, and project or one summarized journal transaction for each active session, depending on the Journal Reference Method selected.

While conserving transaction volume in the general ledger, this can make tying GL references back to tr_hist a little tricky. Fortunately, the trgl_det file offers the translation from the glt_hist (post GL transaction detail) and gltr_det (unposted GL transaction detail). If you have ever wondered where the “scrolling” transactions are stored as you advance through the 3.21.1 Transaction Detail Inquiry, it is this gltr_det file. How these entries are pushed into the gltr_det, and ultimately posted to the general ledger, depends on the Summarized Journal flag is set.

Fortunately, these trgl_det records are retained until the Transaction Consolidation program is used to archive the gltr_hist records.



Is Your Accounting Software Hurting Your Business?
Is Your Accounting Software Hurting Your Business?

Free Download:

Is Your Accounting Software Hurting Your Business?

Download the guide ›

Top 10 Inventory & Operations Decisions Distributors Are Making Blind
Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Free Download:

Top 10 Inventory & Operations Decisions Distributors Are Making Blind

Download the guide ›

2020 Nucleus Research Report on ERP Technology

Free Download:

2020 Nucleus Research Report on ERP Technology

Download the guide ›