need to track lot numbers of ingredients used in batch assembly and assign lot numbers to finished product?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
We manufacture a packaged food product. We need to manage inventory of raw materials (recording lot numbers, received dates, & invoices). when the ingredients are used for batch production. Each ingredient lot number needs to be assigned to that batch and each batch needs to be given a unique number that is recorded on each case box (preferably in bar code label form). When a shipment is compiled, the unique numbers assigned to each product need to be assigned to the invoice.
Photo of Jan

Jan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,168 Points 50k badge 2x thumb
It sounds like there is some analysis required to lay out the best structure for your data.  It certainly sounds very "doable' in QuickBase.  There is a list of QuickBase developer partners here http://quickbase.intuit.com/partners or feel free to contact me via the information on my Community Forum profile or from that partner list under Your QuickBase Coach
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
The forum is best at answering focused questions concerning product features, 'how to questions' and technical questions. Your question is much broader and appears to ask how to build an application based on some spreadsheets you currently use in your workflow. I think you need to speak to a developer. Feel free to contact me using the information in my profile.