Several of our Dynamics GP customers who have deployed the Binary Stream Multi-Entity module have experienced a random sort order when attempting to use the Segment Range parameter on their SSRS MEM trial balance reports. This can be very frustrating when you have to scroll to find the first and last accounts.
This stored procedure can be quickly modified with an order clause to correct the sorting for all MEM trial balance reports. Make a backup of the company database and then right click on the stored procedure and select modify. Scroll to the end of the stored procedure in the new query window and add “order by SegmentListing”.
You will need to modify the stored procedure for all company databases where MEM is being used if you want to sort the segment ranges properly.
For more information about Microsoft Dynamics GP, contact our experts at RSM 855-437-7201