Sprint 3 - Activity Create Inventory Ordering / 3.3.5.3 Check Your Work

NISHI
Occasional Contributor

Sprint 3 - Activity Create Inventory Ordering / 3.3.5.3 Check Your Work

Dear Community,

3.3.5. Activity: Create Inventory Ordering/3.3.5.3 Check Your Work

Please help with this activity... values are not matching, need solutions/formula hints to match the same.

NISHI_0-1645779221659.pngNISHI_1-1645779236599.png

NISHI_2-1645779377417.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sahitya
Contributor

Hi @NISHI 

 

The difference in forecast demand might be coming because of override? checkbox in DEM03 Demand Forecast. Check the Week2 FY20 and put override value to 62 and check whether it is matching or not in INV01. As suggested by @Misbah your reorder formula needs adjustment.

 

Cheers,

Sahitya

View solution in original post

4 REPLIES 4
Misbah
Moderator

@NISHI 


Small correction in the Reorder Flag

 

Swap Ending Inventory and Shipping Time Weeks - Formula should look like OFFSET(Ending Inv, Shipping Time Weeks, 0) < 0

 

Also I see there is minuscule difference of 2 in Forecast - that might be because of Override somewhere. I can't recall which module is that but see if you have input an override/adjustment of 2 on that particular intersection.

 

Hope that helps

Misbah
Miz Logix

NISHI
Occasional Contributor

Thank you, for the solution it has been resolved.

Sahitya
Contributor

Hi @NISHI 

 

The difference in forecast demand might be coming because of override? checkbox in DEM03 Demand Forecast. Check the Week2 FY20 and put override value to 62 and check whether it is matching or not in INV01. As suggested by @Misbah your reorder formula needs adjustment.

 

Cheers,

Sahitya

NISHI
Occasional Contributor

Thank you for the solution its been resolved.