Sage 100

The client gets containers shipped to them with freight and duty. The vendor sends them multiple invoices related to the one shipment. The client wants to spread the freight without merging the invoices or splitting the 3rd party cost manually. Anyone seen a solution. The client is running 2016 but can upgrade if needed.

Is there a reason the Vendor sends multiple invoices for the single shipment, aside from 1 invoice for the product and 1 invoice for the duty/freight? I might try and request a single invoice for the product portion, and then you should be able to simply use the standard Landed Cost (LC) functionality. Or couldn't they just enter the multiple invoices as a single invoice in Sage, along with LC - even though you stated ""without merging""?

The multiple invoices are for each product line being provided by their supplier in Italy. Currently they are entering the multiple invoices all as one invoice to get around the issue. The problem is the supplier from Italy is a related party and they are having to reconcile the individual outstanding invoices at the end of the month. The multiple invoice numbers are being noted as best as possible in the 20 character field for the invoice number but not very well. I was looking for alternatives to ease their overall process. Italy office is huge and unlikely to change.

How about just recording the combined landed cost in ROG and recording the invoice separately. You're allowed multiple invoices per P/O in ROI. You could then change the posting accounts for the landed costs to a clearing account. When recording the individual invoices, the landed cost portion could be a misc charge to the same clearing account.