Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Additional Lookup Databases for Account Maintenance

The Nominal account maintenance screen within Nominal Ledger and Cashbook allowed the facility of one lookup database, this has now been increased to three lookup databases.

Installation

Application User Facilities

New parameters have been added to the screen design within the Nominal Ledger Application User Facilities to allow definition of three lookup databases.

Premier Installer users can right click on the Nominal Ledger Maintain Accounts menu option and select to Configure Optionand then Maintain Screen.Alternatively, select Installation from the main menu followed byApplication Manager and then Application User Facilities. Select the Nominal Ledger application followed by Maintain Chart of Accounts and Maintain Screen.


To update the lookup definition(s) select the Look Up option on the Design tab. Each lookup definition is prompted in turn and for each lookup you are prompted for:


 

Database pathname– enter the file pathname for the DFD to look-up to.

Lookup format – enter the prime-index format for the lookup DFD.

Item for Lookup – reference the item on the NLA file which allows the <F4-Select> function when adding/amending nominal accounts. You can nominate up to ten separate items on the file to lookup from to the same database, but any defined copy items are only actioned for the first lookup item.


TableDescription automatically generated with medium confidenceItems to List when Selecting – enter up to five items from the lookup database to be listed when press F4 to search for a lookup value.

The size shown will default to that of the data item size. You can reduce this if required.

Set to LIFO to list the search results in reverse order (latest first) when searching on a secondary index.


 




TableDescription automatically generatedItems to Copy from Lookup – reference the data item on the lookup database to be copied and set the matching data item on the NLA database to be updated.

Data items selection should be of a matching type / size.







Note

Lookup definitions are shared between the Nominal and Cashbook Account Maintenance Screens.


 


Custom Fields
  • Release ID: 7.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Financial Summaries – Account Selection Display
Viewed 992 times since Wed, Jun 13, 2012
Set Current Period - Cashbook
Viewed 1864 times since Wed, Jun 27, 2012
Alternate ‘Reference’ Label for Receipt / Payment Entry
Viewed 152 times since Thu, Jan 2, 2025
ENTER – Enter Current Budget Year Totals - Nominal
Viewed 1039 times since Wed, Jun 27, 2012
Transactional Optional 1 - Nominal - Database Profiles
Viewed 1687 times since Thu, Jun 28, 2012
System Profiles Screen 1 - Nominal
Viewed 1861 times since Wed, Jun 27, 2012
Report Account Status - Nominal
Viewed 1640 times since Wed, Jun 27, 2012
Allow Automatic Reversal of Provisional Journals
Viewed 565 times since Thu, Oct 17, 2024
Cash Book Listings - Cashbook
Viewed 2011 times since Thu, Jun 28, 2012
Multiple Updating - Update From Another Nominal - Nominal
Viewed 1918 times since Thu, Jun 28, 2012