Partial Orders received
I have my database setup with tables for vendors, products, purchase orders and purchase order line items. As things are now I open a new po pick a vendor and then pick what products I need to order. When the products come in they are markd as recieved with the date they are received.
My problem is some of my vendors have been sending things in multiple shipments and many products are back ordered. I'm not sure how to set things up in my database to account for the partially recieved orders. Any help would be appreciated.