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

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