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




  • @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

  • Brj73

    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.

  • Brj73



     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.


    I am sure you will find the answer there.

    For example, here @filip.sypniewski gives good tips for this module:


  • Brj73
    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.

  • Brj73

    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


  • Brj73

    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.