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
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
- 323 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