Posted Fri, 02 Aug 2019 13:39:24 GMT by Eric Bosworth IT Director
I currently use a spreadsheet that we print into docuware for purchase order requests. To import PO's into our accounting system we need to import a dozen or so fields that are unique to each PO, but in addition we need to import a quantity, description, price, program code, and general ledger code for each line item. We rarely fill out the entire form but we have the ability for up to 44 line items on a PO. At 5 indexes per line I already have a lot of indexes in this file cabinet. The spreadsheet we have has a drop down of the program description and general ledger description and the code populates from that. The same thing with the vendor code but since we might search for a vendor we already have an index field for both the vendor code and the vendor name. I created a view in the accounting system database that has the program description and the program code. I did the same with the GL code. I used that to create a 2 column select list that I would like to use in a form that has a drop down with the description and populates the index field with the code. Short of adding 88 index fields and indexing the description and then either auto indexing or doing a lookup in a workflow to fill in the code does anybody have a suggestion as to how I could achieve this? since the codes are integers I can't put the description in the code field and then change it in a workflow. I really don't want to add another 88 index fields.
Posted Fri, 02 Aug 2019 13:40:24 GMT by Matthias Wieland DocuWare Europe GmbH Sr. Director Support EMEA
Dear Eric Bosworth! It looks like the Community cannot answer your question. Thats why we have opened a Support Request with the Number SR-73139-Z0Y0T 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 solved the Support Request. With Best Regards, DocuWare Support Team
Posted Mon, 06 Jan 2020 19:30:40 GMT by Dave Cannon Solutions Specialist
Did this ever get resolved? I'd like to know myself
 

You must be signed in to post in this forum.