Essilor Digital Report

Owned by Tony LeBlanc
Last updated: Nov 05, 2018 by Oscar Quintero
4 min read

Overview

Labs that manufacture Essilor Digital lenses are required to provide a report to Essilor summarizing the production of Essilor Digital lenses for a period of time. The Essilor Digital Report will generate a report to be sent to Essilor, this data is provided as a comma-delimited (CSV) file which can be emailed to Essilor by the lab.

Essilor’s format requires Essilor Digital jobs to be reported on once they have been shipped; and to include information on each time the job was sent to the Essilor calculator, each time a lens was broken, each time the job was requested on a generator, each time it was sent to an outside lab, if it was deleted and each time it was shipped.

The report consists of the following columns:

  • Vendor (ES, Essilor)
  • Customer Number 
  • Order Number
  • Eye
  • LNAME
  • Description
  • Event
  • Date
  • Time


NOTE: Lab must have Job Tracking set and running, Ship all the jobs and run the Daily Processing (Day-end).

Include Click Fees 

Checking the "Include Click Fees" checkbox will add four columns to the end of the report. The columns are:

  • Click Fee (Generated)

  • Click Fee (Shipped)

  • Click Fee (Calculated)

  • Material Cost

The click fees are separated into columns to make totaling easier.

In addition, if the "Include Click Fees" checkbox is checked, you will not be prompted to send the report to Essilor, but rather be prompted to open the file as a CSV. 


Manufacturer Set Up

In order to identify the lab to Essilor, to provide the email address to send to and destination FTP address and account credentials; a manufacturer record needs to be set up with manufacturer code “ESSD”. The key fields to be filled in are the customer number field (which needs to be set with the lab’s account number with Essilor Digital, which may be different than the Essilor Lens account), the email address to send the file to and the ftp location and credentials (need to be obtained from Essilor for each lab) and entered into the Report Information fields:



Job Track Station Set Up

In order to identify when a job is outsourced (sent to an outside lab), when is sent to Essilor calculator  and when requested by a generator; the job track station entries for the outside lab, the Essilor Digital Calculator and all generators must be correctly set up. The job stations for the generators must be identified as “Generators” in the job track station record:

Similarly, remote labs have a job station associated with them, and the job track station for that remote lab must be identified as an Outside Lab:

For the Essilor calculator a job station must be created as follow (the example below uses ESS for the station ID but you can set whatever you want):



Device Interface Parameters Set Up

In the Device Interface Parameters setup, each device must be associated with a job track station. For the generator find below an example:

For the Essilor Digital Calculator, you must set the job station you created previously:



How to Create the File

The report can be run manually, at any time, from the main menu select Reports->Order Reports->Manufacturer Reports->Essilor Digital Report in RxU, or select “Order Functions”, then “Order Reports”, then “Manufacturer Reports”, then “Essilor Digital Report” in Omics.. The report is a standard Rx-Universe report, allowing the lab to specify the time frame to report on, and optionally to save reports with particular parameters.

At the prompts, enter the starting and ending dates for the reporting period. Once the dates are entered, the program will create a file with the name “yyyymmcustomer#ESDIGI.CSV”, in the default RxUniverse/OMICS folder, where yyyymm is the last month of the report and customer# is the value set for the manufacturer ESSD (for this example is 999999). So, if the date range was entered as 09/01/2018 to 09/30/2018, the output filename will be 201809999999ESDIGI.CSV.

This file is in a format determined by Essilor, and may be easily viewed with any CSV-compliant application (such as Microsoft Excel). The file will then need to be emailed or otherwise transferred to the appropriate Essilor contact.

The report can also be configured to run automatically as part of the month-end. On the dayend tab under System Parameters, the option to run the report automatically can be checked:


*For the status Shipped,Broken and Deleted that you get in the Report there is not need to set anything because those are hard-coded in the program.