Thanks to all the participants in the Microsoft Dynamics GP Community who made this possible.
Monday, February 9, 2015
Dynamics GP Microsoft Community Contributor
I was recently informed I was named a Dynamics GP Microsoft Community Contributor.
Thanks to all the participants in the Microsoft Dynamics GP Community who made this possible.
Thanks to all the participants in the Microsoft Dynamics GP Community who made this possible.
Tuesday, February 3, 2015
The GL Account Link in Row % Combined with the Acct Mask Specified in the Reporting Tree do not Make Up a Valid GL Account
If you've followed this link and/or otherwise found this post, you are probably dealing with the following error:
"FRx Reporting Engine
The GL Account link in row % combined with the Acct Mask specified in the reporting tree do not make up a valid GL account. Verify that the link in the row format does not include mask characters (such as #, &, or -). If you are subtracting accounts, make sure that the subtracted account is included in parentheses.
Account Mask in the tree: &&&&&????
Link in the row format: %
If you continue, this row will be left blank. Do you want to continue generating the report?"
KB966649
According to KB966649 This error is caused because the Viewpoint General Ledger is upgraded to Viewpoint 6.0.1 and the version of Microsoft FRx is not compatible with the newer Viewpoint version. Microsoft FRx version 6.7.9111 or above is only certified with Viewpoint 6.0.1.
PROBLEM - my client is already on 6.7.9111
Actual cause... account format mismatch!
Clues:
1. No Reporting Tree was in use.
2. The error occurred for the first and all subsequent rows in the row format.
3. The Report worked fine for another company/entity.
4. The Account mask referenced by the error was actually &&&?????
For the uninitiated, in FRx, account masks for account components/formats are & and ?
The & character is the substitute for any Main Account character and the ? character is the substitute for an sub-account character (a.k.a. wildcards).
The actual account format for this company should have been ???&&&&&, the first segment being location, the second being the main account; however, when the Account Format was initially configured for this company, the user accepted the default account settings, which made the Location segment the Main segment.
In order to fix this, you need exclusive access to the database. In Tools > Setup > Company > Account Format, choose the actual main account segment in the Main Segment drop-down list. You will be prompted to run Check Links maintenance on the Account Master file. I took the extra precaution of rebuilding the GL index in FRx, as I assumed this would prove necessary. It worked like a charm.
"FRx Reporting Engine
The GL Account link in row % combined with the Acct Mask specified in the reporting tree do not make up a valid GL account. Verify that the link in the row format does not include mask characters (such as #, &, or -). If you are subtracting accounts, make sure that the subtracted account is included in parentheses.
Account Mask in the tree: &&&&&????
Link in the row format: %
If you continue, this row will be left blank. Do you want to continue generating the report?"
KB966649
According to KB966649 This error is caused because the Viewpoint General Ledger is upgraded to Viewpoint 6.0.1 and the version of Microsoft FRx is not compatible with the newer Viewpoint version. Microsoft FRx version 6.7.9111 or above is only certified with Viewpoint 6.0.1.
PROBLEM - my client is already on 6.7.9111
Actual cause... account format mismatch!
Clues:
1. No Reporting Tree was in use.
2. The error occurred for the first and all subsequent rows in the row format.
3. The Report worked fine for another company/entity.
4. The Account mask referenced by the error was actually &&&?????
For the uninitiated, in FRx, account masks for account components/formats are & and ?
The & character is the substitute for any Main Account character and the ? character is the substitute for an sub-account character (a.k.a. wildcards).
The actual account format for this company should have been ???&&&&&, the first segment being location, the second being the main account; however, when the Account Format was initially configured for this company, the user accepted the default account settings, which made the Location segment the Main segment.
In order to fix this, you need exclusive access to the database. In Tools > Setup > Company > Account Format, choose the actual main account segment in the Main Segment drop-down list. You will be prompted to run Check Links maintenance on the Account Master file. I took the extra precaution of rebuilding the GL index in FRx, as I assumed this would prove necessary. It worked like a charm.
Monday, January 5, 2015
Adding Rows to the Management Reporter Dimension Window
First, an acknowledgement. This issue only comes up in scenarios where users of Management Reporter have very complex equations on a single row.
A client recently ran into a problem with Management Reporter, I’ve only seen once before. I couldn't find my notes on this problem, so I had to rework the solution. Now I’ve had to resolve it again, I thought I would save anyone with the same issue the time. Here’s an overview of the issue and resolution. I hope you might find this helpful.
What's the best way to add new rows within the Management Reporter Dimensions window? In this window, you can define the rows, segments and other dimensions included in a row format. The problem is, after you put in a few lines, you seem to run out of room. The good news, is you’re not out of room, it’s just the interface is poorly designed - Microsoft really should do something about this... wink
You will notice at the top of the window, similar to Excel, you have a Cell field, which shows the extended “equation”. You can enter additional information into the Cell, and it will create new lines in the Dimension window, so you can continue to add unlimited lines in this window.
For example, I added accounts one by one, into the window (1500, 1600, 1700… until I ran out of room. I then went to the equation cell and added manually +Segment1 = [1800], and when I opened the Dimension window, there was a new line with +Segment1 = [1800]. I was then able to edit this line to include any dimension I wanted.
So, you have two options, use the example of a similar dimension to manually add the specific dimension you want to add, or use a very basic “dummy” input to add new rows for editing.
A client recently ran into a problem with Management Reporter, I’ve only seen once before. I couldn't find my notes on this problem, so I had to rework the solution. Now I’ve had to resolve it again, I thought I would save anyone with the same issue the time. Here’s an overview of the issue and resolution. I hope you might find this helpful.
What's the best way to add new rows within the Management Reporter Dimensions window? In this window, you can define the rows, segments and other dimensions included in a row format. The problem is, after you put in a few lines, you seem to run out of room. The good news, is you’re not out of room, it’s just the interface is poorly designed - Microsoft really should do something about this... wink
You will notice at the top of the window, similar to Excel, you have a Cell field, which shows the extended “equation”. You can enter additional information into the Cell, and it will create new lines in the Dimension window, so you can continue to add unlimited lines in this window.
For example, I added accounts one by one, into the window (1500, 1600, 1700… until I ran out of room. I then went to the equation cell and added manually +Segment1 = [1800], and when I opened the Dimension window, there was a new line with +Segment1 = [1800]. I was then able to edit this line to include any dimension I wanted.
So, you have two options, use the example of a similar dimension to manually add the specific dimension you want to add, or use a very basic “dummy” input to add new rows for editing.
Subscribe to:
Comments (Atom)