1 / 20

Application Drill Down

Application Drill Down. 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.

hanne
Download Presentation

Application Drill Down

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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.

More Related