List of Vendors for reorder points

Proposal Summary

We will be updating the reorder point for items from all preferred vendors.

Requirements 

Corp Designs have a set of preferred vendors and they would like to set reorder point for items from those vendors based on the item quantity in the invoices (status: approved)  for a particular duration. And this update of the reorder point should happen monthly. The reorder point has to be set to a value equal to the ‘total quantity of items(from invoices for a given duration) + 30% of the total’

The preferred vendor with the duration of months for taking invoice item quantity is given below:

Aod-Sling ( 6 months),Anji Cha-25 ( 6 months),Zheji-Broad POTENZA ( 5 months),Anji Fu-128( 6 months),Heng-17 ( 5 months),Good-7 ( 5 months),Fosh-307 ( 6 months),Zheji-Yueq-21 ( 5 months),Uno-5 ( 5 months),Zheji-King-NTTF-LG ( 5 months),Zhuo-T23( 5 months),Bon_PDM( 6 months) and Wen-PIAZ ( 6 months)

Our Solution

• Instead of hard code the name of vendors, add two custom fields to the vendor record. 
• One will be a check box if it is checked that the vendor will become the preferred vendor.
•  Another field is for storing the duration for taking invoices to find out  item quantity.
• Our script will make a search to find out all preferred vendors and duration.
• And the script will find out items from each preferred vendor and its total quantity  from all invoices for a period given in the vendor record in location wise. 
• Finally it will update the reorder point in the item record in each  location as Total Quantity + 30% of total Quantity.
• While setting the reorder point we will also consider preferred stock level in each location .If the preferred stock level is greater than the calculated quantity then the reorder point will be set as the preferred stock level. If the preferred stock level is less then the reorder point is set as the calculated quantity.
• We will schedule  the script as it can run at the beginning of every month.

Assumptions

We assume that the vendor record will be updated for preferred vendors with duration.