issue with the inventory formula of the line item.

mohammed007
mohammed007
in Academy Discussions

i have been stuck at it for more than 90 mins.The following are the formulas of the line items, and modules and the values shipping by weeks are zero and issue with the dimension.can someone check and provide me with correct formulas. The formulas are obtained from following attachment.

q3.png
q4.png
question.png
qustion2.png

Thank you

with regards

Mohammed

Answers

  • Venki9902
    Venki9902

    Hi @mohammed007 ,

    Seems you need to add one more lookup for shipping time in weeks.
    Along with sys08 use the shipping method for lookup.

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

    Hope this helps :).

    Regards,
    Venkatesh

  • mohammed007
    mohammed007

    can you provide me with formula for the shipping method and the shipping with week is showing the same issue.

    for the shipping method to be populated with the values i have use i have filled the TRA01 line items with formulas but i don't see any values in the inventory module.

    thank you

Categories