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 Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…