Hello all.
Trying to solve a bit of an issue. Getting ready to update some software that creates PDF documents. In the past we had a file name of "INV_CUSTCO_#PrintDate#_#InvoiceNumber#" (break down below) but due to some aging software and compatibility issues, our new process will only create a file name of "#InvoiceNumber#".
Is there a method I could take that file name "#InvoiceNumber#" and run a sql query to pull in the the CUSTCO field? Not even sure if this is possible.
"INV_CUSTCO_#PrintDate#_#InvoiceNumber#"
-INV - static field
-CUSTCO - customer code - pull from a sql database
-#PrintDate# - date printed - can be a pulled from the file
- invoice number - primary key in a sql database
APPRECIATE ANY HELP!