Information Systems:Periodic-Monitor - Revision history

Sheilav at 17:28, 16 December 2015

2015-12-16T17:28:03Z

Sheilav at 17:19, 16 December 2015

2015-12-16T17:19:17Z

Sheilav at 17:19, 16 December 2015

2015-12-16T17:19:03Z

Sheilav: Created page with "=Monitor= ==Invoice Numbers - Estimated to Wrap in 2018== We started in 2005 with an invoice number of 1000001, and credit note number of 3000001. On June 5, 2009 invoice n..."

2015-11-19T19:30:10Z

Created page with "=Monitor= ==Invoice Numbers - Estimated to Wrap in 2018== We started in 2005 with an invoice number of 1000001, and credit note number of 3000001. On June 5, 2009 invoice n..."

New page

=Monitor=

==Invoice Numbers - Estimated to Wrap in 2018==

We started in 2005 with an invoice number of 1000001, and credit note number of 3000001. On June 5, 2009 invoice numbers passed 3000000 and duplicated the credit note numbers. ASW was fine, as it accesses files by invoice number / type (1-invoice, 2-credit note) / year. The extensions were not. We quickly changed them to use the same key structure - after changing the next invoice number (in the number series table) to 5000001.

When the invoice number reaches 8999999 it will go back to 1000001. I don't think anything will happen - but keep an eye on it just in case.

==Pick List Numbers - estimated to Wrap in 2018==

We started in 2005 with pick list number 5000000. In July 2013, we reached 8999999 and went back to 3000001. WE WILL HAVE A PROBLEM WHEN WE REACH 5000000 AGAIN.

The sales order detail file (SROORSPL) has pick list number on it, and has logical file using it. Before pick list numbers wrap, we will have to start clearing this field.

Custom file PLDETL will have to be purged.

The shipment archive file (ATLARCHP) wasn't created until 2010, but will have to be purged when pick list numbers approach 7550000.

I don't know what effect this will have on ASW, or what other files could be involved. As uniPHARM gets closer to this, Protelo should start investigating.

← Older revision		Revision as of 17:28, 16 December 2015
Line 2:		Line 2:
	* [[Monitor Pick List Numbers\|Pick List Numbers - Estimated to Wrap in 2018]]		* [[Monitor Pick List Numbers\|Pick List Numbers - Estimated to Wrap in 2018]]
	* [[Monitor Mail Server Framework (MSF)]]		* [[Monitor Mail Server Framework (MSF)]]
−
−	==Invoice Numbers - Estimated to Wrap in 2018==
−
−	We started in 2005 with an invoice number of 1000001, and credit note number of 3000001. On June 5, 2009 invoice numbers passed 3000000 and duplicated the credit note numbers. ASW was fine, as it accesses files by invoice number / type (1-invoice, 2-credit note) / year. The extensions were not. We quickly changed them to use the same key structure - after changing the next invoice number (in the number series table) to 5000001.
−
−	When the invoice number reaches 8999999 it will go back to 1000001. I don't think anything will happen - but keep an eye on it just in case.
−
−	==Pick List Numbers - estimated to Wrap in 2018==
−
−	We started in 2005 with pick list number 5000000. In July 2013, we reached 8999999 and went back to 3000001. WE WILL HAVE A PROBLEM WHEN WE REACH 5000000 AGAIN.
−
−	The sales order detail file (SROORSPL) has pick list number on it, and has logical file using it. Before pick list numbers wrap, we will have to start clearing this field.
−
−	Custom file PLDETL will have to be purged.
−
−	The shipment archive file (ATLARCHP) wasn't created until 2010, but will have to be purged when pick list numbers approach 7550000.
−
−	I don't know what effect this will have on ASW, or what other files could be involved. As uniPHARM gets closer to this, Protelo should start investigating.

@@ Line 1: / Line 1: @@
 * [[Monitor Invoice Numbers|Invoice Numbers - Estimated to Wrap in 2018]]
-* [[Monitor Pick List Numbers|Pick List Numbers - estimated to Wrap in 2018]]
+* [[Monitor Pick List Numbers|Pick List Numbers - Estimated to Wrap in 2018]]
 * [[Monitor Mail Server Framework (MSF)]]

← Older revision		Revision as of 17:19, 16 December 2015
Line 1:		Line 1:
		+	* [[Monitor Invoice Numbers\|Invoice Numbers - Estimated to Wrap in 2018]]
−	=Monitor=
		+	* [[Monitor Pick List Numbers\|Pick List Numbers - estimated to Wrap in 2018]]
		+	* [[Monitor Mail Server Framework (MSF)]]

	==Invoice Numbers - Estimated to Wrap in 2018==		==Invoice Numbers - Estimated to Wrap in 2018==