Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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
3