Publié Tue, 18 Dec 2018 15:38:20 GMT par John Garrison System Admin

Trying to pull the check number and place on the invoice.  Currently the check is for either single or multple invoices. 

So on the check it has an invoice number of   123456    (or)  123456 123457 123458

in my autoindex, match data there is an 'is equal' expression but that only pulls in the first index.  That is the only express that seems to be available. Is there a way to expand that match to a contains?

Publié Thu, 27 Dec 2018 19:16:57 GMT par Casey Miller Director of Technical Services

John, it has to be equal because it needs to be an exact match. Are you using a file connection, DB, or File Cabinet? The best way to do this would be to get an export not on the check infromation but on the invoice information. Hopefully the system you are getting this from would have the check number that paid that invoice. This way you have a list of invoices and then a column that would show what check paid that invoice. Then just do a match on invoice number and vendor number/name and pull in the check number from the column. 

OR are you saying that is what you have but the invoice column has multiple values in it? If this is the case, not sure what you could do.. If they have commas or other separation values you could do some manipulation in excel..

Publié Fri, 28 Dec 2018 14:15:07 GMT par John Garrison System Admin

Right now the invoices are being imported using Intelligent indexing from the tray.   I guess there is no way to get that done.   THank you for the response.

You must be signed in to post in this forum.