Hello,
I have exhaustively searched Epicor manuals and the web for a solution to my problem (below) for 2 days. Hoping someone can help.
The initial issue:
Purchasing wanted to order some T-slot rail from a vendor. This item is setup in our system as inches, across the board. The item is sold in 10’ lengths, but we have it set to inches since we issue it to a job that way. When the purchaser put in 720" of material to the PO, it came out as 720 pieces (7200’). Should have came out as 6 pieces of rail since one rail=120".
Attempted solutions:
-
Working in TEST database first, I checked on the part number. UOM in Part Maint. matches up with that of the PROD database. Still working in TEST, I went to Supplier Price List and populated the part number/vendor information. Supplier UOM (under the part entry field) shows up as EACH. Not sure why. But OK. I then checked off “Override Conversion” and set “1 EA MULTIPLY 120=120.000 IN.” Saved my work, closed. I went to create a mock purchase order, still in TEST. This time, when I put 720 IN as the quantity, it converted correctly to supplier’s quantity of 6. So, this does what I need it to. Now let’s go to PROD, repeat this and call it a day–right?
-
In my PROD database, I opened Supplier Price List. I repeated everything from above. When I check “Override Conversion”, I get the error message “Cannot override the Base Unit of Measure of the UOM Class.” Why??? All Part Maintenance UOM’s match. Part classes match. So, after reading the help file and the manual, I tried changing my Purchasing units to EA and keeping everything else at Inches. Saved. Go back to Supplier price list, and refresh. Override Conversion still gives me the same error.
-
Opening Supplier Price List in PROD and TEST, I compared all details. I noticed Supplier UOM in PROD is “IN” and TEST is “EA”. The pull-down field is greyed out. So now, I’m onto something, I thought. Question here: Where does EPICOR pull the UOM for supplier UOM? Help file says from the Part Maintenance menu, but I can’t find anywhere in part maintenance that I have an EA UOM.
3a. I found an article here that suggests that the Supplier UOM will be set next time you edit a PO suggestion. I tried to generate suggestions in TEST, but was unsuccessful in doing so. This idea doesn’t seem logical. Why would you set your UOM in price list from a PO suggestion? If someone can poke a hole in my doubt, please feel free.
-
Opening Part Maintenance in both databases, I compared once more, every single attribute. Everything matches.
-
Checked for open POs in PROD database. None open, but one was recently closed.
-
I tried to see if I could cross reference where Vendpart.PUM field was populated from. My lack of understanding on data dictionary probably just added to the confusion. I’m sure there’s a way to do what I need.
-
I tried searching through UOM Maintenance and UOM Class Maintenance. I do not wish to change UOMs or class on the part-there’s no need.
-
Worthy of noting, neither PROD or TEST part is tracked for multiple UOMs. Again, I don’t see the need when it works the way we need it to in TEST.
Open to your solutions, and I am grateful in advance! I am new to EPICOR, so please be patient if I have follow up questions. Thanks!