Laboratory Price Update support

Donate to this project

Submitted by tony on Thu, 30/06/2022 - 09:15

Development Project Status: Completed

Total cost estimate (ex-Tax):

$5500

Due date for completion of this stage:

30/09/2022

Release:

2.3

Current Percentage Funded:

100.00%

Project funding:

You can donate money to this project by entering the amount above and clicking the 'Add to cart' button. In the Checkout process you can either choose to pay now (via Bank Transfer, Cheque or Pay Pal) or you can pledge the amount by choosing the 'Pledge a payment for a Development Project' method. If you make a pledge, then when we have 100% funding commitments, you will be notified by email and you can then action your payment. Note that development will not commence until all funds are received.

Project description:

Laboratory providers provide clinics with regular price updates for requested laboratory services.

Provide a mechanism to update associated product cost prices (and subsequent selling prices using the markup) based on the updated test prices.

Initially this will allow cost price updates via imported spreadsheets in a defined format for Laboratories that dont support the LAB API.

The new Feature would take a spreadsheet in this format :

code - test code (mandatory)
name - test name (mandatory)
description - extended test description (optional)
specimen - sample instructions (optional)
turnaround time - days (optional)
price - ex GST cost price (mandatory)

Specifically the new feature will perform both Test Import and price update functions. It will:

prompt to upload the list of tests
prompt for the investigation type to associate the tests with
would only allow selection of an investigation type not managed by a lab (plugin lab)
support creation of a new investigation type
Provide a preview of changes to apply and confirmation from user.
create new tests and associate them with the investigation type
deactivate tests that are associated with the investigation type but not present in the new spreadsheet
Provide a preview of price updates that would be applied to products and , if accepted, update product cost pricing for products currently linked to tests. For products with multiple linked tests will accummulate test prices to update product cost price. Cost price updates would automatically update selling prices based on the markup.

Also , when adding tests to products, users will be prompted to update product cost price based on calculated new cost price and subsequent selling price. This supports adding new products and test combinations.

LAB API support for price updates will be added as a subsequent feature and is not included in this project.

JIRA: OVPMS-2694