Create Shipping Export Module and Create a Saved View

divyeshkhandpur92
divyeshkhandpur92
in Academy Discussions

Hi Team,

I have been struggling for a long time here in the INV05 Shipping Export module below is the blueprint mode:

image.png

Below is the layout for my INV01 Inventory Ordering module

image.png

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:

image.png

Expected output for INV05 Shipping Export as per the screenshot is as below:

image.png

VS my actual output is as below:

image.png

Could you please help me where I am doing wrong?

Any help will be appreciated

Tagged:

Best Answer

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

    image.png

    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.

Categories