INV01 Line Item Formulas

neg177

Hi,

Would like to know if my Line Items are correct. Please advice

The Line Items are on the attached pic.

Thank you

anaplan_question_8_85066.PNG

Accepted answers

filip.sypniewski

Hi @neg177,

couple of tips below:

PO(Purchase Order) Submitted - follow the naming provided as on exam you need to copy paste some of the formulas.They will not be recognized if your line items have different names, should be 'PO Submitted'
Confirmed PO Delivery, think about second part of your formula, whether you should be looking at Shipping Time Weeks or other, similar line items
You should also review your Confirm Purchase Order Receipt line item formula, the part within POST function
Ending Inventory, review line item, you have your starting inventory, then some forecast demand, but confirm PO receipt should not be substracted
Safety stock target you should use different formula than WEEKVALUE

Good luck! Let me know if you have some questions.

All comments

filip.sypniewski

Hi @neg177,

couple of tips below:

PO(Purchase Order) Submitted - follow the naming provided as on exam you need to copy paste some of the formulas.They will not be recognized if your line items have different names, should be 'PO Submitted'
Confirmed PO Delivery, think about second part of your formula, whether you should be looking at Shipping Time Weeks or other, similar line items
You should also review your Confirm Purchase Order Receipt line item formula, the part within POST function
Ending Inventory, review line item, you have your starting inventory, then some forecast demand, but confirm PO receipt should not be substracted
Safety stock target you should use different formula than WEEKVALUE

Good luck! Let me know if you have some questions.

neg177

I'm having a hard time trying to figure out what formula I would use for Saftey Stock Target Line Item.

This is the formula I'm using WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock), not sure what formula other than weekvalue.

thank you

mohdtazeem

@neg177

Kindly try using HALFYEARVALUE function for your formula of Saftey Stock Target Line Item. I was also not getting expected result with WEEKVALUE then I gone through the similar available functions.

Thanks

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…