Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Auto Calculation of 2/3 shelf life for Medical items.
Dear Team,
I have a below requirement from one of the Pharmacy Supplies customer.
Customer is dealingall the items with expiry date. Normal expiry dates are working fine but they wants to add a customized field of Shelf Life (Date), which will work on a calculation of 2/3 of expiry date.
Basically, while they receive PO from netsuite, they will add manufacturing date of the medicine, which will auto calculate 2/3 of shelf life depending on the expiry date.
for eg lets say medicine has a period 1 of year between manufacturing and expiry date, so while receiving a medicine user will add manufacturing date as well as expiry date and system should auto calculate 2/3 of shelf life for that particular lot/item