Hi,
There is a report which helps in determining the Inventory details. For this, We will load data only for Mondays of each week. The columns present in the report are Sold-to-party, Material, Average Mvt for 3 prior weeks, 3 week target, 4 week target, on hand inventory, weeks in inventory, Last week's inventory, Change in inventory, Additional needed for 3 weeks & Additional needed for 4 weeks. The problem is with the columns On hand inventory, Weeks in inventory, Last week's inventory & Change in inventory. For the last 3 mondays alone, there is no data coming up for this columns. For all other mondays data is coming up correctly, only for the last 3 mondays this 4 columns are displaying blank.
I checked with the Formulas of this columns, they look simple & Fine. The formula for Weeks in Inventory is On hand inventory/Avg Mvt for 3 prior weeks. The formula for Change in inventory is On hand inventory-Last week's inventory.
Help me in fixing this.
Thanks,
Murali