Hi,
I am exploring the RPA options for the following reqs.
Automation of the invoice and Purchase order checking and entering data into D365 F&O and handling variance exceptions. Currently, the invoices and purchase orders get emailed to Accounts payable team.
For this automation,
1. Probably a power app page or portal can be setup where staff can add invoice and respective purchase order. This can get stored in Dataverse (cloud) or in a sharepoint (online) or in an on premise server. This will be based on the client preference as a cost will be involved for cloud storage.
2. The RPA tool then checks whether the invoice and PO are stored in Cloud or On prem matches. If yes, then make entry into D365 F&o system.
Can Power automate achieve the above? Can it talk to on prem and cloud? Can it handle exceptions?
What is the license cost involved? We already got the D365 F&O license in place.
Thanks in advance
Ven