GP 10 Analytical Accounting Data is Missing

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

Client has been using AA for years. I just happened to run an AA Smartlist today and we are missing quite a few transactions. They all appear to be payables transactions. When I run the Smartlist list the J/E numbers end at about 58,000. However the current J/E seed number is in excess of 80,000. I even tested entering a new payables transaction and then ran the Smartlist and it is not there. What should I check or what utility should I run to discover why the AP transactions are no longer hitting AA?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Mr. Richard

I just would like to make sure of one issue, is the problem related to smart list itself that is not showing the data which has already been posted properly, or the data is not there at all as AP transactions are no longer hitting the AA.

To make sure, I may kindly ask to run an SQL query of Journal Entry with AA details Look for a specific journal entry related to an AP transaction, does it have AA details, or not

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Mr. AlSaadi, that is the next step. To determine whether the AA records are missing form AAG30000. Stay tuned.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Richard,

Did you need the transaction details of AP trx from Sub legder or Main ledger?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I will be able to get back on their server today and I will find out what data is missing. I am concerned because it appears someone rolled back in an earlier copy of the DYNAMICS database and now they are getting duplicate key messages when doing AP transactions on AA tables. Now the AAG00102 table is out of sync.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

OK, the answer is the data is missing form the AA tables. Something happened after the close of 2012. Records are only being written to AA transaction tables sporadically. An example is:

You go to the Analytical Payables Transaction Zoom screen for one transaction from one vendor and I can find this transaction in the AA tables. I go to another transaction for the same vendor going to the same GL accounts and the zoom window will show what should be in the tables, but if you look in the AA tables(AAG30000 and AAG30001) there is no transaction. What am I seeing here? Is there anyway to create this records? What must I do to get new transactions to be written to the AA tables?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

In the AAG00500 table there are daily records for 2013 but none for 2014. So I am concerned that if these records missing who knows what other records are missing. Is there anyway to reinstall AA without losing any AA data? All the data prior to 2013 is there, but after 2012 is missing.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Any update on the resolution? This is a post that is getting a large number of views so we would like to get a confirmed resolution.

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Yes, we had to open a case with Microsoft. A lot of the issues were the results of the bugginess of AA with GP 10. We had to run scripts to force the open AA into history. After that, most of the AA functionality came back. If you want to gory details the case number was 114050811426560

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Thanks Richard. Just wanted to mark what was the answer so others would know if they searched for this.

Was this reply helpful? Yes No