Additional Tables in IDC

Has anyone found success using additional (secondary) tables in their IDC Document Form Definitions? We have only been using IDC/ECM for AP Invoice Automation, but are trying to find other ways we can utilize IDC. We are hoping to be able to use it to gather data from bills, but the hiccup is that some bills will have more information than others (albeit in a similar format). I was thinking I could add another table to collect different “rows” of data (that share a couple columns) and then export it as a CSV. However, when I set up the additional table, I have not been able to get it trained. The “header” fields come in quite reliably, but only one “detail” field at the most seems to be trained and pulls in fine. The other “detail” fields either pull in random information, or none at all. I’ve also marked those fields as required, yet when they are blank, the batch still passes verification.

Does anyone else use an additional table in their document form definition?

We’ve used multiple tables for capturing miscellaneous charges, but it has generally been a manual task to do so. As far as how data can be captured in multiple tables, I would suggest reviewing the UDT and stops available to better define tables in general. The Ancora website has documentation on all of this.

2 Likes

Thanks for the tip Victor! I turned that on and it magically started working (a lot quicker of a fix than I was expecting)! We’ll see if it keeps up as the documents get more complex, but it’s already looking a lot more promising now! I had looked in there yesterday and found some great information, but didn’t know to look for UDT

3 Likes