Posted Fri, 26 Jul 2024 14:34:57 GMT by Daryl Foxhoven
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?


 
Posted Sat, 03 Aug 2024 00:01:37 GMT by Matthias Wieland Senior Director Support EMEA
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
Posted Tue, 06 Aug 2024 07:56:42 GMT by Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
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

You must be signed in to post in this forum.