...
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 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.
...