Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

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 Excel – Release 6.4 will now include the debtor memo when output to Excel as the final column on the report.

Also introduced in Release 6.2 was the facility to record notes against the sales and purchase transactions, Release 6.4 includes the facility to include these notes when outputting the transaction detail on the Aged Analysis report to Excel.


If Excel Output, Include Tx Notes – if transaction notes configured then selecting this option when printing the report to Excel adds the transaction notes on the Excel row of the transaction. Transaction Notes are not included on the printed output.

Include Debtor Memo Text – if set then will include the memo when output the report to Excel in addition to the printed outputs. On the Excel Output the Debtor memo text is output after the Unallocated column (sharing the first transaction notes column if output).


Installation

No additional configuration over and above configuration to record transaction notes and to include the Debtor Memo on the printed report is required. For more details on these options please review the 6.2 Supplement.

Custom Fields
  • Release ID: 6.4
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Reporting Defaults
Viewed 1972 times since Wed, Jun 13, 2012
Extra Features in Purchase Invoice Transaction Lookup
Viewed 3130 times since Tue, Jun 12, 2012
Set Auto Expand Data Files
Viewed 1568 times since Mon, Jul 2, 2012
Unallocating Transactions in Earlier Periods
Viewed 1765 times since Wed, May 29, 2019
Enter Invoices
Viewed 2647 times since Mon, Jul 2, 2012
Account Authority Levels
Viewed 2533 times since Tue, Jun 12, 2012
Include Debtor Memo on Aged Analysis Report
Viewed 2294 times since Tue, Jun 12, 2012
Currency Options
Viewed 1522 times since Mon, Jul 2, 2012
Account Optional 1 - Database Profiles
Viewed 1940 times since Mon, Jul 2, 2012
Sales/Purchase Accounts File – Item Screen Design
Viewed 1250 times since Mon, Jul 2, 2012