Batch and Expiry for Vaccinations in Version 7

Batch and Expiry for Vaccinations in Version 7

In old version the batch and expiry was in the reminder screen


In the new version they need to have Use Expiry = Yes or Optional in Product record. then a separate batch and expiry prompt will come up.




During the V7 upgrade it should automatically update the Use expiry to Optional if a product had a vaccination type reminder. However this doesn't look like it has happened for Wanganui.

We can update the records manually with the queries below. Just let leanne know your going to do it and what they need to do if they set up new vaccinations.
For Normal Product
update "Product_Main" set "Use_Expiry" = 'O'
where "Ref_Number" in (select p."Ref_Number" from "Product_Main" p
                       inner join "Reminder_Types" t on t."Ref_Number" = p."Rem_Type"
                       where p."Ref_Number" > 10000001000
                       and p."Status" = 'A'
                       and t."Type" = 'V' and t."Status" = 'A'
                       and "Get_Use_Expiry" (p."Ref_Number") = 'N')

For complex product type vaccination
update "Product_Main" set "Use_Expiry" = 'O'
where "Ref_Number" > 10000001000
and   "Status" = 'A'
and   "Get_Use_Expiry" ("Ref_Number") = 'N'
and   "Ref_Number" in (select "Prd_Num" from "Product_Complex" p
                       inner join "Reminder_Types" t on t."Ref_Number" = p."Rem_Type_Num"
                       where p."Status" = 'A' and t."Type" = 'V' and t."Status" = 'A'))