Minty
AWF VIP
- Local time
- Today, 00:39
- Joined
- Jul 26, 2013
- Messages
- 10,708
I'm sure this has been mentioned before, but your design is deeply flawed, as you have discovered by the way you need to try and display your data.
Ideally you should have a PartsList, with your part numbers and descriptions in it. You should then have a stock movement record, this should record the ins(+) and outs( - )
Your stock quantity is then simply sum of your ins and outs per item.
You are also mixing two types of stock - Serial numbered stock and non serial numbered multiples, as you have discovered dealing with these in one list just doesn't really work.
If a majority of your items have a serial number then treat them all as single items so each item is a single entity - quantity = 1.
Ideally you should have a PartsList, with your part numbers and descriptions in it. You should then have a stock movement record, this should record the ins(+) and outs( - )
Your stock quantity is then simply sum of your ins and outs per item.
You are also mixing two types of stock - Serial numbered stock and non serial numbered multiples, as you have discovered dealing with these in one list just doesn't really work.
If a majority of your items have a serial number then treat them all as single items so each item is a single entity - quantity = 1.
