Share
ReportHello,
I need some help fixing an issue we are having with the Letter Writing Assistant. We are using Dynamics GP 2015 and one of our HR staff recently encountered this issue when trying to prepare rejection letters for some recently interviewed applicants. These are the steps she follows:
1) She navigates to Reports > Letter Writing Assistant (and Next);
2) She clicks on Prepare the letters using an existing letter. (and Next);
3) She clicks on Applicant (and Next);
4) She selects Requisition Number from the dropdown list, enters the same requisition number in the From and To textboxes, and selects Rejected from the type of applicants to include (in fact, any type still produces the issue);
5) After clicking Next, she receives the error below:
SQL Error: 102 [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'andDYNAMICS'.
6) When she clicks OK, another window opens where she chooses the Decline option:
7) After clicking Next, the "Applicants to receive a letter" window displays with an empty list.
I'm guessing the SQL query fails to return the list of applicants who have been rejected for the specific requisition number. Has anyone encountered this issue and successfully fixed it?
Note: She can generate the letters individually through the Employee card but it would be much easier to pull the listing and generate the letters as a group using the assistant.
Thanks.
*This post is locked for comments
All responses (
Answers (
291,280
