Hi guys,
First time posting, and while I'm familiar with SQL, it's my first time trying the Query Wizard in SAP B1.
I'm experiencing a problem where, on Step 4 of 5, I want a condition that says IF Business Partner EQUALS "some name" (I'm not actually using quotations around the string, but I tried that and it didn't work either). However, if I try and insert a string in the "Field / Value" field, I receive an error "Invalid Field [Message 10-47]".
Do I need to escape the string with quotations, hash, or some other tag? I can only select another field as a variable.
The only help on this was from the SAP Help files:
http://help.sap.com/saphelp_sbo2005asp1/helpdata/en/b4/cdd46f2206414b9a667ce2a004fe60/content.htm
where it says I can query against a string or a number.
I also haven't been able to find any further help on the forums, so hopefully this isn't a duplicate n00b post.
Thanks for the help!
James.