3.3.5.3 Check Your Work - issue with beginning inventory numbers - can anyone please help!

Hi, my numbers on beginning inventory aren't changing from 13,000 below -

Sharing the relevant screenshot incl SYS01 Time Settings By Week - any help would appreciated as why the numbers from beginning inventory are getting referenced prroperly…

Also, to add, when I'm changing the formula to IF (…) from IF NOT (..) earlier, the values are now changing to ending inventory as below..

Don't know how to fix .. issue is driving me crazy …

Thank you so much!

Accepted answers

anand.shekhawat

Hi @PreetiJain

Try this ⇒ START() > CURRENTPERIODSTART()

Let me know if it works

~Anand

All comments

PreetiJain

Hi @anand.shekhawat , @JaredDolich

would you pls be able to help here…

pyrypeura

How does your "not first week of calendar" values look like. I assume that's problem in your module that your if else clause never hit's the point where it should take beginning inventory from DAT01 module

anand.shekhawat

Hi @PreetiJain

The below screen looks good to me.

But, If we analyze the data for 'Beginning Inventory' it is always pulling the Previous of the 'Ending Inventory'

It never goes into the else part to pull the data from DAT.01 Module.

So I would want you to check the 'Not 1st week of Timescale?' line item in the SYS.01 Module. The logic should be written in such a way that the boolean should be unchecked for the 'Week 1 FY20' and remain checked for the rest of the time scale.

Please let me know if it helps.

~Anand

PreetiJain

Hi @anand.shekhawat , please see below formula used in the SYS01 module but what should I change here to make the first box unchecked here in FY20 column.. please help.

Thank you.

anand.shekhawat

Hi @PreetiJain

Try this ⇒ START() > CURRENTPERIODSTART()

Let me know if it works

~Anand

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…