Rounding Off Problem
sujatharaoo
Member Posts: 57
Hi,
We have customised the tables as branch transfer header,branch transfer Line table. The Line amount field in the Branch transfer Line table is used as the flow field in the Header table as Total value.
The header Flowfield is showing the value as eg: 69617.13 but when the Line amount calculated manually in the Branch Transfer Line the value is 69317.14. Please Suggest me to resolve this issue?
Thanx in Advance
We have customised the tables as branch transfer header,branch transfer Line table. The Line amount field in the Branch transfer Line table is used as the flow field in the Header table as Total value.
The header Flowfield is showing the value as eg: 69617.13 but when the Line amount calculated manually in the Branch Transfer Line the value is 69317.14. Please Suggest me to resolve this issue?
Thanx in Advance
Regards,
Sujatha.N
Sujatha.N
0
Comments
-
Since it is customised can't give you a full answer. But it looks like one field is showing Value to just 2 decimal places and its true value could be 69617.1377 and then again in the header it is rounding it up so that the line now equals 69617.1400.
That would be the first place i looked.0 -
The rounding off precision has been fixed as 0.01 for both header and line values.Regards,
Sujatha.N0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 333 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