Additional Notes on Transactions


Datafile Software

Additional Notes on Transactions

This new features allows for additional commentary to be recorded against a transaction after the transaction has been generated. This allows you to record, for example, additional notes against an overdue invoice with detail as to any reason for delay in payment.

The Notes can be added via the Account Enquiry, the Ledger Enquiry or Allocation Actions within the Sales or Purchase Ledger.

Account Enquiry – within the Account Enquiry when highlighting a transaction you can use the Notes button or the <F7-Option> key to add/update/view any note entries recorded against the transaction. If any existing notes are recorded the status line shows details from the first line of notes.


Ledger Enquiry – within the Ledger Enquiry when highlighting a transaction you can use the Notes button to add/update/view any note entries recorded against the transaction. Again if any existing notes are recorded the status line shows details from the first line of notes.


Allocation Actions – within the Allocation Action options when a transaction is highlighted the <F7-Option> key can be used to add/update/view any note entries recorded against the transaction. Again if any existing notes the status line shows details from the first line.

 Notes

 The Statement parameters contain a pre-existing option to print up to ten items from the transaction record as additional lines below the statement detail line. This feature could be used to print the notes on an internal statement.

Installation

Database Changes

New data items are required on the sales/purchase transaction file to record the additional notes. You can update the database layout by selecting Installation off the main menu followed by Application Manager and then Restructure a Database.

Select the application, elect to change the ‘Live’ files, and then select the transactions file.<Page-Down> until you reach a range of blank items and then press <Enter> against a blank entry to create the item(s) below.

Item Name Type Description

NOTES X (64) Holds first line of notes.

NOTES-N X (64) Holds the nth line of notes (maximum of 10 lines). All data items must be consecutive within the file.

Enter the item name in the first input and then press <Enter> to set the item type (F4 is available), enter the size required and press <Enter> to complete the entry.


Once the database changes have been made press <ESC> to complete and then choose UPDATE to update the changes. Press <Enter> to confirm prompts to ‘Extract Existing Data to the new Database Structure’ and (if appropriate) ‘Copy Table entries from Old Database to New Database’ - the new database structure is then updated. When prompted to ‘Remove .OLD Database’ you generally respond ‘No’ for backup purposes.

If prompted to ‘Carry Out the Same Restructure on the "BASE” File as well?’ respond as required.The BASE file is used if/when you create a new company based on the existing structure, if this is likely to happen respond ‘Yes’ and repeat the entry of new items above taking care to ensure you create at the same item positions and with the same type.

Set Database Profiles

The new data items need to be referenced within the Datafile Database Profiles. The profiles are set by selecting Installation from the main menu followed by Application Manager and then Set Database Profiles. Select the required application and then select the parameter screen Transaction Optional 3 to reference the new items.


Against the prompts on the left for Notes: First and Notes: Last reference the range of new data items added (<F4-Select> is available if required).


Custom Fields

Article ID: 179
Created On: Tue, Jun 12, 2012 at 10:18 AM
Last Updated On: Mon, Jun 19, 2023 at 4:30 PM

Online URL: https://kb.datafile.co.uk/article/additional-notes-on-transactions-179.html