L2S3 INV01 Shipping Costs

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

Comments

  • What is the issue you're running into?

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

  • It looks right to me based on the requirements you posted! Nice work!

  • Any idea how would this formula change for the Final Shipping Amount line item?