Dynamics GP 2010 Historical AP Aging in SRS

Dynamics GP Historical AP Aging – SRS


After spending countless hours searching the internet and finally working with Microsoft – I wanted to share my findings on how to get the Historical AP Aging report in SRS to match what the GP version of the report has for balances.

  • You must be on GP 2010 SP 3 – anything prior to this, the Historical AP Aging has issues and will most likely not balance to your GL or the canned GP report
  • You will notice strange characters in the ‘To’ areas of most of the parameters – you don’t need to change these.  Unless you are specifically trying to exclude something.
  • The SRS report REQUIRES that you enter the from and to date (unlike the GP report that uses the Print/Age as of Date).  If you leave this defaulted to the dates already put in, you will get an aging with all transactions posted through today.

This last point was the one we kept overlooking.  Sometimes the answer is right in front of you!

Internet Explorer 10 Compatibility Mode

As Microsoft has deployed its latest browser, you may have some problems on some CRM websites. Turning on Compatibility Mode for these sites will allow them to function properly again.

In the browser menu bar, select Tools (If you don’t see the menu bar, tap the ALT key on your keyboard, now you should see all the menu options) then select Compatibility View Settings.

The website you are on will automatically be filled in at the Add this website dialog (if it is not, add the URL for your CRM server). Click the Add button. This will add your site to Compatibility Mode. Click Close and the site you were on should automatically reload in Compatibility Mode and work correctly.

Please refer to this Microsoft article for more details.

Giving access to Report Builder 3.0 in GP 2010

Permissions for Report Builder in GP 2010

1. Go to SSRS Report site ex: http://reportservername/reports¬_instance
2. Go to Site Settings in the upper right
3. Choose Security on the left nav bar
4. Add the user or group as DomainName\UserorGroupname
5. Select the “User Role”
6. Go to SQL Server Management Studio
7. Add user or group as SQL Login
8. Map new security login to the appropriate GP databases and assign DYNGROUP role.

Change Address on MaxQ MICR Checks in Dynamics SL


How do I change the address that prints on AP Checks printed using the MaxQ MICR check printing system in Dynamics SL?

In Dynamics SL, navigate to: Shared Information >> MaxQ Screens >> Bank Account Information.

You can change the address for each Bank Account as well as the account and routing numbers from this screen. You can also find this data in the database in the following table: xbankinfo

Hypervisor Virtual Machine Vanished from host.


A Virtual Machine on one of our Hyper-Visor hosts vanished. It was no longer listed. When I opened the Fail-Over cluster management console to see if it had failed over to another node it was marked as a failed service.

I checked the for the VM Configuration Files and the Virtual Hard Drives on the shared storage. All files existed.

After a quick Google search I found several articles pointing to a corrupt configuration file.

I opened the .xml file and sure enough a closing HTML tag was incomplete:

After closing the Hyper-Visor Console and reopening it on the host I was able to see the VM and restart it.

If the above doesn't work. Delete the virtual machine and recreate it. Here is how I do that:
1. Note the node that owns the virtual machine
2. In Fail-over Cluster Manager delete the resource.
3. On the Node that owns the missing virtual machine open Share and Storage Manager and go to Manage Open Files
4. Close all connection files and folders that have to do with the missing machines Configuration.
5. Rename the Configuration folder
6. On a Fail-over node create a new machine and pick the existing vhd file for the missing server.
7. Go to the settings of the new virtual machine and make sure it is set to migrate to machines with different hardware.
8. From Fail-over Cluster Manager add the new server
9. Start the new virtual machine
10. Connect to it from its Host
11. Set the IP address.

NOTE: If MS Office is installed you have to re-register it.

Syndicate content