ApplicationDrillDown Using Batch Posting Concept
Drill Down • Given a General Ledger Account Balance, what activity generated that balance?You Should be able to see all the journals in summary, and then, if desired see the detail behind the journal, and if desired, the actual transactions.
How Was This Accomplished? • G/L Account Balances were moved to a separate file. Gives unlimited years of account balance history. • A Transaction Summary file was created (Journal/Acct #/Batch/Post Month) • Each Transaction Entry File had a Batch Header File Added as a First Level.
Batch Features • Batch Numbers are unique to the system • One batch can be posted, while others are being entered, printed, changed, or posted! • Specific Batches can be selected for printing, verifying or posting. • A new selection process was added.
Selected Batch • Assigns Unique Process ID to User • Only Batches with User Process Id will print, verify or post by Journal Code • Once Verified, May not be edited, unless unselected (Clears Process Id)
Journals • All Journals Print by Batch, with batch subheading and subtotals. • Journal Printed Flag stored in Batch Header along with user information and Process Id. • Verify will print Journals, if not printed prior to verification.
Side Benefits • There is a new history file that exactly matches each transaction file, that is tied to a batch header history record. • Besides drill down display, it is now possible to re-print any journal from any Batch if desired (substitute History file for transaction file)
Side Benefits • Every transaction that affected any G/L Account, Product, Customer, or Vendor is able to be called up and displayed showing the date, time and user. • Future drill downs can be added for customer and vendor agings or transaction inquiries, product qnty, etc.