Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Audit

Posted on by Microsoft Employee

Our auditors want a list of journal entries that are sequential, but because we use recurring batches the journal entries are not sequential is there away around this. They want to know that they have access to all of the entries made during the fiscal year. Thanks

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Audit

    Hi again,

    Keep in mind that the posting numbers start over either each period or each year (you specify which), so the auditors will have repeats year to year. I am still amazed that the auditors think the numbering of entries somehow validates that they have accounted for all of the transactions. It is a database, I can easily change all of the journal entry numbers with a few SQL update statements.

    I too am a CPA, and for the life of me I do not understand why auditors still ask this question. It reminds me of the olden days when we had to account for all of the check numbers and invoice numbers. Today we just  print whichever number suits us. Give me a number and I'll put it on the invoice. Heck, we print everything on blank check stock these days.  Go figure :)

    Kind regards,

    Leslie

  • Suggested answer
    mpolino Profile Picture
    mpolino on at
    RE: Audit

    GP supports this but you have to turn it on. Setup>Company>Company>Options>Enable Posting Numbers in General Ledger.

    As Leslie mentioned, Dex_Row_ID can serve as a proxy.

    From the help:

    Enable Posting Numbers in General Ledger   Mark this option to assign each transaction a unique sequence number during posting, in addition to the journal entry number. Use this option if you want solid numbering of transactions, without gaps. Solid numbering is a legal requirement in some countries, for auditing purposes.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Audit

    Hi Connie,

    This, in my opinion, is a lame question for an auditor to ask. It's a database, all of the records are in the tables, who cares if they are 'sequential'. You have the Dex_Row_ID field in the database table. That's your sequential record. Every time a new record is added to the table, the Dex Row ID increments. It's a SQL identity field. This is as bad as an auditor wanting to account for every check or invoice number.

    I apologize for the harsh answer. It is certainly not directed to you, it's to the bone-head auditor that asked the question. I would be delighted to enlighten him/her on the way of the database if you'd like.

    Do you think the Dex_Row_ID field would satisfy their request?

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Audit

    when use smart-list >financial > account transactions> *

    it will display a list of journal entries that are sequential

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans