GL Posting Audit Trail
I suggest to add Audit trail on the user that posts GL Journal Entry. I would add the user to the GLTRXFIL and GLJNLHST. Both have room (21 and 20 characters). We already have the logic to do it in the Inventory Transaction Audit Trail. SOX Controls requires that. Public companies must have it and I see the benefit for non-public companies as well.
-
If we want to keep track of the users who enter the transaction in the subledger, that means we first need to add the user-id to the distribution file like ARDISFIL, APDISFIL , IMDISFIL ...etc. But we only have 10 bytes left with these table and we don't want to use all all the fillers of these tables. In addition, we need to add user-id to places like APTRXFIL and all other related transaction tables. This will become a big project. Therefore, I don't think we can afford to track the original user who enter the transaction. But tracking the user who post the transaction is possible. We can add that to GLJNLHST and GLTRXFIL. But that would seems to be an incomplete solution
-
I would suggest to add the original users who create the distribution in the first place. So we are not just tracking the user who post the GL journal entry, we keep track of the user who post the COP Sales Journal, PO Receiving, New AP Trx...etc. To do that, we need to add the user field to each distribution table like ARDISFIL, APDISFIL, IMDISFIL..etc.
Then we have the issue of which user to keep track, is it the user who post, or the user wo enter the transaction in the first place? Since many users use "Defer Processing" to post, so keeping track of the posting users may not be not informative. If we should keep track of the user who enter the transaction, that could become a lot more complicated. Take a sales order as an example, that could be the user who enter the order, the user wo print the pick ticket or the use who print the invoice. In AP, it would seems to make sense of keep track of the user who enter the voucher in the first place. But it may be question of AP check, do we keep track of the user who prepare the payment selection, or do we track the user who print AP checks? They may be the same, may not . For General Journal, it is pretty clear that it should be the user who enter the journal entry in the first place, instead of the user who post.
It would seems to me that here's a lot of issue to fine tune this change.