Data not matching In inv01 inventory ordering

 

I am stuck on this module from last 2 day but not getting how to get data correct my formule are correct 

The image for data what i have got is below

16601316457923747299547518111661.jpg

16601316743706287957678199015262.jpg

Comments

  • @Brj73Look at the input data in the task. As I recall you have to fill in some values in order to test you calculations for matching

  • I have done that even after that there are are error

     

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

     

    As per this formula is correct, how you are input the data as you're getting the values. So you're correct only. Go-ahead.

  • 1660210501606282839187886294140.jpg

    16602105240461837543310803472397.jpg

     the first image is the output we should get secong image is the one o got 

    1. Error here is ending inventory and beginning inventory is different for week 3 and week 4

    2. Confirm purchase order is receipt value in week 4 is different 

  • @Brj73 

    This module is always the tricky one for all learners. There were many questions in this forum regarding it.

    I'd recommend you to go through some solutions from the past: Just click magnifier to search and type "inv01" as below.

    KirillKuznetsov_0-1660211839125.png

    I am sure you will find the answer there.

    For example, here @filip.sypniewski gives good tips for this module: https://community.anaplan.com/t5/Anaplan-Platform/INV01-Line-Item-Formulas/m-p/85066/highlight/false#M18738

     

  • I have searched i did not get anything
  • @Brj73 

    Looking at two screenshots I can say that calculated line items such as Final Shipment Amount and Shipping costs are not matching in values. Meaning you have to look through your formulas once again.

  • These are the formulas i have used  

     

    Final shipment amount :IF NOT Submit Purchase Order Request? THEN Suggested Order Amount for the Month ELSE Override Amount

     

     

    Shipping cost :  'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] / 1000 * Final Shipment Amount

  • @Brj73 

    I think here you need to change to

    IF NOT Override suggested order amount? THEN Suggested Order Amount for the Month ELSE Override Amount

     

  • After applying the formula u told

    The value i got for shipping cost is 532.6 and in lesson it is shown 529.7 

    And 2 error remains the same as mentioned above about ending and beginning invnetory

     

  • No, The formula in Final Shipment amount will be this one only:--

    IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount

    Because after submit purchase order request? only the override or suggested amount need to appear.