Information Systems:Overnight Reports - Revision history

Norwinu at 16:12, 7 July 2016

2016-07-07T16:12:39Z

New page

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

'''[[Warehouse Balances - Discrepancies#Location Balance Integrity Report|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.'''

[[Category: Overnight Processing]]

Sheilav: /* Weekly */

2016-02-24T01:42:39Z

Weekly

Sheilav at 21:13, 18 February 2016

2016-02-18T21:13:58Z

Sheilav at 20:22, 18 February 2016

2016-02-18T20:22:03Z

Sheilav at 20:20, 18 February 2016

2016-02-18T20:20:59Z

Sheilav at 20:20, 18 February 2016

2016-02-18T20:20:39Z

Sheilav: Created page with "==Daily== '''Invoice Journal''' - this is not printed, but is grabbed by Catapult and filed at SuperServer / Accounting / common / ASWreports / InvJournal / periodPPPPPP..."

2016-02-18T20:19:50Z

Created page with "==Daily== '''Invoice Journal''' - this is not printed, but is grabbed by Catapult and filed at SuperServer / Accounting / common / ASWreports / InvJournal / periodPPPPPP..."

New page

==Daily==

'''Invoice Journal''' - this 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.

'''[[Warehouse Balabces - Discrepancies#Location Balance Integrity Reports|DIS and WHM Integrity Reports''' compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.

← Older revision		Revision as of 20:22, 18 February 2016
Line 24:		Line 24:
	'''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.		'''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.

−	'''[[Warehouse Balances - Discrepancies#Location Balance Integrity ~~Reports~~\|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.	+	'''[[Warehouse Balances - Discrepancies#Location Balance Integrity Report\|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.

← Older revision		Revision as of 20:20, 18 February 2016
Line 24:		Line 24:
	'''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.		'''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.

−	'''[[Warehouse ~~Balabces~~ - Discrepancies#Location Balance Integrity Reports\|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.	+	'''[[Warehouse Balances - Discrepancies#Location Balance Integrity Reports\|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.

← Older revision		Revision as of 20:20, 18 February 2016
Line 24:		Line 24:
	'''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.		'''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.

−	'''[[Warehouse Balabces - Discrepancies#Location Balance Integrity Reports\|DIS and WHM Integrity Reports''' compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.	+	'''[[Warehouse Balabces - Discrepancies#Location Balance Integrity Reports\|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.

← Older revision		Revision as of 01:42, 24 February 2016
Line 32:		Line 32:
	'''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.		'''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)	+	'''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.'''

@@ Line 1: / Line 1: @@
 ==Daily==
-'''Invoice Journal''' - this 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.
+'''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
@@ Line 25: / Line 25: @@
 '''[[Warehouse Balances - Discrepancies#Location Balance Integrity Report|DIS and WHM Integrity Reports''']] compare warehouse balances (SROSRO) to location balances (WHOLOP) and reports on any differences.