PO Multi-currency question

Posted by: Steve Schwartz

PO Multi-currency question - 03/19/24 10:01 AM

The simple case - a client receives inventory from a supplier and freight from another vendor. Since the freight is to be prorated to the cost of the inventory, the inventory and freight are both entered, each to their respective vendor, on the same PO and received together.

A complication - the client is implementing WMS by Lenmax, and WMS can't handle multiple vendors on the same PO. The workaround is to enter the freight using the supplier vendor, and then when the invoice is day-ended and sent to AP, to modify the invoice batch, moving the freight charge from the supplier vendor to the freight vendor (as a new invoice).

The stumper - the supplier charges and freight charges are in different currencies. We are looking for a better workaround than doing the freight conversion manually and continuing as above. Not only is this error-prone, but if the currency rates change from the time the PO is issued to the time the invoice is received, the figures will be incorrect.

Does anyone have an answer for this situation?

Thanks

Steve
Posted by: Douglas Dickie

Re: PO Multi-currency question - 03/19/24 11:59 AM

Steve:

WMS uses PO's Receipt import process, which cannot manage multiple vendors.

So unfortunately, after spending some time looking for a solution to this problem the only solution I could come up with is to manually process the PO receipts.