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’"
Under Review
Ideas Administrator

Thank you for your suggestion. We will consider this functionality for a future release.  

Best regards. 



Many Note fields allow non-printing characters that later cause issues in SmartList Export to Excel.

Category: Financials - Accounts Payable