Could anyone help me to understand how can we update statuses in 2 different datatable. First datatable is the input file in excel with all the transactions, It will have PO#, Invoice#, subtotal, Tax and Total Amount. The PO# can have multiple invoices.
Second datatable is the summary of Invoices with the Total Amount as aggregate.
For e.g. In one invoice, there can be multiple line items i.e. Line1, line2 and so on which is dt1. one tab will contain the invoice transaction details and another tab will contain Invoice Total which is dt23. For dt1 loop I’m updating the details in the portal and then updating the status in dt1. Post updating all the transactions for invoice, and then I’m comparing the Total amount of dt2 with the portal amount. Please advise how can i update 2 statuses in 2 different tabs in excel using uipath.
any help would be greatly appreciated!