Re: Changing Purchasing UM

Bill:



You are correct to be concerned about making this change to the Purchasing
U/M while there are Open P.O.'s or Unvouchered P.O.'s. I haven't done an
in-depth analysis for your question, but here are my initial thoughts.



The P.O. Line (HPO) File contains two (2) fields related to the Purchasing
U/M and the Conversion Factor:

. PUMCN U/M conversion

. PUM Purchase U/M



The P.O. Quantities are in Purchasing U/M and it is the PUMCN that converts
to Stocking U/M that is used for Inventory purposes. I believe that the
P.O. Price is also entered in terms of the Purchasing U/M.



When you will change the Purchasing U/M in the Item Master to LF to match
the Stocking U/M, you will also be changing the Item Master Purchasing U/M
Conversion Factor to 1.00000. However, this change will NOT be replicated
to the HPO File.



You can do some testing to see if the remaining Open P.O.'s will process
correctly with the existing Purchasing U/M values that are stored on the HPO
File. That is, the existing P.O.'s might be OK for you to complete the
processing. But, test this idea out first.



Otherwise, you can either complete or close the Open P.O. Lines and then
make the change before entering new P.O.'s.

Alternatively, you might consider writing a conversion program to update the
Open P.O.'s to reflect the new reality. That is, convert the P.O.
Quantities and the Price to the LF values and change the Pur Conv. to
1.0000.



You will need to think through and test the A/P Invoice 3-way Matching as
well since I would expect that the HPO values are used there too.

Other things to think about will be the Vendor Quotes and the Vendor History
(not sure if stored in Stock U/M or Purch U/M - Probably Stock???).



The Standard Cost is in Stock U/M so you don't have to worry about it.



I hope that I have given some things to think through. Obviously, this type
of change must be thoroughly investigated and tested to be sure that all of
the implications have been identified.



If you have any questions or if you would require any assistance in
accomplishing this task, please feel free to contact me offline.



Thanks.



Les Mittman

BPCS Consultant with over 20 years experience

847-858-5235



-----Original Message-----
From: bpcs-l-bounces+lmittman=sbcglobal.net@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lmittman=sbcglobal.net@xxxxxxxxxxxx] On Behalf Of
Bill
Sent: Wednesday, June 16, 2010 1:18 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Changing Purchasing UM



We're on 4.05CD. We have a couple of items that are currently purchased

in LB and stocked in LF. We'd like to change the purchasing to be LF.



What are the ramifications in changing this with open po's and po's

received but not vouchered?



I imagine chaos would ensue and so we are trying to plan a neat cutover

involving closing out open po lines and data changeovers in a particular

sequence and pilot that. Are we correct to be concerned or does the

system handle it smoothly and we're being too cautious?



Bill