3.3.5.2A Beginning Inventory formula

Prithi · 2023-12-05T11:03:27+00:00

Hello I need some help in this formula * Beginning Inventory: This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week for all other weeks of the year. i have just created these in my…

Prithi

Hello

I need some help in this formula

Beginning Inventory: This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week for all other weeks of the year.

i have just created these in my SYS01 time module

Is this is correct as per the stated requirements for system module ?

Accepted answers

All comments

umangsinghal

@Prithvi kaleeswaran As formula hint suggests, you should not use formula in "1st week of Timescale?" lineitem. You can select the first week manually.

umangsinghal

Prithi

My question is the formula for the SYS module for 1st week of the timescale is correct or not ?

How can i select manually FY20 ? where ?

umangsinghal

Formula is not required in 1st week of Timescale?. After removing the formula from this lineitem, checkboxes will be enabled to select. There you can click to check the checkbox under Week1 FY20.

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.