I see that this is an old post, but I recently came across this problem. On a new GP company, the item import seems to have had some items that were not imported properly. The Purchasing Options window has the problem that Jo Ann is describing. You can fix using the method she describes by changing the UOM then change it back to the original UOM. This will remove the Item Pricelist. You will then have to add the pricelist back to the item. A lot of work. The problem is that the IV00106 table (Item Purchasing Table) is missing the UOM info for that item. If you feel comfortable with SQL, you could do an insert and fix the problem.
This will let you know if the problem is with only one item or with many:
SELECT IV.ITEMNMBR, UM.UOFM, 1.0 AS QTYBSUOM, 2 AS UMPUROPT
,UM.UOMSCHDL,UM.UOFM, IV.UOMSCHDL, IV.PRCHSUOM, IV.SELNGUOM
FROM IV00101 IV
INNER JOIN IV40202 UM
ON IV.UOMSCHDL=UM.UOMSCHDL
WHERE IV.ITEMNMBR NOT IN
(
SELECT ITEMNMBR FROM IV00106
)
If only a few and you dont want to use SQL, then at least you know which items to fix using the GP UI
If you prefer to use SQL, then here is what I used for the EACH UoM. A few things to keep in mind:
ITEMNMBR = Item Number
UOFM = Unit of measure. For my example = EACH
QTYBSUOM = Quantity of UoM. For EACH = 1
UMPUROPT = The option from the drop down - 1 = Not Available, 2 = Whole, 3 = Whole and Fractional
INSERT INTO IV00106(ITEMNMBR,UOFM, QTYBSUOM, UMPUROPT)
SELECT IV.ITEMNMBR, UM.UOFM, 1.0 AS QTYBSUOM, 2 AS UMPUROPT
--,UM.UOMSCHDL,UM.UOFM, IV.UOMSCHDL, IV.PRCHSUOM, IV.SELNGUOM
--,*
FROM IV00101 IV
INNER JOIN IV40202 UM
ON IV.UOMSCHDL=UM.UOMSCHDL
WHERE IV.ITEMNMBR NOT IN
(
SELECT ITEMNMBR FROM IV00106
)
AND IV.UOMSCHDL = 'EA'
Always make a backup of the Db before doing any update/insert/delete statements!!!!
Share
Report
330
All responses (
Answers (
