ID : 19401578
Greetings,
We are interested to work on this project, please find my comments inline with yours,
1)PO Database - Microsoft Access
Microsoft Access Database - PO Database
=>Ok, What version of MS Access you want to use ? Access 2013/2016 ? We can use MS Access as backend or SQL Server Express as backend. Let me know your preference
2)PO Request
=>Ok, We need to design form for this feature, to place the purchase order.
3)PO Department Mgr Approval/Rejection
=>Ok, For this we maintain separate flag for this in the table as approval for futher work flow if Department Mgr approve the order then this flag must be true.
4)PO Plant Mgr Approval/Rejection
=>Ok
5)Create PO
=>After the approval of order we need to make place of Purchase Order
6)Send PO
=>Ok, In which way you want to send the purchase Order through the email or SMS ? You want this feature also want to build from same application or manual send the SMS or email through your personal ID let me know?
7)Check Status
=>Ok, Whether the Approval of order is done or not and order placed is completed or not?
8)Create PO
=>Ok
9)Save PO
=>Ok
10)Send PO
=>Ok
11)Edit PO
=>Ok, After the edit of Purchase order we need to take approval of PO Department Mgr and PO Plant Mgr.
12)Store History
=>Ok, we can store above workflow or phases for each order in the table
13)User Access Levels
=>Ok
Waiting for Favorable Response
Regards,
[Sham Shrinivas Yemul]