5 Quick User Tips and Tricks for Dynamics AX 2012

5 Quick User Tips and Tricks for Dynamics AX 2012

Tip #1: Save report queries for common report selections

Often a single report is run multiple different ways by a user. AX 2012 allows the user to save the report queries so the next time the report needs to be generated for a specific query the user can select the saved query rather than re-enter the tables, fields, and selection criteria.

* Note that this functionality is user specific and not a global change.

To save a report query, do the following:

From the report being generated, after clicking on the Select button and entering the selection criteria, click on the Modify button→ Save as:

Figure 1 - Save a report query

Figure 1 – Save a report query

Give the report query a name then click OK.

Figure 2 - Give the report query a name

Figure 2 – Give the report query a name

In the future when generating the report, even after running for different criteria, the user can retrieve the saved query. This can be done by clicking on the Select button then selecting the saved query from the Select query lookup.

Figure 3 - Select the saved query when the report is generated at a later time

Figure 3 – Select the saved query when the report is generated at a later time

The selected tables, fields and selection criteria will populate from the saved query:

Figure 4 - Criteria populates from selected saved query

Figure 4 – Criteria populates from selected saved query

Tip #2: Personalize the Status bar to add or remove fields

Figure 5 - Microsoft Dynamics AX 2012 Status bar

Figure 5 – Microsoft Dynamics AX 2012 Status bar

Go to File→ Tools→ Options

Figure 6 - File, Tools, Options

Figure 6 – File, Tools, Options

Click on the Status bar link then mark the checkboxes for the fields to see on the Status bar.

* Note that the selections are user specific, not global changes.

Figure 7 - Status bar options

Figure 7 – Status bar options

Click on the Close button then view the Status bar for changes made.

Tip #3: Perform simple math calculations (+, -, *, /) in a numeric fields in forms

In the screenshot below, “90+2000” has been entered in the journal line Credit field.

Figure 8 - Enter calculation in a numeric field

Figure 8 – Enter calculation in a numeric field

After tabbing out of the field, AX has performed the calculation and saved the value as 2,090:

Figure 9 - View the sum calculated after tabbing out of field

Figure 9 – View the sum calculated after tabbing out of field

Tip #4: Use the Shortcut Ctrl + T to Export a form to Excel. That’s it for number 4!

Tip #5: Use question marks (?) in filtering and querying fields to search for the exact amount of unknown characters.

In the below screenshot, seven question marks (???????) have been entered in the Customer account query field. AX searches for and returns all Customer accounts with exactly 7 characters.

Figure 10 - Example showing a query for exactly seven unknown characters

Figure 10 – Example showing a query for exactly seven unknown characters

For additional advanced filtering and querying options please visit this Technet link.

Did these tips help achieve the results you were expecting? Do you have any tips to add? Write a comment below and let us know!

About Cindy Scott

Cindy Scott has created 12 entries.

Post A Comment

YOUR CAPTCHA HERE

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Subscribe to our mailing list

* indicates required
 

×
Learn More

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

CRM Test Form

×

Influence

All fields required

First name

Last name

Company

Your Email

Proposed Webinar Date & Time
AMPM

Your Message

×

Contact Us

All fields required
×

Contact Us Here! 

* indicates required

×

We want to hear your feedback

∗ indicates required

×

Let us keep you updated!

 ∗ indicates required

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Contact Us Here! 

* indicates required

×

Contact Us Here! 

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Book Your Time

×

                        RAMPUP SUBSCRIPTION PLANS

                    Choose a plan below, and one of our

              Support Consultants will contact you shortly.

×

                           PACKAGES START AT $4,999

                  Choose a package below, and one of our 

               Support Consultants will contact you shortly.

×

 Performance Review Details

 

Diagnostic Review of DyanmicsAX Server (AOS) & SQL performance and stability.

 

Written summary of findings and recommendations.

 

Up to 15 hours of issue resolution time to target your most immediate performance issues.

 

Review completed by our 100% onshore support team averaging more than 10+ years of DynamicsAX experience.

 

Get the help you need now, with no long-term commitment.

×

Functional/Department Help Pick 3

 

Help with up to 3 functional or department issues such as: invoicing, costing, closing the books, AR, AP, inventory, warehousing, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to define your issues and find recommended solutions.

 

Up to 20 additional hours of issue resolution time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

 

×

Reporting / BI Help

 

Choose up to 3 standard or custom reports for assistance.

 

Solve typical issues like: Report too slow, does not show what we need, need an additional field/column, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to troubleshoot report issues and recommend solutions.

 

Up to 20 additional hours of configuration or development time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

×

Please fill in the form to RSVP

 

×