23
The Voucher Number field allows the user to enter special characters in it. There are no repercussions until later when the user tries to run the HATB report. Then they will receive SQL Errors.
If GP is not designed to handle this, then I think there should be a restriction on what is allowed on the Voucher Number field when the user is entering the data.
SQL Error:
"Unclosed quotation mark after the character string ‘ and DocumentType = 6’ Incorrect Syntax near ‘XXXXX’"
If GP is not designed to handle this, then I think there should be a restriction on what is allowed on the Voucher Number field when the user is entering the data.
SQL Error:
"Unclosed quotation mark after the character string ‘ and DocumentType = 6’ Incorrect Syntax near ‘XXXXX’"
STATUS DETAILS
Under Review
Comments
Many Note fields allow non-printing characters that later cause issues in SmartList Export to Excel.
Category: Financials - Accounts Payable
Theresa Nistler (administrator)
Thank you for your suggestion. We will consider this functionality for a future release.
Best regards.