Donot want to round the Unit Price Excl. VAT

hungryandfool
Member Posts: 114
Dear Experts,
The The Line amount Excl. VAT field is getting rounded off to two decimal places in my sales order when the price is getting picked up from price master. I donot want the rounding to happen.
Eg. 13.5618 is getting rounded off to 13.56, whereas I want it as 13.5618.
Please help me with the same
The The Line amount Excl. VAT field is getting rounded off to two decimal places in my sales order when the price is getting picked up from price master. I donot want the rounding to happen.
Eg. 13.5618 is getting rounded off to 13.56, whereas I want it as 13.5618.
Please help me with the same
0
Comments
-
Hi,
The field has the amount rounding property (see AutoFormatType). Therefore it will show as if it's been rounded, even if it's not. But all logic in NAV regarding document lines will (or should) use the amount rounding precision. This is set up in the G/L Setup and in every currency code.
The best way to work around this would be to set a different amount rounding precision, but this affects all amount fields in NAV. The other way would be to change the handling of the amount fields in documents, but I wouldn't recommend it.
with best regards
Jens0
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