I've got two things going on here and I'm not sure whether or not they're related.
First, my customer has a GL trial balance created in management reporter. It's a very simple report. The row definition has two lines: the first one pulls in the range of balance sheet account numbers and the second one pulls in the range of income statement account numbers. When I click into the trial balance, for the most part it sorts by natural account however some accounts come in out of order. I've already verified that the "Sort by natural or main segment" box has been checked off (in report definition | settings | account & transaction detail) but it doesn't seem to have any effect on the sorting and account numbers still come in out of order.
Second, any time I have a column definition that pulls in the account string, I get an extra separator after the account number. For example, if my AP account is 2000-000, it would show up in all MR reports as "2000-000-" in MR. I'm crossing my fingers that this isn't related to how I set up sorting when we first installed GP and ran the utilities.
Any ideas on either of the above?
We're running GP 2013 R2 with MR version 2.1.9001.11
*This post is locked for comments
I have the same question (0)