no decimal places at all.
rchikka
Member Posts: 23
Hi All,
We have come across for one of our customer, where , in their country the govt wont allow decimal places at all. We can achieve this by using autoformat type and expr and also in gen.ledger setup ( amount decimal places and unit amount decimal places ) we may control to display the same on the form level.
However we do need to control the same through out the system. ( effectively to say.. that no decimal place at all in database)..
can it be achieved ? if so kindly help us.
Regards,
Rchikka.
We have come across for one of our customer, where , in their country the govt wont allow decimal places at all. We can achieve this by using autoformat type and expr and also in gen.ledger setup ( amount decimal places and unit amount decimal places ) we may control to display the same on the form level.
However we do need to control the same through out the system. ( effectively to say.. that no decimal place at all in database)..
can it be achieved ? if so kindly help us.
Regards,
Rchikka.
0
Comments
-
No, that can't be achieved without thourougly redesigning NAV with integers everywhere there are decimals.
Even the setup you did now, will store the numbers with decimal places (but they will all be 0).
I would not recommend to do this because
1: You'll destroy alot of functionality (like item charge assignment, unit of measure (selling 1,5 KG of bulkitem won't be possible))
2: The entire db without decimals is not allowed? Very hard to believe. I think the government of that region would like no decimal places in the money, but items, resources, and other areas are or should of no concern to them.0 -
Thanks Mr. Sog for the reply..
Actually i had put it the wrong way..
yes .. you are right. only the amount fields need to be rounded off and no decimal values should be allowed. Can this be achieved ?.
sorry for the confustion caused.
Regards,
Kalyan.0 -
rhpnt wrote:
Is this really so difficult. I may be wrong but it seems that "Amount Rounding Precision" value "1" will suffice the requirement.CA Sandeep Singla
http://ssdynamics.co.in0 -
In reality it's not, but we don't really know what this guy wants so...0
-
Thanks all.0
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
- 328 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