Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 10 Analytical Accou...
Microsoft Dynamics GP (Archived)

GP 10 Analytical Accounting Data is Missing

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730
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

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 10 Analytical Accounting Data is Missing

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

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 10 Analytical Accounting Data is Missing

    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

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: GP 10 Analytical Accounting Data is Missing

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 10 Analytical Accounting Data is Missing

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 10 Analytical Accounting Data is Missing

    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?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 10 Analytical Accounting Data is Missing

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 10 Analytical Accounting Data is Missing

    Hi Richard,

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP 10 Analytical Accounting Data is Missing

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

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GP 10 Analytical Accounting Data is Missing

    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, 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans