Do you know how to DROP. AN. AUDIT?
It's easy if you know how. But there are some limitations and stipulations.
Short and sweet? GL04D - Delete Transactions by Audit is the program used to drop a general ledger audit. An important and handy reminder…the GL04D button can be protected so that only certain users have the ability to do the drop.
Typically, the kind of entries that can be dropped from the General Ledger are simple GL03 audits. The entire audit must be dropped - can't drop just a piece of an audit. And GL04D bears some discussion on what can and cannot be dropped from the General Ledger, key words here being GENERAL LEDGER. Audits that affect a sub-ledger cannot be dropped. Accounts Payables AP03 - Transaction Entry is a good example of entries that affect a sub-ledger and cannot be dropped. To allow that would cause the sub-ledgers to get out of balance to the General Ledger and that is NO BUENO.
GL04D drops audits from the General Ledger ONLY, not from any of the sub-ledgers. A warning message to that effect is displayed as a reminder that the option deletes entries ONLY FROM the GENERAL LEDGER.
The SSI warning message also recommends to review the audit entries in the General Leder before attempting to use GL04D to delete those entries. Remember, the only way to recover deleted entries is to restore from backup. Better be careful of what you wish for!
Another BIG, YELLOW WARNING MESSAGE appears in the GL04D dialog screen as a reminder that only General Ledger entries will be deleted - no entries affecting a sub-ledger will be deleted.
Seeing a pattern here?
When using GL04D to drop entries there are several filters available.
You will need to verify:
- Company
- Button (i.e. the program used to make the entries - example GL03)
- Audit (found on the original audit report)
- Reference - optional. If the button and audit is entered the Reference is normally not necessary
- Period - the General Ledger Accounting Period in which the entries reside.
Optional Selection Criteria
- Exclude Entries Older Than This Date - primarily designed for SSI internal utilities and typically not applicable. It excludes from dropping audits older than the specified date that have identical Required Selection Criteria. Which means if more than one audit has the same audit number in OPEN PERIODS, don't delete entries older than the date entered.
- Drop Duplicates Only - another filter designed for SSI internal use. Be careful if you think you want to use this. Sometimes duplicates aren't REALLY duplicates! Contact SSI's HelpDesk for assistance with duplicated audits.
What audits CANNOT be dropped? Anything that has a sub-ledger, for example - AP03 Accounts Payables Transactions, AR03 Accounts Receivables Transactions, or anything that's gone through JIB processing. There are of course others as well but these are the main ones. In most cases the application will throw a HARD NO and stop you from making this mistake.
Oh! And one more thing! The GL04D does NOT delete audits from any periods CLOSED to General Ledger History. GL04D only drops entries in OPEN General Ledger periods.
So you can see, the SSI Oil and Gas Accounting Software has built into the GL04D program parameters for most instances where entries cannot/should not be deleted.
If used within its boundaries, GL04D can be a handy tool to keep your SSI Oil and Gas Accounting System clean and correct, minimizing in and out wash entries.
For General Ledger problems that are a little more complex? Call SSI HelpDesk! We can help make YOUR job EZier!!