Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
A/R and A/P Aging Reports - RTC Print To Excel
JDVyska
Member Posts: 179
Just thought I'd share this strangeness, since I checked here first and found nothing.
The base US NAVNA6.00 Aged Accounts Receiveable (10040) and Aged Accounts Payables (10085) both have a peculiarity when using the Print to Excel option in the RTC: The Report Totals print. Unlike in Classic, where things error out, and nothing prints/previews, in the RTC version, you get the header/footer combo.
This means that users, to avoid wasting paper, have to make sure they use Preview instead of Print, and then close a not-helpful Report Preview.
I presume such will hold true on the various other Print To Excel reports. Training users to not use that, and instead, to use Save as Excel is not an option in this case, as the Save to Excel is all sorts of formatted, whereas the Print to Excel via the ExcelBuffer is nice and raw data style for easy workbook magic.
</share>
The base US NAVNA6.00 Aged Accounts Receiveable (10040) and Aged Accounts Payables (10085) both have a peculiarity when using the Print to Excel option in the RTC: The Report Totals print. Unlike in Classic, where things error out, and nothing prints/previews, in the RTC version, you get the header/footer combo.
This means that users, to avoid wasting paper, have to make sure they use Preview instead of Print, and then close a not-helpful Report Preview.
I presume such will hold true on the various other Print To Excel reports. Training users to not use that, and instead, to use Save as Excel is not an option in this case, as the Save to Excel is all sorts of formatted, whereas the Print to Excel via the ExcelBuffer is nice and raw data style for easy workbook magic.
</share>
JEREMY VYSKA
CEO, Spare Brained Ideas, Göteborg, Sweden
New (April 2021) Getting Started with Microsoft Dynamics 365 Business Central Book Available: "Your First 20 Hours with Business Central"
CEO, Spare Brained Ideas, Göteborg, Sweden
New (April 2021) Getting Started with Microsoft Dynamics 365 Business Central Book Available: "Your First 20 Hours with Business Central"
0