How to allocate freight based on the Weight of the Product received against the PO

[former_member686452]

Hello Team,

I am working on a project in which the Freight Invoice (freight cost) needs to be allocated to the Material cost based on the Weight of the Product received against the Purchase Order. Is there an automated way that ByD handles following request on Procurement end?

[chenlu_zhang]

Hello Kevin,

Currently in standard system, freight cost can only be allocated to products based on the purchasing price of the product against the purchase order.

For example, in a purchase order, you have

Product A, 1 ea, 20 USD/ea.

Product B, 2 ea, 10 USD/ea.

The total gross amount of the PO is 40 USD.

Say freight cost is 4 USD.

The cost of product A = 20+ (20/40)*4, =22 USD/ea.

The cost of product B = 10+ (10/40)*4, =11 USD/ea.

Best Regards,

Chenlu

[chenlu_zhang]

You can also refer to below KBAs:

1968917 - How to Capture other Costs During Creation of Purchase Order

1976098 - How to capture unplanned delivery cost in supplier invoice without reference to purchase o...

2571093 - How to add Overall Freight charges to the Purchase Order?