The Cutek Blog

Last year, Symitar added repgen access to the GLTRAN and GLENTRY files and hardly anyone noticed. These files store all of your daily transactions that have posted since the last Close Day; it’s the exact same information that you get from Teller Totals. Actually, it’s more than what you get from Teller Totals because it includes detail for all user numbers and it includes pseudo-transactions (things like Check Hold information).

Previously, if you wanted to list all checks received during the day, you had to go to the Teller Totals work area or you had to run Teller Totals by Batch and either eyeball the report or parse it with a custom specfile. Now that you have access to the raw data, you can generate this listing instantly with a specfile and present it anyway that you want.

Unfortunately, the release notes were a bit thin on details. Here’s where we can help a bit.

• You can use the cross-file access features to get to the GLTRAN file. So, if you’re sitting on a Share Transaction record and you want to get the full details for the corresponding transaction, you can use the following:

   KEYVALUE=FORMAT("99999999999",MONEY(SHARE TRANSACTION:SEQUENCENUMBER))
   FOR GLTRAN WITH SEQUENCENUMBER KEYVALUE
    DO
     [You are now sitting on the GLTRAN that corresponds to your Share Transaction]
    END

• It’s important to note that the GLTRAN file is emptied when Close Day is run, so you only have access to the GLTRAN for the current date
• To read through all GLTRAN records, either use a batch specfile or use the following in a demand specfile:

   FOR GLTRAN WITH SEQUENCENUMBER "+"
    DO
     [processing for each GLTRAN goes here]
    END

• GLTRAN:POSTCODE can be a little confusing. Rather than try to explain what Symitar means by “0 = Not posted” and “1 = Already posted”, if you want non-voided transactions, just check that GLTRAN:POSTCODE=0.
• An easy way to visualize the difference between GLTRAN and GLENTRY is to compare it to the teller detail shown on Teller Totals:
  Simply use a FOR EACH GLENTRY command to get to the GLENTRY records.