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.
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
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
MisbahMiz Logix
Thank you, for the solution it has been resolved.
Thank you for the solution its been resolved.
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…