Navigation:  Advanced Accounting Overview >

Lookup Lists

Print this Topic Previous pageReturn to chapter overviewNext page

 

When you press the appropriate key (generally F2) or click on the appropriate button for a lookup list something similar to the following will be displayed:

All lookup lists start with the same screen, however, some of the buttons may not be active depending on the options available.  In most cases, only the Select, Exit and Navigator buttons will be active.  The screen above is the lookup for customer codes.  Below the buttons and above the grid are two fields.  The first is the FastSearch (tm) field that allows you to enter characters that match what you're looking for.  As you enter the characters the grid below will search for the nearest match and will place the selection bar on that record.  When you've found the record you want, press the ENTER key and the lookup list will disappear and you'll be returned to the calling program.  While the cursor is in the FastSearch field you can also use the UP and DOWN ARROW keys to move up or down the grid, and the HOME and END keys to move to the beginning or end of the list.

 

Also above the grid is the Index List field.  By clicking on the down arrow you will get a list of the indexes that are available for this lookup.  Choose a different index and the field that matches that index will be moved to the first row and the grid will be redisplayed in that new order.  The FastSearch field will now allow you to search using that new index.

 

If you don't want to choose a record you can either press the ESC key or click on the Exit button.  In both cases the lookup list will disappear and you'll return to the calling program without choosing a record.

 

In some cases the Edit, Add New and Delete buttons will also be active.  If they are you can choose to add a new record, edit an existing record or delete an existing record by clicking on the appropriate button.  You can also press the F3 key to edit, the INS key to add a new record and the DEL key to delete a record.  In most cases the edit and add new routines will call a different screen where you will be able to edit or ad a new record.  If you choose to delete a record a dialog box will be displayed asking you to confirm your action.

 

 

       WBKLUGRID

 

All of the lookup lists in Advanced Accounting 7 are based on data in the file BKLUGRID.  This is a CodeBase file that keeps track of the fields you want to display, the indexes for the lookup and a few other pieces of information.  The program to manipulate the information is WBKLUGRID.RWN and is part of Advanced Accounting 7.  To execute the program use the UT-A - Run a TAS Program option and enter the program name; WBKLUGRID and press ENTER.  The screen below will be displayed:

 

 

To get a list of grids available click on the down arrow in the Grid Name field. 

 

A full list of all of the different grid names follows at the end of this section. 

 

Choose the grid you wish to work with and press the ENTER key.  A dialog box asking if you wish to "Create a new copy?" will be displayed.  Press the ENTER key (choose No) or click on the No button.

 

In the example above we've chosen the BKARCUST_LOOKUP and the cursor is now in the FD Name field.  This is the general lookup for customers and is used through out Advanced Accounting 7. 

 

Press the ENTER key again through the FD Name field and the Form Name field. 

 

Unless and until you become very comfortable with changing or creating new lookups using this process you shouldn't change the FD Name or Form Name fields at all.

 

Next comes the Start At End check box.  If this is checked the lookup list will start with the last record in the file.  If it's not check it will start with the first record.

 

The first grid is the Field Data.  These make up the columns in the lookup list.  At the beginning of this section was a sample of a lookup list.  In fact, this is the customer lookup list that matches the BKLUGRID data displayed above.  If you compare the fields in the Field Data grid to the fields in the lookup list you'll see that the headers in the lookup list are identical to those in the Field Data grid above.  Even though you can't see it, if you scrolled to the right in the lookup list the Phone Number field would be there at the end of each record.

 

Perhaps it's more important for you to have the contact and telephone number before the Active, State and Zip Code fields.  To change this all you have to do is move the grid rows so they match what you want.  To move a grid row click on the grey box in the first column for the appropriate row.

 

As the example above shows, as you start to move the mouse (holding the left mouse button down) the cursor will show a box in the tail of the cursor.  There's also a green line that will be displayed and will move with the mouse as you move it up or down.

 

Move the mouse up until the green line is immediately below the Active? line.  Release the left mouse button and the example above will be displayed.  Now do the same with the Phone Number, again moving the mouse until the green line is just before the Active? line since you want to place the Phone Number after the Contact, not before.

 

Now click on the Save button and Exit to leave the program, run AR-A - Enter/Change Customers and press the F2 key to display the lookup list.  If you saved the information properly you should see something like this:

Notice how now the Contact and Phone Number (off to the right side) are displayed first.  You've made no changes in any programming and yet, every customer lookup throughout Advanced Accounting 7 has been changed to reflect these new requirements.

 

To change the lookup back, just reverse the actions above, move the lines down instead of up and save the record back.

 

The last grid on the screen is the Key Data.  This works exactly like the Field Data except that it controls which index is the default and what the titles are for the indexes.  If you want to start with the Customer Name instead of Code as the index just move the Name row so that it's the first row in the grid, save the record, and, the next time you lookup customers, the program will start in Name order.

 

If you change the default index value you must also change the first field in the Field Data grid to match.  The lookup list will not change the column order on start up.  Only when an index is chosen after the lookup list is displayed.

 

Don't be afraid to experiment with this.  You can even add and delete fields from the lookup list, change column headings, etc.  And, if you really screw it up, just replace 3 fields BKLUGRID.DBF, BKLUGRID.MDX and BKLUGRID.DBT.  Those three fields contain all of the lookup list information.

 

 

       Lookup List Names

The following is a list of the records in BKLUGRID and what each one does:

 

AUDIT_TRAILPOS Audit file
BKAPM_DSP_INVLA/P Recurring Vouchers
BKAPO_DSP_CHKSA/P Posted Checks
BKAPVEND_LOOKUPVendors
BKARB_DSP_INVVA/R Vouchers
BKARCUST_LOOKUPCustomers
BKARHINV2_LKUPA/R Invoice lookup in SO-K.
BKARHINV_LOOKUPA/R invoice history
BKBMF_DISP_HISTBOM history
BKGLC_DSP_TRANUnposted General Journal Transactions        
BKGLM_DSP_TRANGeneral Journal Recurring Transactions
BKICA_LIST_INVInvoices for a specific Inventory item
BKICA_LIST_MFRSuppliers for a specific Inventory item
BKICA_LIST_POOpen Purchase Orders for a specific Inventory item
BKICA_LIST_PORReceived P/Os for a specific Inventory item
BKICA_LIST_SOOpen Sales Orders for a specific Inventory item
BKICA_PLOCLocation Records for a specific Inventory item - no costs
BKICA_PLOC_CSTLocation Records for a specific Inventory item - includes costs
BKICK_DSP_LOCLocation/On-Hand Amts for a specific Inventory Item
BKICLOCM_LOOKUPInventory Location Master Records
BKICMSTR_LOOKUPInventory Items
BKJCA_DSP_COJCMS Change Orders
BKJCA_DSP_TRANJCMS Estimate/Chg Order Cost Lines
BKPOSF_DSPUNPSTPOS Un-Posted Sales
BKPOSF_REGPOS Registers
BKPOSJ_L1POS Payments for a specific lay-a-way
BKPOSJ_L2POS Line items for a specific lay-a-way
BKPRA_DSP_PAYHPayroll history records for a specific employee
BKPRA_DSP_W2HW-2 history records for a specific employee
BKPRK_DSP_TXCDPayroll Tax Codes
BKSYSSEC_USERLogon/User Codes
CUST_ADDRCustomer Alternate Addresses
CUST_CCRDCustomer Credit Cards
DSP_FRMTG/L Financial Statements Available Formats
EST_LOOKUPEstimates/Change Orders
GLCOA_LOOKUPG/L Account Codes & Names
GLTRANS_LOOKUPG/L Transactions
JOB_LOOKUPJCMS Jobs
LAY_LOOKUPPOS Active Lay-a-ways
LIST_APRVOUCHRecurring Vouchers for a specific Vendor
LIST_AP_PMTSA/P Payment History for a specific Vendor
LIST_AP_VOUCHA/P Vouchers for a specific Vendor
LIST_ARCHIVEHistory files
LIST_ARRINVRecurring Sales Orders for a specific Customer        
LIST_AR_VOUCHA/R Vouchers for a specific Customer
LIST_BKAPAPOCurrent P/O's for a specific Vendor
LIST_BKARAINVInvoice History for a specific Customer
LIST_BKARASOCurrent Sales Orders for a specific Customer
LIST_BOM_PRODBOM Assemblies & Finished Products
LIST_COSTInventory average cost and last cost for each location
LIST_CURPEmployees during payroll entry
LIST_CUST_JOBCurrent Jobs for a specific Customer
LIST_CUST_POCurrent Purchase Orders for a specific Customer
LIST_GJGeneral Journal Transactions
LIST_JOBLJCMS Job Task Records
LIST_RATETime Card Rates
LIST_SLSPSalespeople
LIST_TERMNORMTerms

LIST_TRX                JCMS Transactions

PLOC_CST_LOOKUPLocation Records for a specific Inventory item - includes costs
PLOC_LOOKUPLocation Records for a specific Inventory item - no costs
POS_CLRK_LOOKUPPOS Clerks
POS_PMT_LOOKUPPOS Payment Types
POS_SLS_LOOKUPPOS Sales Records
PO_LOOKUPPurchase Orders        
PRDIV_LOOKUPPayroll Divisions
PREMP_LOOKUPEmployees
QCFOLLOW_GEN_LUSales Control Lookup Follow-ups
QCFOLLOW_LOOKUPSales Control Lookup Follow-ups for a specific Contact
QCONT2_LOOKUPLookup Contacts for Customer/Vendor
QCONTACT_LOOKUPLookup Contacts
QCSTATUS_LOOKUPLookup status codes
REG_LOOKUPPOS Registers
RSO_LOOKUPRecurring Sales Orders
SO2CODE_LOOKUPOpen Sales Orders
SO2DATE_LOOKUPOpen Sales Orders
SOE_LOOKUPOpen Sales Orders
SO_LOOKUPOpen Sales Orders
ST_CODE_LOOKUPLookup State ID Codes
TASK_LOOKUPJob Cost Tasks
TAX_LOOKUPTaxing Authorities
VEND_ADDRVendor Alternate Addresses
VNDOUTBL_LOOKUPVendors with Outstanding Balances
W2HIST_LOOKUPEmployee W-2 history
WBQLU_BKAPADDRVendor Alt Addresses
WBQLU_BKAP_ADDVendor Addresses
WBQLU_BKAP_FAXVendor Fax Numbers
WBQLU_BKAP_TELEVendor Telephone Numbers
WBQLU_BKARADDRCustomer Alt Addresses
WBQLU_BKAR_ADDCustomer Addresses
WBQLU_BKAR_FAXCustomer Fax Numbers
WBQLU_BKAR_TELECustomer Telephone Numbers
WBQLU_BKPR_ADDEmployee Addresses
WBQLU_BKPR_TELEEmployee Telephone Numbers
WBQLU_CONT_ADDContact Addresses
WBQLU_CONT_FAXContact Fax Numbers
WBQLU_CONT_TELEContact Telephone Numbers

 

Note : New list may have been added to the system since writing of this chanpter.

 


Page url: http://www.cassoftware.com.com/adv7docs/index.html?lookuplists.htm