I want to develop small purchase order system in SharePoint. I already started working on this but I stuck in below points where the purchased Qty is coming on different dates. For example :-
Order Qty = 100, Purchased Qty (Qty delivered more than one time in three different date like 20+20+60=100).
Now the list which I've created it's strait forward like below :-
Order Date,Purchased Date, Order Qty, Purchased Qty,Balance Qty (calculated),Status(Pending / Completed)
For this particular scenario the Qty was purchased in three lots (three different dates) so not sure how to archive this.
Please advice. Also if you have some link,steps for purchase order please provide