L2S3 INV01 Shipping Costs

Options
Akumar94an
Akumar94an Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi community members, can someone please take a look at my formula for 3 3 5 6 Update Inventory Ordering to Calculate Shipping Costs - Shipping costs line item

 

Here's the formula hint provided in the course:

Formula Hints: 

Shipping Costs: 

  • In the TRA01 Shipping Metrics by Week module, the Shipping Costs are priced per 1,000 product SKU units.
  • To calculate the Shipping Costs per order, the Final Shipment Amount of the order is divided by 1,000, and the result multiplied by the Cost per 1,000 units.
  • The formula will be similar to the Shipping Time Weeks line item formula.
  • Also, remember to reference the Shipping Method to align to the appropriate Cost per 1,000 units in the Shipping Metrics by Week module.

Here's my formula:

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

 

Thanks in advance

Tagged:

Comments

  • Akumar94an
    Akumar94an Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    No Issue as such, just wanted to make sure if my formula is correct. since there's no activity in L2S3 to check if shipping costs formula/ values are correct.

Categories