Click here to view the Lens Inventory menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to Contact contact us.

Introduction

This document provides instructions on how to match the quantity on hand (in the system) to the physical lens count in the inventory. Use these procedures to adjust your quantity on hand, report on the count that has been changed, and adjust costcosts.

Procedure

Print Physical Forms and take a physical inventory count. This will show step shows how much you have in stock and its value. 

Physical inventory is another important a necessary procedure that the lab cannot be overlookeddisregard. It is important crucial for the system to ‘know’ “know” how many lenses are available for picking and min/max reasons. Optifacts has a few different methods of obtaining a physical inventory count, but they all involve you actually physically counting all those lenses.

If you have there are a few terminals computers with barcode readers attached, the counting of inventory can be made simpler by utilizing these stations. Remote or portable scanners are also available that make inventory a breeze. Some labs move lenses, a drawer or bin at a time to a station, count it, and return it back to the inventory area, repeating this until all lenses have been countedthe counting of all lenses is complete.

When doing your the first physical inventory with Optifacts, it might be a good idea to have Optifacts support reset all lens counts to zero (0) quantity right before you start the counting starts. You can then use Use a scanner to scan and count all lenses, incrementing SKU counts as you proceed. For all physical counts after this, you will be able to can print discrepancy reports, showing any quantity differences in pre and post physical count quantities.

Cycle Counts are Counting is one of the most important essential functions of Inventory Management. This procedure ensures that the actual number of lenses on the shelf match matches the inventory in the system.

Performing an inventory count is a multi-step process as follows:

1. Clear out any previous counts.
2. Print cycle count sheets that list the lens SKUs, bins locations, and (expected) quantity on hand.
3. Physically count the inventory.
4. Print the Variance Report. The Variance Report lists any changes to the inventory that were founddiffers from the current count in the system.
5. Update the system’s inventory to reflect the changes.

From the Optifacts main menu:

Type Select Option 9 - Inventory and press enterEnter.

Type Select Option 3 – Inventory Procedures and press enterEnter.

Type Select Option 10 – Physical Inventory Menu and press enterEnter.

The Optifacts Lens Inventory Physical Inventory Menu displays.Image Removed

Image Added

Step 1 - Clear Inventory Forms

Select Option 1 – Clear Inventory Forms from the Physical Inventory Menu and press

Enter.

OK

to Continue (Y/N)?

• Type Y and press enter Enter “Y” to clear the fileform.
• Type N Enter “N” to return to the menu.

Image Removed

Image Added                                                                                                                 

• Press enter Enter to return to the Optifacts Lens Inventory Physical Inventory Menu.

Step 2 - Generate Forms

Select Option 2 – Physical Inventory Forms from the Physical Inventory Menu and press

Enter.

The Inventory Physical Form Generate screen displays.Image Removed

Image Added

• Type Enter the starting bin location in the Bin Start field or type * to designate all bins and press enter.Type
• Enter the ending bin location in the Bin End field or type * to designate all bins and press enter.
• Type Y Enter” Y” in the Order by Bin Location? (Y/N) field and press enter.
• Type Enter the style code or type * to designate all styles and press enter.
• Type Enter the Seg. Size or type * to designate all seg sizes and press enter.
• Type Enter the Material code or type * to designate all materials and press enter.Type
• Enter the Color code or type * to designate all colors and press enter.
• Type Enter the Lens Type code or type * to designate all types and press enter.
• Type Enter the beginning diameter or type * to designate all diameters and press enter.Type
• Enter the ending diameter or type * to designate all diameters and press enter.
• Type Enter the beginning base or type * to designate all bases and press enter.Type
• Enter the ending base or type * to designate all bases and press enter.
• Type Enter the beginning cylinder or type * to designate all cylinders and press enter.Type
• Enter the ending cylinder or type * to designate all cylinders and press enter.
• Type Enter the beginning upper add or type * to designate all upper adds and press enter.Type
• Enter the ending upper add or type * to designate all upper adds and press enter.
• Type Enter the beginning lower add or type * to designate all lower adds and press enter.Type
• Enter the ending lower add or type * to designate all lower adds and press enter.
• Type Enter 0 for regular thickness or 1 for extra thickness and press enter.Type ,
• Enter the mfr code or type Enter * to designate all manufacturers and press enter.

Has the data been printed correctly(Y/N)

• Type Y Enter” Y” if it printed correctly.
• Type N Enter “N” to repeat the processsteps.

Store the entries into the physical inventory file (Y/N)

• Type Y and press enterEnter” Y” to store the entries.
• Press Escape to return returning to the Optifacts Lens Inventory Physical Inventory menu.

Step 3 - Verify and Enter Inventory Count

Manually verify the physical inventory in the bins and write the quantity on the report.

Select Option 3 – Physical Inventory Entry from the Physical Inventory Menu and press

Enter. (

The lab may

have a configuration in place to take you directly to the entry form from this menu option as shown in the following diagram).

Image Removed

Image Added

Select Option 2 - Enter

Counts Manually from the Physical Entry Menu, and press

Enter. (

You see only

the menu options as shown in the following diagram if

the lab has a configuration in place to do so).

Image Removed

Image Added

• Once the Inventory Physical Entry form displays, type 1 in the page # field and press enterEnter.

• Press Enter past the SKU field.

The first entry

displays on the screen.Image Removed

Image Added

• Type the Enter the number of lenses from the manual verification of physical inventory in the Counted field and press enter.

The next SKU displays automatically

.

• When all changes are complete, press Escape to exit.

Step 4 Variance Report

Step 4 - Variance Report

The Physical Count Variance Report compares actual inventory to system counts.

Select Option 4 – Physical Count

Variance from the Physical Inventory Menu and press

Enter.

Image Removed

Image Added

Output to Screen Only? (Y/N)

• Type N and press enter Enter “N” to print the report.

The “Printing is complete” complete.” message displays.Image Removed

Image Added

• Press Enter to return to the Optifacts Lens Inventory Physical Inventory Menu.

Image Removed

Image Added

Step 5 - Update Inventory

Once the Physical Variance is completedcomplete:

• Type Select Option 5 – Update From Physical Form Form from the Physical Inventory Menu and press enterEnter.

The Inventory Physical Update Routine displaysis displayed.Image Removed

Image Added

• Enter the Bin Start location or leave * for all locations and press enter.
• Enter the Bin End location or leave * for all locations and press enter.

Would you like to begin this procedure? (Y/N)

• Type Y to continue and press enter.
Type N Enter “Y” to update the inventory and complete the process.
• Enter “N” or Escape to return to the menu.

Image Removed

If you typed Y to continue, the inventory will be updated and the Update Process Complete message will display.

Image Removed

Image Added

Image Added

• Press any key to return to the Optifacts Lens Inventory Physical Inventory Menu.

Step 6 - Inventory Valuation Report

This The Inventory Valuation Report shows the dollar amounts and counts of your inventory at the time of running. The Inventory Valuation Report is the report to use if you need to send inventory results to Essilor.

From the Optifacts main menu:

Type 9 - Inventory and press enter.

Type 2 - Inventory Reports and press enter.

Type 7 - Inventory Valuation Report and press enter.

The inventory Valuation Report screen displays.

Image RemovedBefore you run the reports, open WinSCP, and log in.

Use WinSCP to Access the Reports

• Open and log on in to WinSCP with your assigned user name and password. Typically, the username is “reports,” and the password is “reports.” Check with Optifacts Support or lab management to confirm. (Refer to the WinSCP Instructions for Monthly Manufacturer Reports document for full details.)
• Go to the following directory: Optifacts/Share/mfr_reports (Once set, it will automatically open opens in that directory next time.)
• Delete any previous invt.txt files in WinSCP from both the Optifacts/share/mfr_reports folder (right side of the screen in WinSCP) and your local folder (left side of the screen in WinSCP)

Image Removed

Image Added

Now go back to the Optifacts screen.

From the Optifacts main menu:

Select Option 9 - Inventory and press Enter.

Select Option 2 - Inventory Reports and press Enter.

Select Option 7 - Inventory Valuation Report and press Enter.

The Inventory Valuation Report screen is displayed.

Image Added

You can run Run a complete report for all product products, or you can specify a product(s) by entering any of the criteria shown in the Inventory Valuation Report diagram shown abovepreviously.

• To run the report for all productproducts, leave the ( * ) asterisk pressing enter Enter until you reach the Print Items Only with Zero Cost/Without Zero Cost/Both (Z, W, B) B  field. This field defaults to B (both), but you can change it to Z (with zero cost) or W (without zero cost).
• The Print Stocked/Non-stocked/Both (S, N, B) B  field defaults to B (both), but you can change it to S “S” (stocked) or N “N” (non-stocked.
• The Print Summary only or Detail also (S, D) S field defaults to S (Summary), but you can change it to (detailed).

Detailed Report

First, run a Detailed “Detailed” report.

• On the Print Summary only or Detail also (S, D) S line, change the S to a D and press enterEnter.
• Wait for the report to process and print.

Now go back into WinSCP

Refresh the screen by clicking the green arrows (as shown in the diagram below)

Image Removed

Image Added

The report displays in the right side window. It is currently named invt or invt.txt.Image Removed

Image Added

• Click on the file and drag it over to your the local folder on the left side of the screen.

You will now see it in your The report gets copied over to the local folder on the left side of the screen.Image Removed

Image Added

• Immediately Right Click on the file name in your the local folder on the left side of the screen, and then click on Rename. You can change Change the name to  to something that makes sense. (For example "invt‘invt_count_datedate’).

Image Removed

Image Added

After renaming the file, it is ready to email it to Essilor.Image Removedthe AR Department

Image Added

Image Removed

Image Added

Summary Report

Repeat the above process for the Summary Reportsteps shown above in the Detailed Report section for the “Summary” report.

• The only thing you need to do, is difference is to leave the S in the Print Summary only or Detail also (S, D) S line.

Image Removed

Image Added

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

Click here to return to the top of the page.