|
Jeffrey, We have done it number of times on version 6.0.04. There are number of things to consider. First, you need to change how the order number is generated. BPCS checks for Order existence when assigning new number, but it only does it 1000 times and if all thousand times it found that order is already used, it will assign 1001 number without checking for duplicate. There is also a glitch, which will cause order number ZERO to be assigned, but you can manually change order number in System parameters to avoid that. We wrote custom purge to purge only orders, for which invoices are completely paid. If you use BPCS purge, you need to make sure that it purges all files that contain order number as a key. If you have any custom files, which contain order numbers, they also need to be purged. Some of the BPCS reports will not print in correct sequence, and that will need to be validated based on your specific needs. One of the last important points is your customers, some of them keep track of order numbers and may not be able to handle duplicates or simply will complain that new numbers are lower than older ones. If you decide to roll the numbers, leave 1-2 month of numbers available under old sequence and roll them over. If you run into issues, you can go back for a short while. We run into promotion assignment problem, where old promotions were assigned to the new orders at time of posting to GL, which causes JE errors. We do not use OLM, this is another area, which needs to be tested. One other suggestion is BPCS 8.0. The order number there is 8 digits instead of 6. If you are planning to upgrade and can wait, it will be your best solution. Hope this helps, please contact me off line if you have any other questions, Regards, Yan Shargorodsky Y&Y Solutions, Inc Phone:(215)741-7138 Cell: (267)934-8327 e-mail: yshargorodsky@yysinc.com -----Original Message----- From: bpcs-l-admin@midrange.com [mailto:bpcs-l-admin@midrange.com]On Behalf Of Weston, Jeff (ICP) Sent: Monday, September 09, 2002 12:22 PM To: bpcs-l@midrange.com Subject: BPCS Order Number Roll Greetings, Has anyone gone through an Customer Order Number roll (from 999999 to 000001) and be willing to share experiences with us. Thanks Jeffrey Weston International Comfort Products _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
