Jump to content

  • Quick Navigation
Photo

Inventory Tracking Process or Form


  • You cannot start a new topic
  • Please log in to reply
4 replies to this topic

#1 Quality Supervisor

Quality Supervisor

    Grade - Active

  • IFSQN Active
  • 18 posts
  • 4 thanks
3
Neutral

  • United States
    United States

Posted 08 March 2021 - 08:05 PM

Hello all! I am trying to find an simple way of inventory/distribution tactic or form for our company. We are a chocolate/candy confection company and for times like Easter, Christmas, and Valentines's Day, it can get very difficult to track specific items with lot codes (or all) to where they will be delivered. Our company is all hands-on with very little electronic inventory software (only for sales). I am looking for either a form or type of way that we can write down all the lot codes for a specific order. For an example, we are coming up on Easter, and a lot of our customers are from schools. How can we track an order or multiple orders for one customer with all the lot codes for the products? I know this may sound confusing to some, but at this point I have no way of doing a proper recall incase something happened. 



#2 Scampi

Scampi

    Fellow

  • IFSQN Fellow
  • 3,482 posts
  • 947 thanks
553
Excellent

  • Canada
    Canada
  • Gender:Not Telling

Posted 08 March 2021 - 09:15 PM

to be blunt-if you cannot perform a proper recall as of today, then you shouldn't be selling your product. It is part of your responsibility no matter the size of the company

 

There is lots of software out there that would allow you track inventory in and finished good out for under 10K (well under)

 

However, you need a spreadsheet instead

 

Yes, it will be a pain n the a** but you still need it

 

Sales Order #              Item #            Lot (more than 1I would assume)           Date of shipment              Quanity

 

That should be enough to allow for a recall failry quickly because you'll be able to filter by lot #s and know exactly where it all went


Please stop referring to me as Sir/sirs


#3 GreyeagleA

GreyeagleA

    Grade - Active

  • Newbie
  • 10 posts
  • 1 thanks
1
Neutral

  • Canada
    Canada

Posted 08 March 2021 - 11:06 PM

We are also a small operation and we use a spreadsheet for tracking the lot codes and it does make it much easier when doing traceability exercises.  It is time consuming but well worth it in the end.



Thanked by 1 Member:

#4 Spidey

Spidey

    Grade - MIFSQN

  • IFSQN Member
  • 126 posts
  • 35 thanks
45
Excellent

  • United States
    United States
  • Gender:Female

Posted 09 March 2021 - 12:58 AM

If your company uses QuickBooks, you can add the lot number as an item to track.  My company prints purchase orders with the name of the customer, the item name and number, and the quantity.  When the order is filled, the lot number(s) and date shipped are added to the sheet.  Then all of the information goes into QuickBooks, which allows you to search by product and gives you the lot numbers of all of that product sold in the time period specified by the search parameters.



Thanked by 1 Member:

#5 kfromNE

kfromNE

    Grade - PIFSQN

  • IFSQN Principal
  • 522 posts
  • 171 thanks
128
Excellent

  • United States
    United States
  • Gender:Female
  • Interests:Bicycling, reading, nutrition, trivia

Posted 09 March 2021 - 02:06 PM

The small company I used to work at - we also used QuickBooks along with our batch sheets. The batch sheets were paper copies with the lot numbers written on it.



Thanked by 1 Member:



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users