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

  • Create another field which can identify this group order uniquely - Like Order Number – Amal Hashim Nov 8 '14 at 18:45
  • What is your question exactly ? – Arsalan Adam Khatri Nov 8 '14 at 19:11
  • Hi Amal, I didn't understand can you provide example please. – user3760253 Nov 8 '14 at 19:13
  • Hi Arsalan, My Question is for Example if order qty = 50 & Deliver Qty = 50 then fine user can enter the purchase date, deliver date,enter the deliver Qty then Balance Qty will show zero in SharePoint List.But if purchased Qty 50 is purchased in three different date like on 8th = 10 Qty, 12th = 20 Qty and 15th = Qty so here I'm not sure how to enter the details in SharePoint List. – user3760253 Nov 8 '14 at 19:30
  • Hi, Any help on this question please. – user3760253 Nov 10 '14 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.