Hello,
Can someone help me out? This is kinda hard to explain so please bare with me
My situation:
We receive materials from overseas. These materials come in large containers. We have about 100 different part numbers at our warehouse which come in these large containers. We'll receive about 5-7 of these containers weekly. The trucking company will send over 3 to 4 containers to us daily so for example, day 1 we'll receive 3 containers and day 2 we'll receive 4 containers totally 7 containers for that week.
My issue is that each of these containers will contain several different part numbers. The way pack these containers make no sense either to be honest. They'll send several different part numbers in each containers with many repeats. For example, container one will have part numbers 1, 2, 3, 4 and 5 while containers two will have part numbers 1, 2, 3, 7 and 8 and etc. Also, each container will have varying quantities of each part numbers which make it even more difficult.
I need to make a database that tracks the total quantity of each part numbers coming in these containers each time they come. The database has to have each container number, each part number and in which container they came in, total quantity for each part and the arrival date of the container.
Please help
Hope this made sense....
Thank you!