Best Practice Configuration under 1.8 templates for Vaccines and managing stock
Submitted by Ben_Charlton on Thu, 25/06/2015 - 15:27
Vaccine stock management has always been problematic I think...The only reliable method is direct product count each time an order is due.
Basically this is because the of the way vaccines are sold.
EG
Vaccincate Puppy - includes a consult and a C4 plus KC vaccine.
C4 can be ordered as in our case as a set of 10 or as part of a C5 combo pack as a set of 10 with 10 KC.
Both the C4 and the KC have seperate batch numbers and expiry dates
Therefor how do I
1. Bill this out so it best manages my stock.
2. Adjust orders to best manage my stock.
Sub Question: do we support cascading templates. Ie templates inside templates.
Re: Best Practice Configuration under 1.8 templates for ...
Ben - the Sub Question is easy - YES - it says so in http://www.openvpms.org/documentation/csh/1.8/new-features and http://www.openvpms.org/documentation/csh/1.8/concepts/products and http://www.openvpms.org/documentation/csh/1.8/product/template.
Ah the documenter's life is not a happy one when nobody reads what they write.
The others I need to thionk about. Regards, Tim G
Re: Best Practice Configuration under 1.8 templates for ...
OK - I have thought. Why can you not use either a) the 'print aggregate' option on the template (so it shows a just the template item); or b) the zero-price and print options on the template line items.
The zero pricing allows you to do stock control and no affect the invoice amount; the print option allows you to hide the items.
Regards, Tim G
Re: Best Practice Configuration under 1.8 templates for ...
It presents its own challenge - a Document can only be linked to a single Invoice Item yet now we have multiple items (albeit hidden) for a vaccination..
This is required to track all batch and expiries given to an animal
Re: Best Practice Configuration under 1.8 templates for ...
Ben - the template item is not the invoice item, rather each product in the template is an invoice line item. [Thats what makes it a pig to handle the templates when printing the invoice - if print-aggregate is set then you have to hide all the line items that came from the template and display just the template. If you print the line items in date order this is not a problem, but we reorder by product type and hence potentially the line items in the template show up in different product groups.
Also - I don't understand your "a Document can only be linked to a single Invoice Item" - in the act.customerAccountInvoiceItem the documents node has a max cardinality of -1 - ie unlimited.
The batch node does have a max cardinality of one - and hence there is a potential problem that if the dose is 6 tablets, they all need to come from the same batch.
Regards, Tim G
Re: Best Practice Configuration under 1.8 templates for ...
Think about it...If I perform a a C5 vaccination here in australia I am selling 2 products to do it....a C3 and a KC/PI ...each have a batch and expiry and an associated invoice item (hidden or not)
I have to product 2 vacc certs 1 for each...
Hence my comment that documents can only be linked to 1 invoiceitem
Regarding printing and hiding I am not even concerned by that yet.
Re: Best Practice Configuration under 1.8 templates for ...
If the issue is that you want both medications to appear on a single certificate, then this is not directly supported. You will need to develop a report that collates the vaccinations. There are history functions that can help do this.