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:
- 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