Level 2 Model Building Sprint 3 3.3.5Activity :Create Inventory Ordering.

Saher

Hello! I'm stuck in 3.3.5 Activity which is to

3.3.3.5.png

formulas.png

sprint 3 issues.png

Create Inventory Ordering. I am facing multiple issues like

1.In begining inventory from week 5 data is incorrect.

2. Reordering flag is not there in week 5

3. Shipping methods are not visible although I've put formula there

4. Shipping time weeks are not showing any data

5. Ending Inventory from week 5 is wrong

I don't know what I've done wrong .It would be great if anyone can help me with this, attaching the screenshot and the module that I have created according to my understanding.

Accepted answers

All comments

BrunoRodriguez

Hello @Saher ,

I believe your summary in "Beginning Inventory" is incorrect. It should be None, Time: Closing Balance. That is the reason why the 13k appears all over the place.

As for shipping method, do you have the data populated in 'SYS08 SKU Details'.Supplied By?

Cheers!

Saher

SYS08.png

Screenshot (1).png

Hi BrunoRodriguez,

Firstly, Summary for Beginnig inventory should be in SUM, TIME Opening Balance as mentioned in activity.

I don't know why the same values are showing all over again

Secondly, Data is populated in SYS08.

Screenshots are attached for your asssistance.

Thanks!

BrunoRodriguez

Hello @Saher ,

Can you remove your LOOKUP from Beginning Inventory?

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

SYS07 is populated too?

Cheers!

Saher

BrunoRodriguez, After removing Lookup, begining inventory is showing in negative values.

SYSO7 Is populated.

Screenshots attached.

beginning.png

SYS07.png

THANKS

BrunoRodriguez

Hello @Saher ,

What do you have in DAT01? It seems like the content is 0?

Also, why does New Your not have a shipping method?

Cheers!

Saher

Hello BrunoRodriguez,

DAT01.png

DAT01 is populated. Find the screnshot.

BrunoRodriguez

Hello @Saher ,

Can you populate New York in SYS07 with Road in default shipping and let me know the result?

Cheers

Saher

Greetings!

I've populated New York in SYS07 now but still results are the same.

Have a look on screenshot.

Thanks.

Screenshot (2).png

Venki9902

Hi @Saher

Can you try this formula for re-order flag:
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 and for shipping method: IF NOT Override Shipping Method? OR ISBLANK(Override Method) THEN Shipping Method ELSE Override Method

Hope this helps:)

Regards,

Venkatesh

Saher

Hello Venkatesh

I appreciate your help but I've already used these formulae but still issues are the same.

Thanks

Venki9902

Hi @Saher ,

which line items data is not matching now.

Regards,

Venkatesh

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
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…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…