report showing the journal entry preparer and the journal entry approver (poster) in the system

(0) Share

Report

Posted on by gerrie teddy

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

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

Which version of GP you are using ?

Read this:

www.azurecurve.co.uk/.../mdgp-2013-feature-of-the-day-saved-gl-batch-approval

Was this reply helpful? Yes No
gerrie teddy 90 on at

Like (0)

Report

i am using GP version 9. hope you can help. thanks, gerrie

gteddy@pemexprocurement.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No