Multi currencies PO vs Purchased Invoice entry

Hello,

We have Purchase Orders submitted in one currency (ex: EURO), but the invoice itself has a different currency (ex: USD).

Is the following scenario supported in LN cloudsuite?

1. Enter the PO in the original currency as provided by the BP price quote - in EURO

2. Receive the goods when applicable.

3. Register a new Purchase Invoice against the receipt.

Set the currency to USD.

Provide the exchange rate for the invoice date (EUR-USD).

LN sets the Invoice Amount to USD by multiplying the exchange rate - both in the header and line levels.

From what we see, the only option is to manually override the prices in all the lines with the correct USD price.

Thanks.

Find more posts tagged with

Hello,

Can you share what version you are on?

Can you help us understand the use case for purchasing in EUR and entering the Purchase Invoice in USD?

I do know the system has multiple currency options for reporting like transaction, reporting, and reference.

Hi. Thanks.

We are on 2024.01.00 (20231110-083600, 20231110-083237, 851, 1341)

Basically, what we need is as follows:

1. Our Suppliers sends us a price quote in USD, and we create the PO with the prices listed in the quote.

2, The commercial agreement with the supplier is that he will actually bill us in EUR (our local currency) and the rate date

of the USD/EUR will be taken from the invoice date.

So, for ex:

We have a PO line with: Qty: 1, Price: 1000 USD on Jan 4th. Total in PO is 1000 USD.

The purchase Invoice will be received on Feb 4th with USD/EUR rate 1.145.

So, line: Qty: 1, Price: 1000 USD and the total of the Invoice will be 877 EUR.

What we expected from LN to do:

Automatically update the Invoice Amount to the EUR amount based on the invoice date currency.

What actually is happening:

We need to manually change the amount in each of the Invoice lines with the correct EUR amount but overriding the matched price coming from the PO.

So, what we get is identical to the PO and not converted into EUR as we expected.

I hope this is clearer. Thanks in advance!