Overview
Selecting a row within the grid of either the Matched Items Summary or Unmatched Items Summary forms displays this form. This form enables detailed editing (or review) of the full Edit Tyre File record as provided on the import file in columnar format (each record has 109 fields). Changes made at this detailed level recalculate values at the header level when returning to the Matched Items Summary or Unmatched Items Summary forms. If a record is edited in the Unmatched section to allocate to a valid vehicle (possible for both typing errors and cherished plates, etc) then the record then moves to the Matched section accordingly. All totals recalculate to reflect this record moving
What do you want to do?
To access the Edit Tyre File form:
From the Master Menu, select the Maintenance Control option and Company required.
The Maintenance Control menu is displayed.
Select the Miscellaneous Options option.
The Miscellaneous Options menu is displayed.
Select the Tyre Import Menu.
The Tyre Import Menu is displayed.
Select the Edit Tyre File option.
The Edit Tyre File form is displayed.
This form is divided into three parts that are as follows:
Title Bar
In addition to displaying the form name the Title Bar displays a number of other useful identification criteria and buttons.
Edit Tyre File Dialogue Box
This form displays a record table containing all the fields that have been imported from the raw .csv file into the ADP Batch File (FA tyimp).
Field Type Occurs Description Pack Image Display Image Vtype Vstring REGNO C10 Registration Number ODOMETER P3 Odometer Reading ###### ###### SUPPLIER C30 Supplier Name INVNUM C8 Invoice Number INVTOTAL P8 Invoice Total -13.2 -13.2 INVDATE J3 Invoice Date REPFLAG C1 7 Replacement Flag TYRE C16 7 Tyre Detail REPLREAS C15 7 Replacement Reason TREAD P1 7 Tyre Tread Depth ##.## ##.## RECHFLAG C1 7 Recharge Flag TYREVAL P8 7 Tyre Price -13.2 -13.2 VALVEVAL P8 7 Valve Price -13.2 -13.2 BALVAL P8 7 Balance Price -13.2 -13.2 TYRRECHP P3 7 Tyre Recharge % ###.## ###.## TYRRECHV P8 7 Tyre Recharge Value -13.2 -13.2 TOTLINE P8 7 total Line Price -13.2 -13.2 OTHER C16 5 Other Items OTHREPLR C15 5 Other Replacement Reason OTHVAL P8 5 Other Price -13.2 -13.2 OTHRECHP P3 5 Other Recharge % ###.## ###.## OTHRECHP P8 5 Other Recharge Value -13.2 -13.2 CUSTCODE C7 Customer Code MATCHED C1 Matched? C MISMATCH C20 Mismatch Reason BATCHID P3 Batch ID ## ## BATCHYR P3 Batch Year #### #### IMPDATE J3 Import Date USERID C8 User ID DATEAMEN J3 Date Amended PROCID C8 Processed User ID PROCDATE J3 Processed Date EDITUSER C8 Editing User Id Note 1: All fields with the exception of MATCHED, MISMATCH, BATCHID, BATCHYR and IMPDATE mirror directly (and in sequence with) the fields received on the import file. The MATCHED, MISMATCH, BATCHID, BATCHYR and IMPDATE fields are set according to the success of the validation for each record.
Note 2: Following are Key Fields BATCHID, BATCHYR
Note 3: Matched? field will have the following menu items:- Posted, Matched, Not Matched and For Deletion.
The list displays up to a maximum of twenty five records at any one time. To view the remaining records the Scroll Bar immediately to the right of the second column can be operated in a number of ways:
COMMAND BUTTONS:
A number of command buttons are available. Some buttons are context sensitive and are greyed-out and only become available dependent upon the particular process that is being accessed. The full list of command buttons is as follows:
Exit: Exits the current form and returns to the Tyre Import Menu.
Help: Provides online access to a context sensitive Help form.
Grid: Displays all records. Each field for the record is displayed in the appropriate row with the code displayed in the left-hand column and the field data in the right hand column(s). Selection of this command button makes available several alternative command buttons not available within Column mode:
Sort: Sorts the records by the chosen keypath. Upon selection, a Keypath List Box is displayed from which the appropriate keypath (if there is more than one) is selected.
Refresh: Redisplays the records on the form with any new modifications.
Reverse: A checkbox that, when selected, displays the records in descending order.
Autorefresh: A checkbox that, when selected, automatically redisplays all records on the form after an amendment.
Start At: Restricts a Sort by allowing entry of a text string from which to start.
Finish At: Restricts a Sort by allowing entry of a text string at which to finish.
Fields: Purpose of this command button is to allow the display of a user-defined selection of fields for every record. This is intended to reduce data entry errors. It is not really applicable to this form.
Ad-hoc: Selection of this button displays a further form that provides an Ad-hoc Report Generator for the creation of quick query reports to form. An enquiry is formulated by completing a simple set of verbs and field names. A saved formulated query can be retrieved for future use.
Column: Displays one record at a time. Within this option, records may be created, amended or deleted.
While within Grid mode, the record table may be edited with a single-right-click of the mouse in either of the two columns which then displays a small menu box with the following options:
Edit Row: Enables the current cause code description to be edited. Alternatively, single-left-click into the row, enter the appropriate data and use the Tab key to move to the next column.
Insert Row: Inserts a blank row above the selected record so that a new cause code /description may be added.
Delete Row: Deletes the selected cause code record.
Copy: Enables the cause code description for one record to be copied to other records to speed data entry.
Filter: Presents a Selection Criteria Box which enables selection of only those records meeting the selection criteria. The following mutually exclusive selection criteria option buttons/fields are available:
Equals: Searches the column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are displayed.
Not Equal: Searches the column for a description matching that entered in the data entry box at the bottom of the form. Any records equaling the criteria are not displayed.
Greater Than: Searches the column for any records with a text character string which is alphabetically higher than the character(s) entered in the data entry box at the bottom of the form. Any records greater than the criteria are displayed.
Less Than: Searches the column for any records with a text character string which is alphabetically lower than the character(s) entered in the data entry box at the bottom of the form. Any records less than the criteria are displayed.
Contains: Searches the column for any records with a text character string containing the character(s) entered in the data entry box at the bottom of the form. Any records meeting the criteria are displayed.
Range: Searches the column for any records with a text character string which is alphabetically equal to or between the character(s) entered in the two data entry box at the bottom of the form. Any records meeting the criteria are displayed.
No Filter: No filter is applied to the record search. The Reset command button also activates the "No Filter" option.