WRONG ENTRY OF CURRENCY UPON SALES RETURN ORDER

Hi Guys,

Good day. Can you help me on this issue below?

Given:

Vendor A as EURO foreign trade currency.

Customer A as EURO foreign trade currency.

ITEM A - Qty: 1 at Cost =100 EURO, SRP = 150 EURO

Charge A - Qty 1 at Cost =10 EURO, SRP = 15 EURO

Exchange Rate: 1 EURO = 5 AED

Posted Transactions:

  1. Purchase Shipment - Vendor A for ITEM A with 1 qty at 100 EURO

  2. Purchase Invoice - PI-140001

a. Vendor A for ITEM A with 1 qty at 100 EURO

b. Vendor A for Charge A with 1 qty at 10 EURO

  1. Sales Shipment - Customer A for ITEM A with 1 qty at 100 EURO

  2. Sales Invoice - SI-140001

a. Customer A for ITEM A with 1 qty at 150 EURO

b. Customer A for Charge A with 1 qty at 15 EURO

The user wants to remove the charge item A in posted purchase invoice and posted sales invoice. The user created a sales return order and selected Get Posted Lines to Reverse function and selected SI-140001 but the currency of the posted sales return order is wrong (AED). It should be in EURO as well. The system did not capture the currency of the posted sales invoice but captures the default currency of the customer card since its defined in the customer to have no default currency value.

Unaware of the wrong currency posted at sales return order, the user created a purchase return order reversing the posted purchase invoice PI-140001 but error came out (see attached)

8308.Untitled.png

Can you explain why this error came out and what it’s cause? Is it the wrong posted sales return order currency? Also, the posted sales return order amount is converted to local currency (AED). Instead of 165 EURO, the system reflected AED 825 (1 EURO=5AED). Now, I need to correct the wrong posted sales return order. Can you help?

The purpose of the reversal of purchase and sales invoice is to remove the charge item which was reflected on the posted transactions and create a new purchase and sales invoice.

Please help.