3.3.7.2 Add DCA to INV01 Inventory Ordering

Yosr
Yosr
in Academy Discussions
INV01.png

Hi, I am encoutering several issues with this module compared to the screenshot i have from the training!

Fisrtly, the fisrt value for week, the suggested Order Amount for the Month does not appear!
Additionally, the shipping costs values, Final Shipping time weeks, Final Shipping costs Shipping Cost Varianvce are different!
Any help ? thank you!

INV.png

Best Answer

  • Rajat26
    Rajat26
    Answer ✓

    Hi @Yosr

    I can see that you have made an error in your Final Shipping Costs formula you have referred

    Shipping Time (Weeks) instead of Cost per 1000 Units. The correct formula would be

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

    Hope this helps!

Answers

  • Rajat26
    Rajat26

    Hii @Yosr

    As far as the DCA is concerned here is the read and write access you are supposed to give

    Screenshot 2024-08-30 142030.png

    And for the values which you are getting wrong I think you have made an error in your formula, can you send a screenshot so that I can help you.

  • Yosr
    Yosr

    Thank you for answering! For DCA it works perfectly, yes, thank you for your help.

    This is my formula :

     Final Shipping Costs : Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

     Shipping Cost Variance :IF
    NOT Override Shipping Method?
    THEN
    0
    ELSE
    Shipping Costs - Final Shipping Costs

  • Yosr
    Yosr

    Hi !

    Thank you for answering! that was very helpful, it works!

Categories