Information Systems:Periodic-Monitor
- Invoice Numbers - Estimated to Wrap in 2018
- Pick List Numbers - estimated to Wrap in 2018
- 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.