Click here to view the Lens Database menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to Contact us.

Introduction

Search for a Lens by Description or SKU

The lens SKU assignment screen  is an lnformix form  that allows you to do direct entry and editing of the lnformix database.   If you're  not familiar with  using lnformix  Forms, please refer  to Perform Menu - Maintenance Screens document to familiarize  yourself  with  the commands  associated with the lnformix perform screens.

From the Optifacts main menu:

Type 9 - Inventory and press enter.

Type 1 – Editor Utilities and press enter.

Type 3 – Lens SKU Assignment and press enter.

The Lens Record table displays. The active table (ln_rec) will be indicated by the [brackets].Image Removed

Image Added

The SKU assignment screen  is broken into three distinctive  sections,  the Lens  Record (ln_rec table), the SKU table (sku table),  and the Inventory Record (invt_rec table).   In order to work with one of these tables, it must be active.  You select the active table with the Master and/or Detail options of the perform screen.  The upper right portion of the screen will show the active  table within  asterisks,  ln_rec table as shown in the diagram below.  On the  main screen,  the  brackets  [ ] will  shift  positions to  show you what fields you may work with. Choosing Master will choose the previous table, choosing Detail will choose the next table.

In the following diagram you can see the brackets in the middle section and the name of the table on the upper right side just above the dashed line.. sku table.

Image Added

To search for a lens, simply Query on the Master table of In_rec,  search for the manufacturer,  style,  seg size (if any), material code, type code (if any), diameter,  and base curve of the lens.   Or, if you know the SKU that you are searching for, you can simply press the letter 'D' when first opening the screen. The active table will then be the sku table and you can type in the SKU code from  the package, and press Escape to perform the search. 

When you find the lens in question, press the letter 'D' to move into the detail table, sku. The  screen  may beep and say  'No Rows  Found'.   If  an  entry  is found, it will be displayed on the screen. This may happen if a SKU exists for a color or add power, but not for the lens you are trying to a SKU for.  Press 'N' to view the Next SKU in the table, until you have viewed all the entries.

Press the 'D' again, this time moving into the  detail section, invt_rec.    You can make adjustments here to a few fields but we cover the full procedures for setting these up further in this document. You can press  the  letter  'A'  to  add  an  entry or  you  may edit  the  fields to  your requirements.  Enter the purchase cost of the item, the bin location, quantity on hand, and specify if the item is stocked or not.  Press Escape to save this information.  Press the letter 'M' once to move back to the SKU section, and M again to return to the Master table.

If you need to  search for another manufacturer,  base curve, material, style, type, or diameter, press the letter 'M' until you make the In_rec table active.  Remember, the top right portion of this screen will show the active  table.  Then simply repeat the above section.

When you have finished, press the letter 'E' to exit this screen and return to the Inventory Editor Menu.

Refer to the instructions below. Should you need to use these tables and need further assistance, please call Optifacts Support. We can work with you over the telephone, walking you through a few  actual entries, and making sure you understand how to work with these tables.

Lens Record Table

• Type Q to Query a lens record.
• Enter the applicable criteria in the field(s) provided that you will need to perform the search.
• Press Escape to view the results.

In the following example, we queried mfr ES, style P material PC and type VXC. We can see that there 15 rows found based on the search criteria. Since we did not specify a diameter or base curve, it has found all diameters and bases with the criteria that we specified. 

• Type N for next to move to the next record, until you come upon the one you need to add SKUs toare searching for.

Image RemovedImage Added

• Once you have found the record, type D for Detail.

SKU Table

• Type Q to Query a lens record.

The SKU table will now be indicated as active by the [brackets]. This allows you to add more SKU records to the lens.

• Enter the sku number you are looking for.
• Press Escape to view the results.
• Type N for next to move to the next record, until you come upon the one you are searching for

In this example, we can see that the system has found 48 SKUs for the 4 base 78mm lensthe SKU 0204937783.

Image RemovedImage Added

• Type A to add a new SKU. This will enable the Side, Color, Add fields and SKU field for data entry. The active cursor will be in the SKU field.

Image Removed

• Type the SKU number and press enter.
• Type the Side (L/R/B)
• Type the Color code and press enter. The color may have defaulted to W or CLR based on your LMS configuration.
• Type the Upper Add value (if applicable – Vocational Lenses) and press enter.
• Type the Lower Add value and press enter.
• Press Escape to save the data.

• Type D for Detail.

• D for Detail to proceed to the Inventory Information in the lower section.

Inventory Record Table

The inventory table will now be indicated as active by the [brackets].

Image RemovedImage Added

You can use this section of the screen to update or add the relevant inventory data for this SKU. However, we have procedures to update lenses as described later in this document.

• Type A to add a new record or E to edit.
• Type Y for Stock or N for Non-Stock and press enter.
• Type the Bin Location and press enter.
• Type the Min Stock value and press enterThe fields available in the invt_rec are:
  • Stocked (Y/N)
  • Bin Location
  • Min Stock value. This field may be left at the default value if it is being managed by the inventory control clerk.
  Type the
  • Max Stock value
  and press enter
  • . This field may be left at the default value if it is being managed by the inventory control clerk.
  • Type
  the
  • (M
  for manual
  • ) Manual or
  C for computed and press enter. This field may be left at the default value if it is being managed by the inventory control clerk.Type the M for manual or C for computed and press enter. This
  • (C) Computed. This field may be left at the default value if it is being managed by the inventory control clerk.
• Press Escape to save the data.

Image Removed

• Type Type E to exit the screen or type M for Master or T for Table to move the active cursor back to the SKU table to add another SKU.
• If

• Once all SKU records have been added, type M for Master or T for Table to move the active cursor back to the lens record tableyou need to update inventory records for more SKU's you can either type N to proceed to the next SKU or type M to return to the master table to perform a new search.
• Type E to exit the screen.

Click here to return to the top of the page.