Updating reorder points automatically

Question

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?

David Speck · Answer

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.

Sage 100

Updating reorder points automatically

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING