Friday, September 27, 2013

Dynamics GP - Set the default selling UofM of all items to the base UofM for that item

update IV00101 set selnguom = baseuofm
--SELECT     a.BASEUOFM, IV00101.SELNGUOM
FROM         IV00101 INNER JOIN
                          (SELECT     IV00101_1.ITEMNMBR, IV00101_1.ITEMDESC, IV40201_1.BASEUOFM, IV00101_1.DECPLQTY
                            FROM          IV00101 AS IV00101_1 INNER JOIN
                                                   IV40201 AS IV40201_1 ON IV00101_1.UOMSCHDL = IV40201_1.UOMSCHDL) AS a ON IV00101.ITEMNMBR = a.ITEMNMBR
WHERE     (IV00101.SELNGUOM = '')



No comments:

Post a Comment