- Data is stored in the IV00102 table per location
- Record without location is the default for the item
- select ITEMNMBR, LOCNCODE, SFTYSTCKQTY, ORDRPNTQTY from iv00102
- update iv00102 set SFTYSTCKQTY = 5, ORDRPNTQTY = 10 where ITEMNMBR = 'ITEM001' and LOCNCODE = 'LOC001'
Monday, June 5, 2017
Dynamics GP - Set Safety Stock values using SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment