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
Completed
Comments
Many Note fields allow non-printing characters that later cause issues in SmartList Export to Excel.
Category: Financials - Accounts Payable
Theresa Nistler (administrator) on 6/13/2024 7:35:33 PM
This is completed in the 18.7 Release, October 2024
Dynamics GP Resource Directory - Dynamics GP | Microsoft Learn
Thanks
Terry Heley
Microsoft