INV01 Line Item;Shipping Cost

Highlighted
Frequent Contributor

INV01 Line Item;Shipping Cost

Hi,

 

I'm confused on the Line Item Formula above. Please advice. 

 

'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:(Final Shipping Cost/1000)*'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units']

 

Thank you 

1 REPLY 1
Highlighted
Frequent Contributor

Re: INV01 Line Item;Shipping Cost

Hi @neg177 

 

You should be multiplying Final Shipment Amount / 1000 & cost per 1000 units looking up to Product and shipping method . 

In lookup we should be doing any calculations . 

We are dividing Final shipment amount by 1000 because we need to get the Final Shipment amount of single Unit . 

 

Thanks,

Puneeth HP