Monday, June 5, 2017

Dynamics GP - Set Safety Stock values using SQL


  • 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'

No comments:

Post a Comment