Invo5 shipping costs

16604688019124298227245752174418.jpg

 The above image show what has to be done 

16604688705484332103345505183564.jpg

I have attach the data i am getting for shipping cost is wrong 

I am not able to rectify please help me out what i have done wrong .

Comments

  • @Brj73 

     

    Looks like you don't have right numbers in Final Shipping Costs of INV01 module. Check if you have numbers in there across all the months.

  • Yes there are no values
  • @Brj73 

    So, This is the formula for INV05 Shipping Cost:

    'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center]

    As you can see, it depends on final shipping cost of inv01 module.

    so, you need to check the inv01 final shipping cost line item. Is everything is 0 or value is there and also refer the formula for recheck.

    inv01  final shipping cost:

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

     

     

  • Formula u mentioned are exactly same which i have used
  • @Brj73 

     

    Can you send me the screenshot of inv01 final shipping cost line item values till Mar20 !