Share
ReportHistory
Our team has put the ExplorerFormatCurrency=FALSE and SmarlistEnhancedExcelExport=TRUE INI settings in place for GP 2013 due to having currency export issues and decimal places being too long respectively.
Current Problem
Our A/R team runs SmartList to export statements to Excel that are uploaded to a customer portal showing their open invoices. In doing so they are prompted with an error in the “supplier invoice no” column. The initial format in this column was text. When they change the format of that column to general, they can upload it.
Last week one member uploaded 150 invoices. The customer informed her she uploaded the wrong PO #. She checked thru the Excel file and the format of the PO# column is also text, but she wasn’t prompted with any error when uploading like the one she got on the supplier invoice no issue. She re-uploaded some invoices after changing the format of the PO # to general and it works fine.
Question
Can you change the format in GP to “general” instead of using “text” for particular fields?
*This post is locked for comments
All responses (
Answers (
5,985
