Information Systems:Monitor Pick List Numbers

From uniWIKI
Revision as of 10:38, 21 January 2016 by Sheilav (talk | contribs)
Jump to navigation Jump to search

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 a logical file using it. Before pick list numbers wrap, we will have to start clearing this field. Note that just the field should be cleared; the record should be left in the file.

Custom files PLDETL, and UXSDOCP will have to be archived and purged.

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

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.

In order to monitor the process, get the current invoice number (series 2) from the Number Series Table, and periodically add it to this document. 

2015 Dec 16     3890843
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Monitor_Pick_List_Numbers&oldid=1619"