Friday, November 21, 2008

Blogs

Aug 21

Written by: Brian Clark
8/21/2008 4:25 AM

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.

Tags:

Your name:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment    Cancel  

 
 

Print  
Logan Consulting Blog

Search

Print  

Logan Consulting
(L.G. Consulting, Inc.)

200 West Adams Street, Suite 2002
Chicago, IL 60606

Ph: (312) 345-8800 • Fax: (312) 345-8801