Versions Compared

Old Version 11

changes.mady.by.user Lori Dickson

Saved on

compared with

New Version Current

changes.mady.by.user Lori Dickson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Click here to view the Lens Database menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to Contact contact us.

Search Optifacts User Documentation

Live Search
spaceKeyOPPUB
placeholderEnter search keyword(s) here


Table of Contents (on this page)

Table of Contents
outlinetrue
indent15px20px
stylenone

Search for a Lens by Description or SKU

Introduction

The lens SKU assignment screen

 is

is an

lnformix

Informix form

 that

that allows you to

do direct entry and editing of the lnformix database

enter and edit the Informix database directly.   If

you're  not

you’re not familiar with

 using lnformix

using Informix  Forms, please refer

 to 

to Perform Menu - Maintenance Screens

document to familiarize  yourself  with  the commands  associated with the lnformix

document to familiarize yourself with the commands associated with the Informix perform screens.

Procedure

From the Optifacts main menu:Type

Select Option 9 - Inventory and press

enter

Enter.

Type

Select Option 1 – Editor Utilities and press

enter

Enter.

Type

Select Option 3 – Lens SKU Assignment and press

enter

Enter.

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

Image Added

The SKU assignment screen

 is broken into

has three distinctive

 sections

sections,  the Lens  Record (ln_rec table), the SKU table (sku table),  and the Inventory Record (invt_rec table). 

 In order to

 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

table within

 asterisks

asterisks,  ln_rec table, as shown in the diagram below.

 On the  main screen,  the  brackets

 The brackets  [ ] will  shift  positions to  show you what fields you may work with on the main screen. Choosing Master will choose the previous table

, choosing

. Choosing Detail will choose the next table.

In the following diagram, you can see the brackets in the middle section and the table’s name

of the table

on the upper right side just above the dashed line

..

(sku table).

Image Removed

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'

“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

the package

,

and press Escape to perform the search. 

When you find the lens in question, press the letter

'D'

“D” to move into the detail table, sku. The

 screen  may

screen may beep and say

 'No

,  “No Rows  Found

'

.

   If  an  entry  is found, it will be

”   If the system finds an entry, it gets displayed on the screen.

This

It may happen if

a

an SKU exists for

a

color or add power, but not for the lens you are trying to

a

find an SKU

for

.  Press

'N'

“N” to view the Next SKU in the table

,

until you have viewed all the entries.

Press the

'D'

“D” again, this time moving into

the 

the detail section, invt_rec.    You can make adjustments here to a few fields, but we cover the

full

complete 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

the letter  “A”  to add an entry, or you may edit the fields to your requirements.  Enter the item’s purchase cost

of the item

, the bin location, quantity on hand, and specify if the item is

stocked or not.  Press

stock or non-stock—press Escape to save this information.  Press the letter

'M'

“M” once to move back to the SKU section

,

and

M

“M” again to return to the Master table.

If you need

to  search

to search for another manufacturer,  base curve, material, style, type, or diameter, press the letter

'M'

“M” until you make the In_rec table active.  Remember, the top right portion of this screen

will show

shows the

active 

active table.  Then

simply

repeat the above section.

When you have finished, press

Press the letter

'E'

‘E’ to exit this screen and return to the Inventory Editor Menu when you have finished.

Refer to the instructions below. Should you need to use these tables and need further assistance,

 please 

 please call Optifacts Support. We can work with you over the telephone, walking you through a few

 actual

actual entries

,

and making sure you understand how to work with these tables.

Lens Record Table

  • Type Q Press “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 are 15 rows found based on the search criteria. Since we did not specify a diameter or base curve, it has we found all diameters and bases with the criteria that we specified. 

  • Type N Press “N” for next to move to the next record , until you come upon the one you are searching forneed.

Image Removed

Once you have found the record, type D for Detail

Image Added

  • Press “D” for Detail once the lens information displays on the screen.

SKU Table

  • Type Q Press “Q” to Query a lens record.

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

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

In this example, we can see that the system has found the SKU 0204937783.Image Removed

Image Added

  • Type D Press “D” for Detail to proceed to the Inventory Information in the lower section.

Inventory Record Table

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

Image Added

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

  • Type A Press “A” to add a new record or E “E” to edit.
  • The 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 is managing it.
    • Max Stock value. This field may be left at the default value if it is being managed by the inventory control clerk is managing it.
    • Type (M) Manual or (C) Computed. This field may be left at the default value if it is being managed by the inventory control clerk is managing it.
  • Press Escape to save the data.
  • Type E Press “E” to exit the screen or type M press “M” for Master or T “T” for Table to move the active cursor back to the SKU table.
  • If you need to update more inventory records for more SKU's you can either type N , press “N” to proceed to the next SKU or type M press “M” to return to the master table to perform a new search.Type E

Press “E” to exit the screen.

To view and download these instructions as a PDF file, click on the following document image.

View file
nameLens SKU Search.pdf
height250

Click here to return to the top of the page.