Number format for Account Schedules

Skolnick
Member Posts: 31
I am building financial statements for a new company using Dynamics NAV 4.0 SP1. I want the rounding to go to cents (0,000.00). Currently the setting goes to dollars (0,000).
How do I change the number format for statements in Financial Management>Analysis and Reporting>Account Schedules?
Thank you!
How do I change the number format for statements in Financial Management>Analysis and Reporting>Account Schedules?
Thank you!
Making the world a better place one pixel at a time!
0
Comments
-
Hello,
in the Functions/Set Up Column Layouts you can find a field "Rounding"- you can set different rounding policy for each column - set this field to "None" if you don't want any rounding.
Regards.0 -
Oops! I stated "rounding" but I should have said "How do I set the decimal places to two?"
Thanks!!Making the world a better place one pixel at a time!0 -
Unfortunately it is not designed to control such a precision.... and i think it will never be - quite natural is to present financial statements in thousands (standard currencies like USD, EUR) almost everywhere so...0
-
However, if you set the rounding yo "None" it will take the standard precision you use (it is a general setting) for the company and it is problably 0,01 so you will have the statement rounded to cent without doing any special settings.0
-
I had to go into the General Ledger Setup table to get the changes in but now I have pennies on my statements!
Thanks for you help in this matter!!Making the world a better place one pixel at a time!0
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