INV01 Line Item Formulas and Results




Attached are the Formulas and Results for INV01. My weekly numbers are off by 2 units and my monthly numbers are off as well by the total number of units by weekly numbers are off. I have checked all my inputs and cant seem to find the problem. Attached are my pics of INV01, Please advice. 


Thank you 

Best Answer


  • I got the formula. I used HALFYEARVALUE to get my values for the Line Item Safety Stock Target. 


    Thank you