1. Aged Analysis - Debtor Memo and Transaction Notes to Excel Datafile Software Aged Analysis - Debtor Memo and Transaction Notes to Excel Release 6.2 introduced the facility to include the debtor memo when printing the Aged Analysis report but didn’t include this text when outputting the memo to Exc... Read More
2. Ledger Enquiry Hyperlinks on Application Report Output to Excel Datafile Software Ledger Enquiry Hyperlinks on Application Report Output to Excel One of the more popular features introduced in Release 6.1 was the facility to send an application report to screen or spooler and include ‘hyperlinks’... Read More
3. Output to Microsoft Excel 2007 Datafile Software Output to Microsoft Excel 2007 Microsoft Excel 2003 has limits on the number of rows and columns that can be displayed within a spreadsheet which was increased for Excel 2007. By default when outputting to Excel from Datafile, ... Read More
4. User-Defined Reports - Update Excel Spreadsheet from Accumulators Datafile Software User-Defined Reports - Update Excel Spreadsheet from Accumulators Existing Excel output procedures, both in general applications and within ProFiler itself, create a new spreadsheet each time. This new feature allows the facili... Read More
5. Output to Excel Pivot Table Datafile Software Output to Excel Pivot Table One of the more useful tools within Excel is the Pivot Table utility. The pivot table is a data summarization tool and among other functions, they can automatically sort, count, and total the data st... Read More
6. User Defined Report – Output to Excel Datafile Software User Defined Report – Output to Excel Last year we added options to the standard listings, in ProFiler as well as the applications, to output a report to Microsoft Excel. This option has now been added to a ProFiler User-Defi... Read More
7. Output User List to Excel Datafile Software Output User List to Excel When defining users and their configuration settings for access to Datafile within the MASTER sign-on it can be useful to print the existing user list for review. From the user list the <F7-Option> k... Read More
8. Datafile RTD Excel Add-In Datafile Software Solutions Datafile RTD Excel Add-In The Datafile system as standard allows reports to be sent to Microsoft Excel as part of the print process. Once the report is in Microsoft Excel however the data is static so when balances... Read More