Dynamics GP Historical Aged Trial Balances and Multicurrency

(0) Share

Report

Posted on by Community Member

Hello:

We are on GP 2010 (11.00.2197). An end user of ours at one of our European offices has mentioned that both the payables and receivables historical aged trial balances are showing invoices that have been paid and, therefore, applied a long time ago yet are appearing on these reports.

These documents do not show in the GP SmartList. So, this end user is using SmartList rather than aging reports, in order to ensure accurate reporting.

The "dollar" amounts are in foreign currency and I believe, specifically, in British pounds.

I seem to recall Microsoft, at one time, saying that there is a bug with these trial balances that has to do with Multicurrency.

Does anyone know if, indeed, this is the case? And, if so, is this fixed in a service pack or later version? We plan to upgrade to GP 2013 R2, soon.

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Lyn Barr 1 on at

Like (0)

Report

I am not aware of a bug like this, but is this user running a modified version of the trial balance, or the original version? If they are running a modified version, try the canned version. If they are already running the canned version, and a modified version exists, have them try that. It is possible that this would resolve your issue.

You can check whether they are using a modified version by going to Microsoft Dynamics GP >> Tools >> Setup >> System >> Alternate/modified Forms & Reports. Enter the system password, if prompted. Lookup & select the ID (most folks only have one set up).

Set the "Type" = REPORTS, then in the lower section of the window, expand Sales. Look to see if any version of RM Aged Trial Balance is listed. (There are multiple versions) Expand any you see, and note whether or not they are set to the modified version.

Post back if you have questions or problems!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Lyn:

Thank you, for the response, but neither the payables nor the receivables report is modified.

John

Was this reply helpful? Yes No
Lyn Barr 1 on at

Like (0)

Report

In that case, the next thing I would do would be to run through various iterations of the Reconcile utilities for payables and receivables, as well as Check Links on both modules.

In the Reconcile screens, I believe there are 5 different options you can run through (customer info, outstanding balances, calendar year, etc).

Microsoft Dynamics GP >> Tools >> Utilities >> Purchasing >> Reconcile

Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile

Microsoft Dynamics GP >> Maintenance >> Check Links

If you need detailed steps for these processes, let me know and I can provide them.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (2)

Report

Hello John

Nothing more valuable to add up to what's mentioned above by Lyn. Although, I would like to have another quality check on the data by running the HATB report from SQL. The scripts are provided on this link (this is primarily for the AP module)

If you don't have the know-how for running such scripts, you might need to consult the technical department to have the results for you.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (1)

Report

John what amounts are showing ? Are they the full amount of the invocies or only partials?

If only partials could it be a difference between the Functional and Reporting currency or some residual left between the Original Value and the Paid Amount where the currency valuation might have changed.

Where I am going - Invoice issued 20,000 GBP and reported in US as 24,000 US. Payment comes and is for a different value due to a change in the exchange rate from the time the invoice was entered to the time when it was paid.

Lyn has you looking at the data for corruption, here is look at the data for changes.

Was this reply helpful? Yes No
Lyn Barr 1 on at

Like (1)

Report

Good point, Bill, thanks for the input!

Multicurrency is a weak area for me. Might the Revaluation routine resolve this issue, if that is what is causing his reporting dilemma?

~Lyn

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

First of all, I want to thank all of you for your posts! I'm very thankful to have friends in the Community willing to help me, during this trying time that I'm going through.

With that being said, here is what I'm being told by my end users who are pointing out this issue.

They say that they have already tried the various file maintenance procedures.

Further, they say that they have already looked into the possibility of currency fluctuations in "timing differences" for payments. They indicate that this is not the cause.

Too, they say that they don't reference the Reporting Currency in their reports.

I did advise them of the SQL scripts that can be run to generate this reporting in, say, SQL Reporting Services. I may have to go this route, eventually, since they say that the data is showing correctly everywhere else in GP including in SmartList.

There must be an issue of some sort with these HATB reports. Is there any possibility of a bug?

We're going to soon be upgrading to GP 2013 R2. Would there be any possibility of the reports working, after the upgrade?

Thanks, again!

John

Was this reply helpful? Yes No