Consolidating table info for Export Tool

So we have a customer that is requesting that when we Export the Table data...that we consolidate information that contains the same information. For example:

Table
Item # GL Code Location Amount
1234 5000.10 103 100.00
2345 5010.20 105 200.00
1234 4102.20 103 100.00
1234 5000.10 103 300.00


The Export would be the following:
1234 5000.10 103 400.00
2345 5010.20 105 200.00
1234 4102.20 103 100.00


As you can see, there were 2 rows that contained the same Item #, GL Code, and Location....so we combined them to 1 row for the Export and added the Total Amount.

Is this possible?

 

Dear Daryl Foxhoven! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-236471-S5C9K for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team

Hi Daryl,

as far as I know, DocuWare 7.10 does not have any functionality built-in for this.
I have the same problem in multiple customer systems, and my workaround is currently a custom C# application which uses the REST API to modify the data in the table fields.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant