Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

WRONG ENTRY OF CURRENCY UPON SALES RETURN ORDER

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

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 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

  • keoma Profile Picture
    keoma 32,675 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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans