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
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
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.
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
when use smart-list >financial > account transactions> *
it will display a list of journal entries that are sequential
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
