How do you guys design your sharepoint list schemas for an invoice approval workflow?
System summary:
- Invoice is fed to the DU
- Before it is entered into the accounting system, it needs to get the approval of all approvers.
- Apps is used to design the approval page.
- Sharepoint is used to store all information about the invoice(static - number, po, vendor), including the invoice lines (table - description, quantity, amount), approval status, etc.
How do we design the schema in sharepoint to keep track of the approval status of multiple approvers, keep track of the changes in the invoice lines (each approver can add, modify, and delete in the table) and which approver did what?
Can you give me suggestions on how many list should we keep? What are the columns? And the best combination of UiPath features to use. Thank you.