3.3.5.2A Beginning Inventory
Hello,
I have added formula for Beginning Inventory and it is reflecting as well but when I am checking WK5 FY2020 I can see 13000 instead of 4866.
So, can anyone help me in this that what is wrong here?
Thanks & Regards
Answers
-
You need to set the current period in model calendar.
As per the formula if Week 5 is the first week of timescale, then it will fetch previous month of Ending Balance else it will take from Beginning Inventory from DAT01 module.
0 -
what can be the Current Period then?
0 -
SYS01 Time Settings By Week'.'Not 1st Week of Timescale? as name of line item depicts current period should be 1st Week of Timescale → Week 1 FY20.
0 -
Current Period has to be Week 1 FY20 and as per formula, if it's not the first week then it should take previous month value of Ending Inventory
0 -
Hello… Thanks all for your feedback.
I got the issue…. actually for 1st Week of Timescale in SYS01 I have ticked all the first week of year 2020 i.e. WK1, WK5, WK9 and so on and due to which the formula was checking that thing. As I remove the ticked from all the first week (apart from WK1) I can see the desired result like below.
so, can anyone confirm if this is the correct one?
Regards,
Viral Patil
0 -
Set Current Week as Week 1 FY20 in Model Calendar and put in the formula
ITEM(Time) = PERIOD(CURRENTPERIODSTART())
0 -
done
0