Currency for Quates and Currency for Sales Order

cbasilis
Member Posts: 18
Hi, I have a question about a process that have one of our customer. The made sales quotes with EUR as a Currency, but when they convert the sales quotes to Sale order, they change the currency code to USD, but the LC is DOP. We setup the currency exchange to USD to DOP, EUR to DOP.
The problem and is very logic, when the user change the currency from the Sale Order EUR to USD, the user have to insert again the sales price. How can I solve this problem or I have to do some customization?
Thank you for the help
The problem and is very logic, when the user change the currency from the Sale Order EUR to USD, the user have to insert again the sales price. How can I solve this problem or I have to do some customization?
Thank you for the help
0
Comments
-
Why do user have to insert the sales price? I didn't understand this part. Doesn't NAV calculate Sales Price when you change Currency Code?Ufuk Asci
Pargesoft0 -
If there are not sales prices setup for the currency then the user would need to re-enter the sales prices. This is because when you change the currency, the system will recalculate the sales price as if the user was entering the lines. So if there are no sales prices created for that currency, it will set the price to zero.Gerry Kistler
KCP Consultores0 -
gerrykistler wrote:If there are not sales prices setup for the currency then the user would need to re-enter the sales prices. This is because when you change the currency, the system will recalculate the sales price as if the user was entering the lines. So if there are no sales prices created for that currency, it will set the price to zero.
I am not sure if I understood correctly but I want to clarify what I meant:
One sales price is enough for NAV to convert Unit Price between currencies. If there isn't any sales price then Unit Price is removed upon Currency Code validation on Sales Header. But cbasilis said inserting Sales Price and I suppose Sales Price is used.
If you do not use Sales Price and want to keep initial Unit Price then yes, you have to do some customization. I've done this before and it is quite easy to do this modification.Ufuk Asci
Pargesoft0 -
Hi,
The user insert the Sales price in the sales Quote with the currency EUR, this if because the customer sent the sales quotes to the Headquarter in France, but they sales order have to be invoice in USD. The problem is, that the local Currency is DOP (Dominican pesos), we have the exchange rate from EUR to DOP and USD to DOP, but no EUR to USD.
When they change the currency code on the Sales Order from EUR to USD, the price change to blank.
Thank for the help0 -
Have you tried first changing from EUR to DOP and then from DOP to USD?
Otherwise try with an Exchange rate for USD from EURGerry Kistler
KCP Consultores0 -
Do you use Sales Price functionality or not?
If you use sales price (not entering a value in Unit Price) then defining a Sales Price in EUR will be enough. You can change currency to LCY or any other currency. NAV will calculate value in other currencies. You do not require to enter it in USD or LCY (if the price is not relative to currency) and you do not require a conversion rate between FCY.
IF you do not use Sales Price, customization is required.Ufuk Asci
Pargesoft0 -
They use the sales price in USD not in EUR, I was thinking create two sales price one for sales quotes and the other one for the sales invoice...Or made some customization.0
-
No modification is needed. Just create prices in EUR and USDGerry Kistler
KCP Consultores0 -
Thank you everybody for the help...I will suggest that create sales prices in USD and EUR.
Gracias!
Carlos0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions