Error: Incorrect syntax near the keyword ‘AND’

Product:  BizExcelerator
Applies to:  MAS 500
Article Type:  Error 

Summary:
When executing a BizInsight function an error message appears stating:

Incorrect syntax near the keyword ‘AND’

Details:
This error can occur if one or more the function’s required parameters is set to a wildcard instead of a value.

Resolution/Workaround:
Please refer to the BizInsight MAS500 Function Listing to confirm what parameters are optional.   If you have a wildcard for one of the required parameters, change that parameter so that it references a value.

If the provided Resolution/Workaround does not resolve your issues, please contact BizNet Software Support for further assistance.