Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 297 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Show zero in Account Schedule
kelseykong@hotmail.com
Member Posts: 86
Dear experts,
When generating financial reports using account schedule, we select the "if any column not zero" as the Show option.
For one account, there is no entries posted during the current month. however, since the year to date data is available, the account is shown on the report. On the amount for current month, instead of zero, it shows a blank field.
May I know if it is possible to show zero in all the blank field?
Thank you.
Li
When generating financial reports using account schedule, we select the "if any column not zero" as the Show option.
For one account, there is no entries posted during the current month. however, since the year to date data is available, the account is shown on the report. On the amount for current month, instead of zero, it shows a blank field.
May I know if it is possible to show zero in all the blank field?
Thank you.
Li
0
Comments
you can change the BlankZero property of the field.
with best regards
Jens
I found Blankzero is to show blank field when the amount is zero.
My case is, there are blank fields and my client doesnt want to see those blank fields(since other columns do have value, the row is shown on the report), and they would like to show zero if no value is posted to the account.
Thank you.
Li