application drill down
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/1.jpg)
Application Drill Down
Using Batch Posting Concept
![Page 2: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/2.jpg)
![Page 3: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/3.jpg)
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.
![Page 4: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/4.jpg)
Account History Inquiry
![Page 5: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/5.jpg)
Journal Summary
![Page 6: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/6.jpg)
Transaction Detail (ytd)
![Page 7: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/7.jpg)
Order History (Transaction)
![Page 8: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/8.jpg)
Level 1 Order
![Page 9: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/9.jpg)
Level 2 - Line Items
![Page 10: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/10.jpg)
Final Level 1 Screen
![Page 11: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/11.jpg)
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.
![Page 12: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/12.jpg)
Batch Header Record
![Page 13: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/13.jpg)
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.
![Page 14: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/14.jpg)
Batch Selection
![Page 15: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/15.jpg)
Selection Process
![Page 16: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/16.jpg)
Click to Select/Deselect
![Page 17: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/17.jpg)
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)
![Page 18: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/18.jpg)
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.
![Page 19: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/19.jpg)
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)
![Page 20: Application Drill Down](https://reader035.vdocuments.us/reader035/viewer/2022062323/56815d3c550346895dcb4067/html5/thumbnails/20.jpg)
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.