Hi all -
I have been trying for days to figure out where there is an error on my own, and I have not found the solution. I believe the error is somewhere in the SYS01 module as my formula for Beginning Inventory (which I've confirmed is correct, as far as the Anaplan Community is concerned) just resets every week that begins a new month. And I'm not really sure how the time settings by week are wrong on my end. But it's VERY possible that I either missed something or my formulas need corrections or my time scale is incorrect. I have included screen shots for all the issues, please let me know if anything additional is needed! Thanks in advance!
As you can see in Beginning Inventory, it resets every 1st week of the month, which is what I thought was correct, but that doesn't produce the same results as the "Check your work" where the Beginning Inventory continues to deplete and shows Ending Inventory. What is wrong with my time settings that causes the Beginning Inventory to reset on the first week of every month?
Edit: Here are my Time Settings, maybe those were edited erroneously?
Hi @jcarbo
I assume your looking at Level 2 Sprint 3, In lesson 3.3.5 it states the following:
"
The syntax of the formula should be written: If it is not the first week of the year, then use the previous value of Ending Inventory, otherwise use the Beginning Inventory from DAT01 Beginning Inventory module.
So if you make your line item 1st week of timescale to be 1st week of year and then use a formula to calculate it, it should work.
It does say you may tick the first week of the year and then other to be a formula of opposite.
I hope this helps
Laurance Jones
Hello, I have a use case where a user will create a child if they want to make adjustments to an initial value entered at the parent level. The reason the "parent" list may not have children is that not all the list members will have adjustments. The users want to see all L1 items on the same grid as L1 items with L2 items…
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
