INV01 L2 Sprint3 Shipping cost and final Shipping Cost formula

For Shipping cost i wrote the formula as :

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

what should be the formula for final shipping cost ?

Tags

Accepted answers

All comments

The Formula looks correct except the last lookup statement. Instead of the shipping method refer Final Shipping Method.

Quick Links

Can you help?

Unanswered questions

REST API V2 after 16-Feb-2026 for CA Certificate authentication
Hi Does anyone successfully find the correct way to adapt the REST API scripts according to the new API v2 CA Certificate standards: adding the new parameter "encodedDataFormat": "v2", I tried to prefix the encodedData using the timestamp (also UTC), using 8+92 or 8+100 bytes but I did not find the right combination…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…