Create Shipping Export Module and Create a Saved View
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
Best Answer
-
Hello,
Seems like all the formulas are correct. Just try to remove the override amount and update the Submit Purchase order request Boolean. I Hope this might help.
Adding Screenshot for reference.
Formula of Final Shipment Amount -
IF NOT Submit Purchase Order Request?THEN 0ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
Let me know if you still have any concerns.
0