We are seeing an issue where we want to change the sort on the Precheck Report by Lastname, FirstName, then MiddleName. It seems like the sort will work but the issue seems to be when it runs into a duplicate LastName (goes to the secondary sort method). It triggers the report footer to print and then it continues on with the rest of the employees. So the Report totals aren't at the bottom of the report but where the first duplicate lastname is.
Has any come across this issue before or any suggestions?
I just modified my report to sort like you mentioned. I went into report writer and put in a custom sort by Last Name, First Name, Middle Name. I then created several employees with the same last names, the same last and first names, some with and without a middle name. It behaved perfectly. If you still have a problem, I'll be happy to take a peek at your package file if you want to send it to me.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
The only question I have about your report is whether you want the amounts listed by each customer to represent the receivable net of available discounts or just the base receivable?
I am having the same issue with a client when they modified the Precheck Report to sort by SS#. They have some employees that have their SS # as the Employee ID and that seems to be what is triggering the report totals after that employee. Have you found any solutions to your sort issue?
As Lessie said. She has been modified the report with custom sorting options and everything working fine. If you attach the package file of your modified report, this would be helps us resolve the issue.
Hope this helps!!!
Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.
Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts
Thanks for the reply. My client has added a sort by the SS#. When they calculate a small batch the report prints with the totals at the end but when they have a full payroll and the report is 400-600 pages the totals print somehere in the middle of the report.
For small batch report, Is the report print with single page?
No, when I tested it my report was around 30 pages.
As Soma suggested, it's really difficult to troubleshoot your report without actually seeing a copy of it. If you will e-mail the package file containing the modified report, I will be happy to look at it. My e-mail is email@example.com
Has anyone found the fix for this? I am running into a similar issue.
We need to sort this report and other payroll reports by last name also. Report Writer gives us the problems described. Before we go down the path of creating a custom report just to resolve the sorting issue, wanted to see if there are any alternatives that can be offered by anyone?