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.