Batch/Lot Recall

This report shows Customers, Stock On Hand and Suppliers of selected product lots and batches. Use this feature to track your lot/batch/serial number usage from Purchase/manufacturing through to Sell. Prepare recall letters for customers in case of a Recall event.


NOTE: A product will only appear in the Batch/Lot Recall dropdown selection list if it has been sold. If you need to trace the stocks, utilise the Inventory Movement Details Report instead. 



Check Customers

[back to top]


Enter a product name, batch number, lot number or serial number to bring up a dropdown list of options. Select Show to display results. All customers with an affected sale order, fulfilled or unfulfilled, will be displayed on the Customers tab. Customers who bought finished goods which include the recalled product will also be listed here.



Customers who bought the recalled product will be listed along with their contact details, the quantity sold and the task reference link. Customer data can be exported in CSV format by clicking Export


Send a recall letter

[back to top]


Click Print -> Recall Letter to download recall letters for every affected customer in docx format. Only customers whose sale was fulfilled will be included in the recall letter. 



Recall Letter templates can be customised from Settings -> Document and Email templates. See Manage Document and Email templates for more information. 


Check Stock on Hand

[back to top]


Enter a product name, batch number, lot number or serial number to bring up a dropdown list of options. Select Show to display results. 


All locations with quantities of the recalled product will be displayed, including on hand quantities and any allocated quantities. Finished goods which include the recalled product will also be listed here. Stock on Hand data can be exported in CSV format by clicking Export.



Check Suppliers

[back to top]


Enter a product name, batch number, lot number or serial number to bring up a dropdown list of options. Select Show to display results. Suppliers who sold the recalled quantity, their contact details, and quantity sold will be displayed. 



All suppliers who supplied the recalled products are displayed with their contact details. 


FAQs

[back to top]


How can I add sales task ID or invoice numbers to the lot recall letter template? I can not find required mergefield value in your mailmerge fileds manual.

Unfortunately no customisation mailmerge fields are available for Recall Letter template, user can only customise text if required. This can be raised as a feature request on our forum and considered for future development releases. 


Can we search for a serial number without using the SKU first?  In Lot Recall it only allows me to put in a part number then go to the serial number. I would prefer to search by serial number.

If you will be using the Lot Recall  report, then that's how it is at this stage, you will have to enter the SKU and then the part number/serial number.  You may also try to go to the Product Availability page, and type the serial number in the search area, as it is possible to search per serial number in that page. This can be raised as a feature request on our forum and considered for future development releases. 


Can you tell me why this report is not showing any supplier for this product whereas it is showing stock on hand as well as finished goods records and sales orders for customers?

If the units came from stock adjustment, there will be no supplier attached to the batch and thus no supplier details will show on Lot Recall. 


How can I create a report which shows which product /LOT number was sold when to which customer?

Unfortunately there is no report that can provide you a list of orders with Lot numbers attached. This can be raised as a feature request on our forum and considered for future development releases. You can run a Customer Order by Product report, this report will provide product ordered by customer however Lot number is not provided.


Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.