Home » Categories » Solutions by Business Process » Finance » Job Costing

Additional Lookups for Maintain Jobs

The Job maintenance screens within Job Costing allowed the facility of one lookup database, from this release this has now been increased to three lookup databases.

Installation

Application User Facilities

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

Installer users can right click on the Job Costing Maintain Jobs menu option and select to Configure Option. Alternatively select Installation from the main menu followed by Application Manager and then Application User Facilities, select the Job Costing application followed by Maintain Job File.


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 JOB file which allows the <F4-Select> function when adding/amending jobs. 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 JOB database to be updated.

 

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

 

 

 

 

 



Custom Fields
  • Release ID: 7.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Expand Data Files
Viewed 1481 times since Mon, Jun 25, 2012
Choosing the Right Company
Viewed 1580 times since Mon, Jun 25, 2012
Time Sheet Entry
Viewed 1558 times since Mon, Jun 25, 2012
Job Costing System Profiles (3/3) – Link to Which Payrolls
Viewed 1103 times since Mon, Jun 25, 2012
Transaction Control Numbers
Viewed 1559 times since Mon, Jun 25, 2012
Update to Payroll
Viewed 1534 times since Mon, Jun 25, 2012
Sales Invoice Details
Viewed 2265 times since Mon, Jun 25, 2012
Allow Job Code Input to be Dependent on Order Status
Viewed 2468 times since Wed, Jun 13, 2012
Stock Issues Header
Viewed 1518 times since Mon, Jun 25, 2012
Ledger Enquiry
Viewed 1565 times since Mon, Jun 25, 2012