Multilevel query assistant

Like (0) Share

Report

Posted on 28 Feb 2018 16:47:39 by Gilberto Ojeda

265

Hi, I need help with the multilevel query assistant, which is located in the following route:
Consultation - Financial - Analytical Accounting - Assistant for distribution consultations.
I try to download information from the report and it does not show information, validate the data and if we have transactions with information to show in that report, reason why I want you to support me in indicating if there is a process or configuration that I should review before executing the report.

My gp version:

Thank you

*This post is locked for comments

All responses (1)

Answers (0)

Cheryl Waswick on 05 Mar 2018 at 19:11:59

Like (0)

Report

RE: Multilevel query assistant

Hi Gilberto,

If you have used AA dimensions on transactions, then they should pull in to the AA multi-level distribution query. One common reason it may not return anything is that all restrictions are considered 'AND' statements, so they must ALL be true in order to return data. So for example, let's say you use Dimension code A on your first transaction, dimension code B on your second transaction and both Dimension codes A and B on your 3rd transaction. Then you query for dimension codes A and B, only the last transaction will be returned. (As it will only return transactions with both.) I would encourage you to make your query as simple as possible and first only pull one dimension that is on a transaction that you want, and see if it pulls. If you have too many restrictions or filters, they must ALL be TRUE in order to pull.

You can always open a support case to have an engineer look at your data with you too.

Thanks

Cheryl

Dynamics GP Online Community Support