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
Manufacturing date (01-01-2020) and Expiry Date (12-12-2020) = Shelf life (31-08-2020)
Can you please help me to get the desired result.
Regards,
Shahid Ansari