INV01 inventory module formulas

Hamzashaikk
Hamzashaikk
in Academy Discussions
expected result.jpg
result.jpg

1st photo is expected result after adding formulas, 2nd photo is my result. Where am I going wrong?

Answers

  • Hamzashaikk
    Hamzashaikk

    formulas used -

    Beginning Inventory - IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

    Forecast Demand - 'DEM03 Demand Forecast'.Final Forecast

    Reorder Flag - OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

    Suggested order amount for month - MONTHVALUE(Forecast Demand)

    PO Submitted - IF Submit Purchase Order Request? THEN 1 ELSE 0

    Confirmed PO Delivery - OFFSET(PO Submitted, -Shipping Time Weeks, 0)

    Shipping Method - 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By]

    Shipping Time Weeks - 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]

    Confirmed Purchase Order Receipt - IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0

    Ending Inventory - Beginning Inventory + Confirmed Purchase Order Receipt - Forecast Demand

    Safety Stock Target - HALFYEARVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock)

    Safety Stock Exception Count - IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

  • kiaouu
    kiaouu

    @spacebar clicker As you click to unlock rewards, you'll find yourself involuntarily dragged into the game.

Categories