Re: problem value generated in microsoft ERP management reporter YTD periods in credit and debit
Thanks for the update Desmond and for checking the version of the client and server. Did you also check the version of provider? There are three components that need to be in sync. To check the version of the provider browse to C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0\Providers
Dynamics GP 11.0. Right click the Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.dll. On the Details tab the Product version should also be the same as client and server.
If you change the column type to periodic do the DR and CR column restrictions work? I just tested this and it apperas to be working fine for me, so it shouldn't be a bug. I have two YTD columns, the first with DR column restriction, the second with a CR column restriction. Is this the same setup you are referring to?
For the 13th period, do you have two closing periods? If you have two closing periods in GP, there is an outstanding issue on the report generating.
One more thing to look at is the Event Viewer on the server and see if it provides more detail regarding the underlying cause. If you see something please share it.
If none of these work, then it may be best to open a support case so they can look at the issue in more detail.
Thanks,
April