Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook |
Column Headings for Financial Summaries Spreadsheet Output |
Article Number: 1908 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 6:24 PM
|
Datafile Software Column Headings for Financial Summaries Spreadsheet Output When you output a ‘full-mode’ financial summary to
Excel/OpenOffice the system uses the balance item as the column heading. However, for special balance items 99, 100
and 101 the system uses a generic ‘User’ title as the column heading. New in Release 6.6 is the option to record a
title to use for the column heading on spreadsheet output. To set the title to be used you need to update the Financial Summary Definition. Select the Nominal Ledger option from your main menu followed by Financial Summaries and then press the <F7-Option> key to open the summary designer. Select the full-mode summary to update and then select the Parameters option from the main toolbar when the summary is displayed. When you set/confirm balance item of 99/100/101 a
pop-up is displayed asking for additional parameters and this pop-up includes
the prompt ‘Col Heading for Excel’ which can be set as required. |
Attachments
There are no attachments for this article.
|
VAT Form 100 - Cashbook
Viewed 1721 times since Wed, Jun 27, 2012
Account Maintenance Improvements
Viewed 1287 times since Fri, Jun 8, 2012
Recall Standard Text - Cashbook
Viewed 1308 times since Thu, Jun 28, 2012
Maintain Cash Book Accounts - Cashbook
Viewed 1312 times since Thu, Jun 28, 2012
Bank Reconciliation - Cashbook
Viewed 1258 times since Wed, Jun 27, 2012
Expand Data Files - Cashbook
Viewed 1147 times since Thu, Jun 28, 2012
Information Only Accounts
Viewed 1421 times since Tue, Jun 12, 2012
VAT Form 100 - Group VAT Registration
Viewed 3344 times since Tue, Oct 9, 2018
Transaction / Detail Enquiries - Nominal
Viewed 1318 times since Wed, Jun 27, 2012
Standard Update – Sales and Purchase Ledgers - Nominal
Viewed 1047 times since Thu, Jun 28, 2012
|