Locating Data for Infor Lawson Add-ins Queries

To use the wizards effectively, you must be familiar with the data you want to query. If you know the Infor Lawson form the data appears on, you can view the form to gain useful information:

  • If you don't know a field name, you can look it up in Infor Lawson. For Query and Upload Wizard operations, you need to know both the long and short field names. Use the table below to determine how to look up field names in your Infor Lawson user interface.

    User interface Details
    Infor Lawson Portal and XML User Interface Open the Infor Lawson form and position the cursor on top of the field you want the name for. Press Ctrl-Shft-O. The long and short field names appear at the lower left corner of the screen.
    COM+ Desktop Open the Infor Lawson form and position the cursor on top of the field you want the name for. Press Ctrl-Shft-I. The long and short field names appear at the lower left corner of the screen.
    Infor Lawson Interface Desktop (LID) Select Options, and then select Show Field Numbers to display the field numbers used on the form. Field names are not available in LID.
    Java Desktop

    Select Options, then select Show Field Numbers.

    When you select a field, the name and number is displayed at the bottom of the screen.

  • Verify the Infor Lawson form for key fields and key field values. All wizard queries rely on key field values to search for the specific data you want. If you provide key field values when you set up the queries, searches are much faster and more efficient.

  • Note valid formats for data. If you use the Upload Wizard to write data into Infor Lawson, the data must be in the correct format for the Infor Lawson system to recognize it. As a result, dates you enter convert to the yyyymmdd format.

  • Note any other required fields on the form. If required fields are missing, the Upload Wizard cannot write data into the Infor Lawson database. Some sample required fields are Company, Employee, and Effective (date).