Export Stock
Submitted by Guest on Sat, 13/03/2021 - 13:04
The Export Stock window is used to export OpenVPMS stock quantities to a CSV (comma separated values) file.
The exported data can be manipulated in a spreadsheet program such as Microsoft Excel or OpenOffice Calc, and imported using the Import button.
Stock can be selected for export using the following criteria:
- Type - one of Medication, Merchandise or All
- Search - enables the products to be queried by name or identity
- Search Identities - if selected, products are queried by identity
- Include Deactivated - if selected, inactive products are included in the search
- Product Type - the type of the product. E.g "Desexing", "Euthanasia".
- Stock Location - the stock location to export stock for. Defaults to that for the current Practice Location
- Income Type - queries products by income type. E.g. "Medication", "Professional"
- Product Group - queries products by product group. E.g "Fees", "Grooming"
- Zero negative quantities - if selected, any stock that has a negative quantity will have its New Quantity set to zero.
Export File Format
The exported data is a comma-separated-values file, containing the following columns:
Column | Required | Type | Description |
---|---|---|---|
Stock Location Id | Yes | Integer | The stock location identifier. |
Stock Location Name | Yes | String | The stock location name. |
Product Id | Yes | Integer | The product identifier. |
Product Name | Yes | String | The product name. |
Selling Units | No | String | The product selling units. |
Quantity | Yes | Decimal | The current stock quantity |
New Quantity | Yes | Decimal |
The new stock quantity. This will be the same as Quantity, unless the Quantity is negative and Zero negative quantities is selected. In this case, New Quantity will be 0. |