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
3. Sales Shipment - Customer A for ITEM A with 1 qty at 100 EURO
4. 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 :
"One or more returned document lines were not copied. This is because quantities on the posted document line are already fully or partially applied, so the Exact Costing Reversing link could not be created."
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.
*This post is locked for comments
Hi Angelito,
IMO the error message comes from a setup flag: you have set up "exact cost reversing" on sales credit memos. This flag should be on the sales setup page. From what I suspect it is an issue with the item charges... but I'm not sure. If you can set up a copy of your database for testing, I would recommend to remove this flag and try the copy again. You can also enter the item charge line manually, of course. The copy itself sets the credit memo up for cancellation.
with best regards
Jens
hi,
your client should set the currency code in the sales return order also to EUR. then the posted sales return order has the correct currency.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156