At the beginning of my process I read an Excel file and store as a DT. One of the fields stored is the company number. For this example, I’ll use company 416. When I read the PDF I am getting the Total for each company in the PD.
I only need the total for the current company I’m dealing with (in this case the total for company 416 is 4,550.00.
I’ve been trying for hours to find a way to filter that but I haven’t been able to. Do you know what I’m missing? The section of the process is the sequence named “PAD.” Oper_FS No Commission V2.xaml (145.2 KB)
It was pretty difficult to understand the workflow, I add a flag to determine if the company number has been founded or not, also, if the Pad_Amount has been set (Is not null or empty) it exits the Do While activity
Here is the output for my process. It is finding the total for each company (which I need) but I need to figure out how to only return the total for the company I am working with. So, in this case, I want the total of $6,166.66 but I need to know it’s coming from company 414.
@msan was originally helping me out here so maybe he has an idea as well?
04/21/2020 08:58:24 => [Debug] Test started for activity: PAD
04/21/2020 08:58:26 => [Info] TA Recon execution started
04/21/2020 08:59:09 => [Info] Line= ACH/PAD/ACH Fee Paid Control Doc Print Date 04-21-2020
04/21/2020 08:59:09 => [Info] Line= Control Report Feeds Recon
04/21/2020 08:59:10 => [Info] Line= Co Fund PAD Sameday ACH ACH Fee Paid Sameday Late Sameday ACH Exception Sameday ACH ACH Fee Paid
04/21/2020 08:59:10 => [Info] Line= 405 031 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:11 => [Info] Line= TOTAL 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:11 => [Info] TOTAL: 500.00
04/21/2020 08:59:12 => [Info] Line= 414 001 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:12 => [Info] Line= 414 002 1,350.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:13 => [Info] Line= 414 003 200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:13 => [Info] Line= 414 004 2,916.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:14 => [Info] Line= 414 005 1,200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:15 => [Info] Line= TOTAL 6,166.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00
04/21/2020 08:59:15 => [Info] TOTAL: 6,166.66
@msan I seriously can’t thank you enough for all of your help with this. I don’t know where you live but I wish you were close by so I could take you out for a beer and thank you in person. If you ever find yourself in Kansas City, Missouri you’ve got yourself a friend, a place to stay and as many beers as you can drink!