Hi,
I am sure I am using correct formula for calculating Beginning Inventory but my module doesnt seem to reflect that.
Formula - IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory.
But output for first month is coming 0 since it is not picking up value from DAT01.
Please help
Hello @Karan.dhanak
1. Is this happening with all SKUs or just the one in the screenshot?
2. Have you confirmed that the data is correct in Dat01?
3. Use Drill Down (F8) to view the calculations step by step maybe that will give you an idea where is it going wrong?
4. Are you sure your Not 1st week of Timescale? is returning the right value?
5. Ensure that you have the right dimensions for both Source and Target modules, they both should be dimensioned with P3 SKU
Check the above and let me know what you find.
Hi @einas.ibrahim ,
Yes, all the points that you mentioned, I had already checked. Actually, the values were appearing fine a day ago but suddenly the Beginning inventory from DAT01 stopped being reflected today. Hence, I added a LookUp at the end of the formula i had put earlier and the values started reflecting again.
Funny enough, I tried removing the LookUp I had added to see if the values still appeared the same and surprisingly they did. I believe there would have been some Anaplan bug which temporarily failed the formula.
Anyway, thanks for the input and prompt response.
A word about using the LOOKUP in this particular formula. You will notice that both
return the correct answer. Why is that? and which formula is correct?
If we follow the logic of constructing a lookup we will find that the Source module is dimensioned by both P3 SKU and the Distribution Center Location, while the Target is dimensioned only by P3 SKU. This means if I want to get a single value (intersection) then I need to provide the Location lookup, otherwise, since we didn't specify a location the formula will return the Beginning Inventory for the P3 SKU in All Locations.
Since the data in DAT01 is organized in such a way that each SKU is distributed from a single location then the result of the first formula for Nutzo Bar_EN is 13,000
The result of the second formula - without the Location Lookup - will return the sum of the beginning inventory for All Locations for Nutzo Bar_EN which is also 13,000 since the value of all Beginning Inventory in the other locations is 0
You may argue that the way DAT01 is set up is not the best since it results in a lot of sparsity, but there might be good reasons to have a setup like that. Auditability for example or if you plan to distribute a product from more than one location.
For that reason, while both of the above formulas return the same correct value, for sustainability you should use the first one; 'DAT01 Beginning Inventory'.Beginning Inventory[LOOKUP: Distribution Center]
Hello,
I am having the same issue with my formula returning zero for the first week. How did you resolve it??
Hi, Just looking at your comments.. I would recommend to check the if System module used for the Distribution center lookup is populated. As I believe this would a logical reason for the issue, may be this was populate on the second day..
Hi - Is this still a bug. I also get zero for the week 1 FY20.
Any help is highly appreciated.