Information Systems:Overnight Reports
Daily
Invoice Journal is not printed, but is grabbed by Catapult and filed at SuperServer / Accounting / common / ASWreports / InvJournal / periodPPPPPP / InvJournalJJJJ.pdf where PPPPPP is the accounting period, and JJJJ is the journal number.
*VA/480B* INVOICE JOURNAL NO : 3753 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---- Invoice ----- Acc. Number Typ Date per. Due date Cust Inv.addr Debtor Curr Amt excl VAT VAT amt Amt incl VAT - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3175919 2 02/17/16 1701 03/10/16 10009 10009 10009 CAD 211.94- 10.60- 222.54- 3175920 2 02/17/16 1701 03/10/16 10143 10143 10143 CAD 45.56- 2.28- 47.84- 3175921 2 02/17/16 1701 03/10/16 10144 10144 10144 CAD 47.20- 2.36- 49.56- 3175922 2 02/17/16 1701 03/10/16 10258 10258 10258 CAD 54.00- 54.00- 3175923 2 02/17/16 1701 03/10/16 10289 10289 10289 CAD 118.08- 118.08- 3175924 2 02/17/16 1701 03/10/16 10336 10336 10336 CAD 111.93- 7.46- 119.39- 3175925 2 02/17/16 1701 03/10/16 10353 10353 10353 CAD 583.20- 583.20- 3175926 2 02/17/16 1701 03/10/16 10418 10418 10418 CAD 167.42- 6.41- 173.83- 3175927 2 02/17/16 1701 03/10/16 10418 10418 10418 CAD 60.94- 60.94- 3175928 2 02/17/16 1701 03/10/16 10423 10423 10423 CAD 197.38- 197.38- 3175929 2 02/17/16 1701 03/10/16 10439 10439 10439 CAD 24.44- 1.21- 25.65- 3175930 2 02/17/16 1701 03/10/16 10497 10497 10497 CAD 132.04- 132.04- 3175931 2 02/17/16 1701 03/10/16 10497 10497 10497 CAD 12.96- 0.65- 13.61-
Miscellaneous Billing and DIS to FIN generate several reports, but as they are not used, they are deleted. If any of these (GCFP752, GCFP852, FKR050P, FMR051P, FMR056P, FMR065P, or FMR066P) are in the spool file for user EODJOB (WRKSPLF EODJOB) it means that the ASW DIS to FIN did not complete. This has happened in the past, and doesn't seem to have any effect other than transactions have the wrong date as they will be posted the following day.
DIS and WHM Integrity Reports compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.
Lost Sales Report is printed on ELAHO.
Weekly
Onhand Inventory by Item Account Group (a stock status report) is not printed, but is grabbed by Catapult and filed at SuperServer / Accounting / common / ASWreports / InventoryValue / periodPPPPPP / StockStatCCYYMMDD.pdf where PPPPPP is the accounting period, and CCYYMMDD is the date.
Balance Transaction reports are printed on ELAHO. Queries are run by CL program BALTRANS to check that warehouse transactions (SROITR), location transactions (WHOLTR), warehouse balances (SROSRO), and location balances (WHOLOP) all agree with each other. Every time a balance file is updated, a record of what was done is written to the transaction file. Therefore they should always agree. Every time an item comes into or goes out of the warehouse, or is adjusted, the warehouse files are updated. Every time an item is moved, the location files are updated. Therefore they should also agree. Except for a timing issue; an item can be received and put on the shelf on Friday, then the PO not closed (which updates the warehouse files). There is a report of item like this; so if the difference between warehouse and location totals match this report, nothing is wrong.
Monthly
All the period reports are grabbed by Catapult and files at SuperServer / Accounting / common / ASWreports / PeriodReports / periodPPPPPP / where PPPPPP is the accounting period.
The reports are A/P Reconciliation List, A/R Reconciliation List, Unmatched Receiving, Stock Status by Item Account Group, and Surplus Stock.