90
Our external auditors are asking for a report in GPlains Dynamics that shows the preparer of a Journal Entry and the Approver or employee who would ultimately post the Journal Entry into the system.
Appreciate your help/thanks, Gerrie Teddy
*This post is locked for comments
Leslie
1) The original request is very specific " Journal Entry into the system" and does not talk about Payable module, hence my response was related to GL Module.
2) The original request is also specific, on getting the approver info and not the posted info - unfortunately it is not stored in GP 9 - (GP2013 does)
3) Having said that - I like your thoughts on setting up activity tracking for batch can be used to track the approval info.
Cheers!
Sanjay
Hi Gerrie,
The date the transaction was posted and the user who posted it are stored in the PM20000 and PM30000 in the POSTEDDT and PTDUSRID fields respectively.
Going forward you can use Activity Tracking to record who created the record by using File Tracking for additions to trx files.
You can also use the Support Debugging Tool and create a trigger that will log the activity.
Creating a Stored Proc to log the events is also a possibility.
Unfortunately, the feature Sanjay told us about only works for general ledger transactions, not payables transactions. It's a start, but no good for you.
Historically, I guess the best we can do is posted date, modified date, user who posted and user who modified.
Kind regards,
Leslie
Gerrie,
Searched for the tables which has the APPROVL, APRVLUSERID or APPRVLDT fields at the company database. Out of all tables, only one table related to GL has these fields, which is SY00500 the batch header / posting definition master table. Once you post the batch, based on the batch type the entry at SY00500 will get deleted.
As the posting approval info is not carried with the posted GL transactions, I doubt you will be able generate the approval report post posting GL Transactions. This is possible in GP2013 as the approval info is carried forward.
i am using GP version 9. hope you can help. thanks, gerrie
gteddy@pemexprocurement.com
Which version of GP you are using ?
Read this:
www.azurecurve.co.uk/.../mdgp-2013-feature-of-the-day-saved-gl-batch-approval
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
