Skip to content


Payables Transaction entry – missing document number on non-numeric

Joyce VanJura asked 3 years ago
My data source to bring in Payables Transactions has a mix of numeric and string document/invoice numbers.  The string rows are showing but the document number field is blank when you preview the data.  I’ve tried moving the row to the top, reformatting the column to Text in excel, and put quotes around the string document numbers.  Any advice???
Joyce VanJura replied 3 years ago

Fixed this by creating a Schema File as part of the SmartConnect Map

If you would like to submit an answer or comment, please sign in to the eOne portal.