Updating reorder points automatically

SUGGESTED

Our reorder point changes dramatically based on usage. I really don't want to have to continually update reorder points manually. We have several thousand sku's and it's just not practical. Is there a way for sage to automatically update reorder points based on a rolling usage number or some other formula, say the last 3 months usage? 

  • 0
    SUGGESTED

    I don't believe stock Sage 100 has anything like that.  I think Sage Inventory Advisor did attempt to recommend how much to order based on usage but I don't think it actually updated the reorder points.  You could create a report, excel workbook, access database, etc that would query the data and produce the reorder points in a delimited format which you could then use a Visual Integrator Import job to update the reorder points in Sage 100.  The reorder data is stored in IM_ItemWarehouse and it requires at least the item code and warehouse code to update a record.