Tracking GL Transaction Changes

M

mcochrane

New Member
Hello,

Does anyone know if there is a way to determine what GL transaction rows are new vs. old transaction records. We are sourcing our journal level data to a data warehouse and want to incrementally capture only new records. We have noticed the entered and posted dates can be back dated which means we would lose data.

We are looking for some type of system generated audit date field that may be able to tell us when the record was created or modified. Any help would be appreciated.

Thx, Mike
 
Mike
When the GL transaction is created by the system, the GL reference itself represents the date stamp:

<transaction type><yr><mm><dd><transaction number>

So I think you can use this field to select transactions for your data warehouse.
Hope it helps
Regards
Max


mcochrane said:
Hello,

Does anyone know if there is a way to determine what GL transaction rows are new vs. old transaction records. We are sourcing our journal level data to a data warehouse and want to incrementally capture only new records. We have noticed the entered and posted dates can be back dated which means we would lose data.

We are looking for some type of system generated audit date field that may be able to tell us when the record was created or modified. Any help would be appreciated.

Thx, Mike
Click to expand...
 
Thanks Max,

We reviewed the data in the field and noticed that the date corresponds to the effective date field which is manually entered and can be back dated. Do you know if there is any other table that may join to the gltr_hist table that may be a 100% guarantee that we get the most recent records? I appreciate your help.

Thx, Mike
 
Mike
If this is an automatic GL transaction, then you can link it back to the originating transaction, for example, typ AP - to ap_mstr, IC - to tr_hist, and so on. If this is a manual trx, then I am not sure.... eB2.1 has full audit trail capabilities in "Enhanced Controls" module, you may consider it.
Sorry, could not give you more definite answer
Regards
Max
 
Hi Mike

The easiest way to detect standard new GL bookings is to use the standard GL export routine. In each gltr_hist use is made of the gltr_export indicator.
It is possible to add conversion rules. In case you don't use the conversion rules the not exported gltr records are written into a data file.

Independing from the MFG/Pro version you can use program gltrexp.p. It will probably recide under menu 25.19

If the data warehouse is making use of the database directly you can use the export program to set the export indicator and don't use the output file.

William W.
 
You must log in or register to reply here.
Back
Top