auditor question - - manual vs automated journal entries

(0) Share

Report

Posted on by Community Member

Hello Everybody,

We have new auditors this year who are not familiar with GP, and they are asking :

1/ if there is a way to distinguish between an automated vs a manual journal entry (we are looking in GL20000 / GL30000 tables) - - we are filtering on various fields (user - series - sourcedoc - etc) to build the appropriate list but as a true verification they would be more conformable if there was a 'flag' that distinguishes 'automated' vs 'manual'

2/ how they can test the automated entries

I'm not quite sure where they draw the line between automated and manual - - for me, all our processes (distribution, manufacturing) are automated - - where the system posts according to the setups and the quantities we are reporting.

Any thoughts and suggestions are appreciated.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: auditor question - - manual vs automated journal entries

Hi,

Just to add all valuable suggestions by all others. You might run Smartlist-Financial-Accounts and filter by Allow account entry = Yes. If you dont find any account on this that mean none of your account enter manual journal entry. By this way the auditor can confirm what account you have allowed to enter manual journal entry and what account you haven't allowed to do manual entry which is good system control.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: auditor question - - manual vs automated journal entries

To provide you auditor with a precise and convincing justification, make sure to include the transaction source column from the account transaction smart list. Direct journal entries should have a transaction source starting with:

GLTRX (Gl Transaction Entry)

GLTHST (GL To History)

GLREV (GL Reversing Entry)

GLCLR (GL Clearing Entry)

Let us know if you have any further inquiry

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: auditor question - - manual vs automated journal entries

1. Go to Smart List (MS Dynamics GP)

2. Financial --> Account Transaction

3. Click column to add "Source Document" & "Originating Master ID" columns.

4. Click the OK.

5. Then click excel to export all the transaction to excel file

6. Set below filter to get the manually created journal entries.

Series = Financial

Source Document = GJ

Originating Master ID = ""(empty)

7. Other than above filtered records are automated from other transactions.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: auditor question - - manual vs automated journal entries

If the transaction is posting to the GL from a subledger Payables for example if that is considered Automated then you can add to your filter the Original Master ID or Original Source ID - one of the two should work - that will provide the reference that it was generated outside the GL.

All transactions posted in the GL and that started as JE entries then are considered Manual?

Not sure if I am clear on the definition, but, I believe based on what you posted, this is how I would apply my solution.

Hope this helps.

Was this reply helpful? Yes No