I have been selling products that are serialized for a while and I recently had a recall notice sent to me by a vendor for several ranges of serial numbers of some of the items we sell.
How can I find out which customers I shipped these defective serial numbers?
This is one of those issues that I never considered when setting everything up. There are also products that we manufacture that uses batch numbers. I guess I should have way to track those down as well just in case we get some defective raw materials in the future that are then made into finished products.
Has anyone ever done this before?
Can anyone share a way to accomplish this huge task without having to examine each and every sales order/invoice from the past 3 years one at a time?
I would greatly appreciate advice from anyone that managed to do this in ERPNext.
Thanks in advance for your generous advice.
~BKM