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

Select Key Definition

Datafile Software

Select Key Definition

Whenever you press <F4-Select> against an application database within the sales or purchase ledger the details displayed can be configured to show what you require.This is done via the ‘Select Key Definition’.

As you select this option the system displays each of the ‘system’ databases used within the application in turn asking you to select the items, up to ten, that you wish to display.You are also asked:

LIFO Sequence

The details listed when using <F4-Select> depend on the item searched upon. If search on the prime-index (which for the customer/supplier file would be the account code) then items are listed in account code order, if enter a search on a secondary index (for the customer/supplier file this could be the account name) then items are listed in the order they were created. Setting this option reverses this sequence so that details are listed in either reverse prime-index or reverse entry order.

Auto-Sort Column
Auto-Sort Descending

As an alternative to the above you could set the records to be listed in a set sequence. This could include, in the case of the customer file, the customer account code or balance. The item you sort on must be one of the list items you have set to be displayed and, here you select the column number of the data item you wish to sort upon and whether the records are to be sorted in descending order (leave blank for ascending order).

Notes

These items only affect the items displayed in the list when selected within the ledger; they do not affect the items you can filter on (i.e. the header selection inputs). These are the prime and secondary indexes of the databases concerned.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Record Statement Dates on Account (S/L Only)
Viewed 2172 times since Wed, Jun 13, 2012
OTHER – Extra Maintenance Screens
Viewed 1366 times since Mon, Jul 2, 2012
Include Currency Accounts in Auto-Payment Procedures
Viewed 1902 times since Fri, May 27, 2016
Cheque Printing (Purchase Ledger) - Application User Facilities
Viewed 2450 times since Mon, Jul 2, 2012
Aged Analysis - Debtor Memo and Transaction Notes to Excel
Viewed 12145 times since Fri, Jun 8, 2012
Discount and Supplier Matrix Prevent Sale of Items to Selected Customers
Viewed 3153 times since Fri, May 20, 2016
Account Turnover - Database Profiles
Viewed 2577 times since Mon, Jul 2, 2012
Moving, Deleting and Amending Items - Document Design Manager
Viewed 2515 times since Mon, Jul 2, 2012
Transfer Outstanding Invoices
Viewed 2036 times since Mon, Jul 2, 2012
Recall Standard Text
Viewed 2509 times since Mon, Jul 2, 2012