Hi Team,
I have been struggling for a long time here in the INV05 Shipping Export module below is the blueprint mode:
Below is the layout for my INV01 Inventory Ordering module
The formula for Shipping Costs is as below:
Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
The formula for Final Shipping Costs is as below:
Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
Below is the layout for SYS06 Location Details:
Expected output for INV05 Shipping Export as per the screenshot is as below:
VS my actual output is as below:
Could you please help me where I am doing wrong?
Any help will be appreciated