web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AA Distribution Query ...
Microsoft Dynamics GP (Archived)

AA Distribution Query Window error

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator
I am trying to create a new AA query and after I enter 1 for the begin month and 12 for the end month and click Next I get this error message. Please enter a valid calendar month between 0 and 0 for fiscal year 2014 Do I have corrupt AA setup tables? How do I get this query to execute?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: AA Distribution Query Window error

    Mr. Richard

    Check this post, it might be of relevant value  Valid Fiscal Period

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: AA Distribution Query Window error
    I do not appear to be able to attach a screenshot, but the AA Reporting Option screen shows no periods setup. How do I get the fiscal periods setup on this screen?
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: AA Distribution Query Window error

    Mr. Richard, 

    There is no setup for this window as it retrieves data throughout the AA setup from the fiscal year setup originally created in Dynamics GP. The data mostly resides in AAG00500.

    In case we are talking about a live environment, then removing the AA completely and reactivating it could not be a valid solution. I am not quite sure but do believe that this table should resolve the problem when filled out.

    Please keep us posted, 

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: AA Distribution Query Window error

    Mr. AlSaadi, this is a production environment and from my understanding something happened at the end of 2012. They were trying to install SLB and something went wrong and then the person doing this quit and work stopped. I have no idea what would have gone on however I see from 2013 on there is no data collecting in the AA Smartlists. When I can get back on their server I will check out the AAG00500 table. I will try looking at the TWO..AAG00500 table to see what the records should looks like.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: AA Distribution Query Window error

    Nothing we have tried has corrected this issue. When I recalculate the FY no new records appear in the AAG00500 tables. We will now open a case with MS as we have tried everything we can try.

  • sueconrod Profile Picture
    sueconrod 337 on at
    RE: AA Distribution Query Window error

    Just sent you what that table should look like, hope it helps.  You could import the table as a direct table import.  Wondering if the person who left deleted or dropped the table on you?  Don't see a way to checklink it, it is associated with your Dynamics table.  I'm sure GP is going to come up with the SP that builds that table when the AA install gets run.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: AA Distribution Query Window error

    Running check links was bad. It generated a few thousand pages of records removed messages. This another reason why I feel there are other setup tables either missing or not populated. We restored from backup so as not to lose any AA data.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans