Download
application drill down n.
Skip this Video
Loading SlideShow in 5 Seconds..
Application Drill Down PowerPoint Presentation
Download Presentation
Application Drill Down

Application Drill Down

155 Vues Download Presentation
Télécharger la présentation

Application Drill Down

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. ApplicationDrillDown Using Batch Posting Concept

  2. 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.

  3. Account History Inquiry

  4. Journal Summary

  5. Transaction Detail (ytd)

  6. Order History (Transaction)

  7. Level 1 Order

  8. Level 2 - Line Items

  9. Final Level 1 Screen

  10. 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.

  11. Batch Header Record

  12. 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.

  13. Batch Selection

  14. Selection Process

  15. Click to Select/Deselect

  16. 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)

  17. 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.

  18. 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)

  19. 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.