Change lead time on Purchased Product Advice report. : Alpha Baking

Change lead time on Purchased Product Advice report. Print

Modified on: Thu, 27 Jul, 2023 at 2:12 PM

The Purchased Product Advice report runs twice per day. It generates an email primarily for Helen and Michelle Evans to know what vendor items to order to keep in stock in the freezers. It looks at inventory, sales history, lead time, etc. on many products and suggests when they should order each item and how much to order.

Occasionally the lead time will change on one of these products. That is stored in a table called PurchProdLeadTime. Here is an example of how to update the lead time for a particular product:

BEGIN TRAN UPDATE PurchProdLeadTime SET LeadTime=14 WHERE Product='63610'

Did you find it helpful? Yes No

Change lead time on Purchased Product Advice report. Print

Related Articles