Adding inbound freight to you inventory part cost.

Hi,

I am assuming your inventory part is weighted average. Have you explored the option of adding charges to the Purchase Order? The charges can have a different vendor and can be invoiced separately.

Yes , we do use weighted average and I currently do add a charge line for freight.  But this cost doesn’t roll into the cost of the individual part.

Hi,

Can you check the following on your charge type

Distribute On Receipt? 

If that is unchecked, please check that and select the Distribute Charge by based on your requirement.

Hi @Mpreite ,

We are using IFS Applications 10 Update 8.

We use weighted average and we use charges to record freight charges and basically add the freight charge to the inventory part when we receive it.   We do not have the checkbox Distribute on Receipt because we distribute the charge by Per Line which basically spreads the cost of the freight charge across all purchase order lines evenly.

Here’s our freight charge setup.

Here’s a purchase order line for 6500 gallons ordered @ $3.50 a gallon for total of $22,750.00.   So 6500 gallons * $3.50 = $22,750.00

Freight charge amount on the purchase order for $1,260.00.

Here’s the landed cost of the inventory item which $3.69 a gallon and that’s what recorded in the inventory transactions.   6500 * 3.50 = $22,750.00 + 1,260.00 = $24,010.00

$24,010.00 / 6,500 = $3.69 a gallon landed cost.

Regards,

William Klotz

This works great.  I wish I could receive it then add the freight cost and it distribute because that is the normal business flow.  But functionally this works perfectly.

Thank you