--- title: Batch and Expiry for Vaccinations in Version 7 description: VetLinkPro Batch and Expiry for Vaccinations in Version 7 --- # VetLink PRO Connecting Veterinary Professionals with Smarter Solutions [Skip to content](https://help.vetlinkpro.com/vetlinkpro/batch-and-expiry-for-vaccinations-in-version-7#main-content) English - Australia Show submenu for translations ![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png) Open main navigation Close main navigation - English - Australia Show submenu for translations - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [VetLink PRO](https://help.vetlinkpro.com/vetlinkpro) 2. [Support](https://help.vetlinkpro.com/vetlinkpro/support) 3. [Product](https://help.vetlinkpro.com/vetlinkpro/support#product) # Batch and Expiry for Vaccinations in Version 7 ## v7 In old version the batch and expiry was in the reminder screen ![](https://desk.zoho.com/support/ImageDisplay?downloadType=uploadedFile&fileName=1741746719449.png&blockId=edbsn1a8e277308ac600668f28db1fb0a6acdae8d8f87f91854d83206e856e8a2755f&zgId=edbsnd501c31592a49f357460c9f06b70c878&mode=view) 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. ![](https://desk.zoho.com/support/ImageDisplay?downloadType=uploadedFile&fileName=1741746614171.png&blockId=edbsnf2569c3942686e18edf8914f5ca696cb87151647c71038e446c08d74a5c6feac&zgId=edbsnd501c31592a49f357460c9f06b70c878&mode=view) ![](https://desk.zoho.com/support/ImageDisplay?downloadType=uploadedFile&fileName=1741746897592.png&blockId=edbsn6e7f37ae0872eb9d49383c36140a436ce30b7e535b7168e92c35243708566ecf&zgId=edbsnd501c31592a49f357460c9f06b70c878&mode=view) 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')) - [Support](https://help.vetlinkpro.com/vetlinkpro/support#main-content) - [Client Portal](https://help.vetlinkpro.com/vetlinkpro/support#client-portal) - [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors) - [Upgrade](https://help.vetlinkpro.com/vetlinkpro/support#upgrade) - [Payments](https://help.vetlinkpro.com/vetlinkpro/support#payments) - [Patient](https://help.vetlinkpro.com/vetlinkpro/support#patient) - [Product](https://help.vetlinkpro.com/vetlinkpro/support#product) - [Xero](https://help.vetlinkpro.com/vetlinkpro/support#xero) - [Clinical History](https://help.vetlinkpro.com/vetlinkpro/support#clinical-history) - [RDS Setup](https://help.vetlinkpro.com/vetlinkpro/support#rds-setup) - [Client](https://help.vetlinkpro.com/vetlinkpro/support#client) - [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary) - [Mailers](https://help.vetlinkpro.com/vetlinkpro/support#mailers) - [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports) - [Stocktake](https://help.vetlinkpro.com/vetlinkpro/support#stocktake) - [Reports](https://help.vetlinkpro.com/vetlinkpro/support#reports) - [EOP / Statements](https://help.vetlinkpro.com/vetlinkpro/support#eop-statements) - [Eforms / Digital Forms](https://help.vetlinkpro.com/vetlinkpro/support#eforms-digital-forms) - [Other](https://help.vetlinkpro.com/vetlinkpro/support#other) - [Printing](https://help.vetlinkpro.com/vetlinkpro/support#printing) - [Email](https://help.vetlinkpro.com/vetlinkpro/support#email) - [Server / Technical](https://help.vetlinkpro.com/vetlinkpro/support#server-technical) - [Insurance](https://help.vetlinkpro.com/vetlinkpro/support#insurance) - [Bill](https://help.vetlinkpro.com/vetlinkpro/support#bill) - [Vac Reminders](https://help.vetlinkpro.com/vetlinkpro/support#vac-reminders) - [Online Booking](https://help.vetlinkpro.com/vetlinkpro/support#online-booking) - [Mobile Billing](https://help.vetlinkpro.com/vetlinkpro/support#mobile-billing) - [Barcoding](https://help.vetlinkpro.com/vetlinkpro/support#barcoding) - [SMS](https://help.vetlinkpro.com/vetlinkpro/support#sms) - [General Ledger](https://help.vetlinkpro.com/vetlinkpro/support#general-ledger) - [Staff](https://help.vetlinkpro.com/vetlinkpro/support#staff) - [Telemedicine](https://help.vetlinkpro.com/vetlinkpro/support#telemedicine) - [Manual](https://help.vetlinkpro.com/vetlinkpro/manual#main-content) - [6.1](https://help.vetlinkpro.com/vetlinkpro/manual#6-1) - [7.0](https://help.vetlinkpro.com/vetlinkpro/manual#7-0) [![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png "Vetlinkpro - Intergrity - excellence - clarity")](https://www.vetlinkpro.com) [mailto:email@email.com](mailto:email@email.com) Copyright © 2026, VetlinkPRO