...
Prerequisites for this function are that Rx-Universe must have the Rx-Inventory and Rx-Process Connect modules installed.
To update inventory quantities, the third-party system must create a file and place that file into the folder used for electronic jobs. While this is usually OMICSTX, under the base Rx-Universe folder, it can be changed on the "Remote Order Parameters" screen:
The file created must have an extension of ".QTY", but the basename can be anything. Since Rx-Universe will archive any quantity files submitted (in the ARCHIVE folder), it is suggested that the basename could be based on the date and time of the update. For example, an inventory update on November 20, 2014, at 2pm, might be named 201411201400.QTY. That makes tracking history of quantity updates much easier.
When a third-party system sends quantities, it should sent the quantity available to be used for the product. Rx-Universe tracks all inventory in the lab, divided into 3 categories:
- Total quantity of lenses - the total number of lenses in the lab, whether on the shelf or in production
- Quantity allocated - the number of lenses allocated for jobs, but not yet physically removed from the shelf and placed in the tray
- Quantity in process - the number of lenses actually in trays and therefore in production in the lab
The quantity available for a lens is the total number less the quantity allocated, less the quantity in process.
Any inventory updates applied to Rx-Universe inventory items using a file are tracking tracked as an inventory transaction, just as if they had been entered manually.
Record format:
OPC=Qty;[Type]
OPC – is the 10-digit OPC number of the lens blank
Qty – is an integer value, the number of lenses for this OPC code
Type – an optional field, is “A” for adjustment, a missing value or any other value is interpreted as a quantity update.
...
This would tell Rx-Universe to adjust the quantity on the shelf for OPC 2345678901 by -20 (removing 20 lenses from the inventory). This allows a third-party system to update Rx-Universe for large transactions without having to calculate total quantity, and without concern that the quantities might get out of sync due to timing of relieving inventory in the two systems.
Error File:
After processing, if there were any errors (OPC codes not found in Rx-Universe, or inventory products not activated), a file will be created in the ERRORS folder, with the same basename as the quantity file, and an extension of .ERR.
For example, if file 201411201400.QTY is submitted to the OMICSTX folder, an error file OMICSTX\ERRORS\201411201400.ERR will be created indicating any errors that occurred.
Example 1:
File containing a complete inventory update for all lenses, using date and time as the base filename:
...
Contents:
0100780295=11.0 167 Easy 1-base 75-add right eye only
0100780287=10 .5 167 Easy 1-base 75-add left eye only
. . .
0202773586=26.0 CR39 Silor SV 725-base – one record, since sample OPC L/R
...