Invoice Freight Charged should be added to item cost.

Problem Description---------------------------------------------------

We are implementing Inventory purchases.Client’s requirement is Freights charged on the invoices should be added on the Item Cost.

The expectation is to do not manually update invoices on Payables. High volume of invoices will be created via XML and invoices will include item lines and freight line.

The expectation is those freight lines contained on the invoices are allocated and added to Item Cost without manual intervention by Payables team. The logic is to prorate the freight between all lines of the invoices and add it to the Item cost.

Does anyone knows if this is doable? I have not implemented LCM but the process looks very manual (need to add Reference details, which does not seems to be doable to handle via interface).