Match amount with Split Receipt amount with final receipt amount and update status as matched

Help Studio
, ,
1

image
image1305×392 23.8 KB

Sheet1 split receipt amount need to match with the sheet2 consolidated receipt amount. Quick help will be highly appreciated. Thanks!

2

In general it look like

  • group all Sheet1 data by Receipt No
  • Calculate the group member sum of the amounts

Then

  • check if sheet2 amount is matching the summed up amount from above for the receipt No
  • update Sheet1 rows of the checked Receipt No
3

Thanks for the quick response. It would be great if provide the workflow if possible as I am new in the UiPath.