Zydeceltico
Registered User.
- Local time
- Today, 10:38
- Joined
- Dec 5, 2017
- Messages
- 843
Hi all -
Now I've been tasked with updating a Parts Receiving database. What it really means is a table rework.
I have it mostly worked out but I am unsure of a "best practice" to accommodate partial PO shipments. We buy small hardware from outside sources in quantities in the tens of thousands. This would all be on one PO.
But the shipments might come in lots of 2000 or something and they'll show up on different dates until the total quantity of the PO is reached.
So we may issue a single PO for 20,000 widgets and receive 5,000 on 6/1; 10,000 of them on 6/17; and 5,000 of them on 10/31.
Before I blindly dive too deep into this I thought I would get request some sage advice from those who may have trod a similar road before.
Thanks a bunch for any and all insight and/or direction,
Tim
Now I've been tasked with updating a Parts Receiving database. What it really means is a table rework.
I have it mostly worked out but I am unsure of a "best practice" to accommodate partial PO shipments. We buy small hardware from outside sources in quantities in the tens of thousands. This would all be on one PO.
But the shipments might come in lots of 2000 or something and they'll show up on different dates until the total quantity of the PO is reached.
So we may issue a single PO for 20,000 widgets and receive 5,000 on 6/1; 10,000 of them on 6/17; and 5,000 of them on 10/31.
Before I blindly dive too deep into this I thought I would get request some sage advice from those who may have trod a similar road before.
Thanks a bunch for any and all insight and/or direction,
Tim