select by transaction date
I am trying to select the transaction value if the based on the transaction type and if the transaction is within a date range so I am trying to create a calculated field. As an example, on the selection from the PM Paid Transaction History table in Dynamics GP, I need the transaction amount to equal the transaction amount if the selection is where doctype = 6 and posteddt > ‘1/1/2013’ and posteddt ‘1/1/2013’ and posteddt < '12/31/2013' and voided = 1 I keep getting an invalid syntax error with every different scenario I use but the SQL query returns correct information in SQL Management query.
Can you export you SmartList Builder setup and send it to me at firstname.lastname@example.org
If you would like to submit an answer or comment, please sign in to the eOne portal.