RELATION: LOT NUMBER - QUALITY OR CLASS - INVENTORY

Get new comments by email
You can cancel email alerts at anytime.
Comments (1)

Louis in Murcia, Spain

19 months ago

I'm software engineer, I'm designing a database for registering production process of a sort of product. I'm in doubt about whether to take into consideration the classification of a Product before assing its LOT number or vice versa? Lets say cases a) and b):
a) If PRODUCT-A, for instance, obtains a lot number LOT-1 before classifing it, then that LOT will contain all classes of PRODUCT-A, lets say CLASS-A, B, C, and PRODUCT-A will be included in inventory as only one item, so a further process of classification should divide that production into three parts, one for each class.
b) The other approach is to obtain PRODUCT A, classify it in CLASS-A,B,C, assign lot numbers LOT-1,LOT-2,LOT-3, one for each class and then inventory three lots as three items.

Which one should be the more advisable approach, taking into consideration registration and further quality, or invoicing or any subsequent process ?
Thanks a lot for your comments,
Regards,
Louis.

- Was this comment helpful? Yes / No Reply - Report abuse

Your Reply

change location - create a profile
User Name
 in Beverly Hills, California
Your Comment
Your Email Address
Enter the numbers you see in the box
CAPTCHA Image

Be Reasonable! Be Polite! Please read our Terms of Service and Forum Rules, where it notes that you are responsible for your own comments. You may post anonymously - but we reserve the right to remove inappropriate comments at any time.

RSS Feed Icon Subscribe to this discussion as an RSS feed.