web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

WRONG ENTRY OF CURRENCY UPON SALES RETURN ORDER

(0) ShareShare
ReportReport
Posted on by 160

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

I have the same question (0)
  • keoma Profile Picture
    32,729 on at
    RE: WRONG ENTRY OF CURRENCY UPON SALES RETURN ORDER

    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.

  • Verified answer
    Jens Glathe Profile Picture
    6,092 on at
    RE: WRONG ENTRY OF CURRENCY UPON SALES RETURN ORDER

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#3
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans