Versa Cloud ERP - Blog How to Manage Lot and Expiration Date Traceability Across Disconnected Inventory Systems  %Post Title, Versa Cloud ERP - Blog How to Manage Lot and Expiration Date Traceability Across Disconnected Inventory Systems  %Post Title,

How to Manage Lot and Expiration Date Traceability Across Disconnected Inventory Systems

Introduction: When Inventory Records Don’t Tell the Whole Story

In the event that a client calls regarding a bad seal on a product, he/she reads the lot number and wants to know if anyone else has experienced the same issue. This seems to be a question that should take five minutes. However, that is often not the case. Someone in the warehouse has to get the receiving document. Then someone else checks the orders. Accounting has the purchase order but without the lot number specified. After one hour there are three answers, which do not really match.

Of course, the stock level is correct. What was missing is the story behind it; which lot came in when, where it went, more importantly, where it was sent. If you do any type of business that involves batch numbers/expiration dates, you know this situation very well. Normally it does not raise issues until the time of inquiry arrives.

Why Lot and Expiration Date Traceability Breaks Down

Nobody sets out to have bad traceability. It builds up from small habits that made sense at the time.

A plethora of information occupies numerous locations

The lot number of the supplier is noted on the delivery slip, while the quantities are contained in the spreadsheet. The sales order has the name of the product, but the lot number is missing. Each record is correct in itself, and therefore, no one has any issues – until the employees are required to collate the different records to each other manually.

The expiration dates are challenging to be verified in the same way

At times, the date appears in the record. Other times, it is only on the label. Moreover, different people interpret the date “04/05/27” differently depending on the format of the dates. In cases when the date of expiry is located in a different place from the records that the employees work with every week, identifying which stock should be sold first becomes a challenging task.

Stock flows result in discrepancies

Arrival, transferring, collecting, dispatching, receiving back. All refer to the same stock. If one of them is registered belatedly or with another software program there will be a hole in it. Returning is the most difficult. Goods come back on a pallet and no one even mentions the lot number of goods on it.

Solving one stock problem takes much time

As soon as a claim is received, there are three speedily delivered answers: what is the matter, where is it, and what has already left. If this requires five people to answer the questions and several phone conversations, the investigation will cost more than the problem itself.

At this point, linked records come in handy. If invoices, transfers and orders can be found in the same banking system, it takes much less time and manual effort to get the required information.

What Businesses Need for Better Lot and Expiration Date Traceability

This can be initiated without any purchases. With the correct approach, a few habits can bring a huge benefit.

  • First of all, choose one of the methods of identification of lots – either the supplier’s lot number or your lot number or both. Otherwise, two people may be looking for one lot under the different numbers.
  • Combine receiving procedures with inventory methods. All information about the supplier, receipt date, product, and lot should be stored in one place, not on one sheet where only one person has access to.
  • Document all processes. Transfers and adjustments look boring but this is the place where mistakes usually occur.
  • When checking the dates in the plan, study what is scheduled for each week or each month and number the stock with approaching expiration dates.
  • Inform who conducts the checking. The name of one individual who carries out inspections and how he/she performs them should be mentioned in this document.

Most of what occurs takes place at the receiving dock. If the truck comes to the dock with products already in boxes, then the system will only be able to take note of what is input at the time the truck arrives. On an unfortunate day, dozens of boxes will not be accounted for and you may find this out months later. Hence, please allow more time to the receiving area as compared to usual.

How Versa Cloud ERP Helps Improve Inventory Traceability

Versa does not perform all operations in this regard, therefore everyone has to adhere to what is explained in the paperwork.

Lot numbers and transaction history

Versa can manage lot numbered inventory, as long as it is established that way and the user provides the number in the transactions. The inventory history allows you to see previously recorded operations without having to recreate them from various documents.

Stock visibility across facilities

Availability of inventories in various facilities enables companies to see the total amount of products and inventories available in order to track it without making inquiries everywhere.

Receiving, transferring and shipping in a chain

Receiving, storing, transferring, picking, packing and shipping are all stages in the inventory process of Versa that creates and maintains records for every stage of the process. Those records are the basis for any investigation or examination carried out.

Report preparation and record analysis

The data from the reports on inventory transactions is sufficient enough for records review and transaction trace and it is useful in investigations but it should not be considered as a substitute for investigations.

The Role of AI

AI is now an integral aspect of almost every ERP discussion, along with the amount of data that it is concurrently processing. Dirty lot data means dirty lot answers from the AI, though completed much faster. Thanks to Versa AI OpsEngine and its Digital Workers which work together with the operational data of your enterprise and Playbooks which help convert your written processes into the steps that can be executable. However, what a Digital Worker actually does depends on how it is configured and what are the rules assigned to it. Nevertheless, the final decision will always be made by your team.

Be advised that lot tracking is not equal to expiry monitoring. So if you need expiry alerts or date-based picking, you will need to ask the Versa team while you are in the process of making your assessment.

A Practical Example: Investigating an Inventory Lot

Going back to the customer experiencing trouble with the sealing. The sequence of actions taken can be summarized as follows:

  • Establish the lot. Use the number of the product installed and the lot number to locate the necessary information.
  • Check the previous history. Analyze documents, transfers, amendments and shipments.
  • Validate the existing stock. Check the amount of stock available and the warehouses it is stored in.
  • Compare the information from the system. Ensure that the received information is consistent and correct.
  • Make the conclusion. Adhere to the rules and standards of the company.

Versa provides records of the relevant lot and transactions. The company will determine whether it can continue selling the inventory.

Common Mistakes That Make Traceability Harder

  • Inconsistency in lot spelling. If one person types L-204 and another one types L204, the search will not go through.
  • Storing date data in side spreadsheets. That data is completely useless once someone forgets to update it.
  • Overlooking balances and transfers. That is where the counts go astray.
  • Trusting system counts blindly. Always verify with the actual shelf count.
  • Mixing lot tracking and expiry monitoring. They are similar but definitely different processes.
  • Having the software do the magic. If you do not input data properly, it will never be traceable.

Building a More Reliable Inventory Traceability Process

Commence with these.

  • Identify commodities that need to be monitored and controlled. Excessive monitoring implies more time spent by people.
  • One system that provides measures of commodities and dates. Regular pattern makes searching possible.
  • Use the same tracking methods in different venues. Different tracking methods do not permit to compare information.
  • Be alert about discrepancies. Small discrepancies are very easy to correct.
  • Clearly specify people responsible for investigation and assign them for the management.
  • Make sure to compare the existing and needed system.

When thinking about Versa, you must take into account aspects such as lot tracking, inventory traceability, warehousing activities, and other features that help you bring varieties of the same products from different plants together. However, for the use of the information on expiration dates, separate checks should be performed.

Final Thoughts

Traceability involves the use of the same identifiers and can involve the responsible keeping of records, as well as knowing how to deal with any eventual problems. Dates are part of the solution only. Do everything else well and the unhappy customer with a faulty seal will hear back within minutes, instead of half a day.

FAQs

What does lot traceability mean?

Lot traceability is keeping track of the whole batch of products throughout the distribution process from the moment it arrives at the warehouse to the moment it is shipped out, based on the lot number and records about it.

Is lot traceability the same as expiration date tracking?

No. Lot traceability refers to following certain batches, while expiration date tracking means keeping records of product expiration dates. One can have a system in place for one type of tracking but not necessarily for the second one, so check whether you have the necessary supporting tools for both types of tracking.

How do non-integrated software systems complicate traceability?

The records that correspond to the same batch get spread out in different locations, and the user has to perform matching processes for each batch manually each time.

How do we start tracking?

Start with receiving by agreeing on the format of lot numbers, date, and the person responsible for entering the latter.

Is Your Inventory Data Ready for the Next Question?

If details of lots, movements of goods and orders sit in different places, answering even simple questions becomes a long process. Thanks to Versa Cloud ERP, you can connect and organize all one data in one place.

Explore Versa Cloud ERP to see how it could fit your operations. Want to see it with your own workflow in mind?

Schedule an online demo.