Generic Inquiries in MYOB Acumatica

MYOB Acumatica Tips and Tricks #4

With the release of version 2019, new functionality has been added into Generic Inquiries in MYOB Acumatica (formerly MYOB Advanced). Customise your Generic Inquiries with these new functions to save time and improve the results from your reporting.

How you can benefit from new features in Generic Inquiries?

  • Improve overall reporting by summarising your Generic Inquiries using Pivot Tables
  • Add a side panel to your Generic Inquiry to give users direct access to other screens
  • Add aggregate functions to columns to make Generic Inquiries more meaningful
  • Use Conditional Formatting to highlight key data on your Generic Inquiries

To begin with, read the step-by-step guide to learn how to take advantage of these new features:

Embedded Pivot Tables in Generic Inquiries

MYOB Advanced Tips and Tricks 1

Pivot tables can be used as a filter tab on a generic inquiry screen. To create a pivot, click on the ellipsis and select Save as Pivot

MYOB Advanced Tips and Tricks 2

MYOB Acumatica displays the Filter settings dialogue

MYOB Advanced Tips and Tricks 3

Enter a name for the Pivot and optionally check Shared Configuration to share the pivot to all users. Press OK to continue. Configure the pivot as required.

Here is a sample GI and corresponding Pivot Table.

MYOB Advanced Tips and Tricks 4
MYOB Advanced Tips and Tricks 5

Export of Generic Inquiry Parameters to a Separate Excel Sheet

When exporting a generic inquiry to Microsoft Excel, any parameters associated with the GI, are loaded on to a separate Excel sheet.

MYOB Advanced Tips and Tricks 6
MYOB Advanced Tips and Tricks 7

Side Panel Option in Generic Inquiries

A user can now view the details of entities related to a record in the inquiry on the same screen in the side panel as shown.

MYOB Advanced Tips and Tricks 8

Adding a Side Panel Navigation Path

A user can add a side panel navigation path to existing generic inquires or new ones by using the Navigation tab of the Generic Inquiry screen (SM208000). In the Screens area, the user adds a screen of the related entity which details the user wants to review and in the Navigation Parameters table specifies the parameters to be passed to the selected screen. Then in the Window Mode drop-down list, the user selects the Side Panel option; in the Icon box, the user selects an image to be displayed in the selection area of the side panel. The following screenshot illustrates adding a side panel navigation path to a generic inquiry.

MYOB Advanced Tips and Tricks 9

Switching Between Side Panel Navigation Paths

A user can add multiple side panel navigation paths to a generic inquiry. The user is limited by only the set of tables in the generic inquiry, which the user can easily expand by adding new tables and setting relations. The following screenshot illustrates using two side panel navigation paths in a generic inquiry.

For example, this screenshot shows the Customer Navigation parameters:

MYOB Advanced Tips and Tricks 10

In this case, the screenshot shows the Customer Navigation parameters:

MYOB Advanced Tips and Tricks 11

When viewing the results, 2 side panels are available allowing users to toggle between screens to view the corresponding dialogues:

MYOB Advanced Tips and Tricks 12
MYOB Advanced Tips and Tricks 13

Adding a Dashboard to the Side Panel

A user can also add a dashboard with parameters to the side panel, adding the navigation path for a dashboard in the same way as for other screens.

Generic Inquiry Row Insertion

In this release, the Results Grid tab on the Generic Inquiry screen (SM208000) has been enhanced to provide the functionality to insert a row before the currently selected row.

MYOB Advanced Tips and Tricks 14

Total Aggregate Function of Generic Inquiries

Moreover, in this release, the ability to aggregate the total of a generic inquiry column has been introduced.

MYOB Advanced Tips and Tricks 15
MYOB Advanced Tips and Tricks 16

Conditional Formatting of Generic Inquiry Rows or Columns

This release introduces the option to highlight rows or columns of a generic inquiry in line with conditional formatting.  On the Results Grid tab of the Generic Inquiry screen (SM208000), the Row Style box has been added, so that the user designing the generic inquiry can specify the style of a generic inquiry row. In this case, the box supports the use of formulas.

MYOB Advanced Tips and Tricks 17
MYOB Advanced Tips and Tricks 18

Therefore, the new MYOB Acumatica release has brought new features that can save you time and deliver more customised reports.

Interested in other ways to optimise MYOB Acumatica?

Check out our handy MYOB Acumatica Tips and Tricks blogs here:

  1. Generating On-Demand Statements in MYOB Acumatica
  2. The New User Interface – MYOB Acumatica
  3. Row-Level Security in MYOB Acumatica
  4. Generic Inquiries in MYOB Acumatica
  5. Fixed Assets in MYOB Acumatica
  6. Business Events in MYOB Acumatica
  7. Restricted use of Control Accounts in MYOB Acumatica
  8. Corporate Cards in MYOB Acumatica
  9. Matrix Items in MYOB Acumatica
  10. Restricted Visibility of Customer and Supplier Records
  11. Important features of reporting dashboards
  12. The Global Search Function in MYOB Acumatica
  13. Learn to Streamline your Intercompany Sales
  14. Simplify Your Cross-Company Sales
  15. Adding one-off public holidays to MYOB Acumatica Payroll
  16. Deferral Schedules in MYOB Acumatica
  17. Keyboard shortcuts to improve efficiency in MYOB Acumatica
  18. 3 Steps to Archive Documents in MYOB Acumatica
  19. How to streamline EOFY reconciliations in MYOB Acumatica
Need help icon

MYOB Acumatica Information Pack eBook

Download now

We hope these tips and tricks were helpful to you! If you have any questions about Generic Inquiries in MYOB Acumatica, our friendly team is here to help. Call us on 1300 857 464 (AU) or 0800 436 774 (NZ), or send us an email.

Alternatively, for a comprehensive overview of all of our best MYOB Acumatica ‘hacks’ in one place, you can download our PDF from the panel on the right – The Ultimate Compilations of Tips and Tricks!

Accolades
MYOB Diamond Partner
MYOB ANZ Partner of the Year 2023 Badge
MYOB Consultant of the Year 2023 Badge
Velixo Award 2024
Velixo Award 2023
Prospend 2023 partner of the year
Consultant of the Year Award
ES-HIGH-ACHIEVER-AWARDS-2021-EX-BUS-DEV-AUS
ES-PARTNER-AWARDS-2021-RGB-Exc-Bus-Dev-Exo-AU_reversed
PARTNER-AWARD-2020-EXBUS-EXO-AU
MYOB-WARD-EXCEL-BUS-DEV-EXO-2019-AU
Velixo Award 2019
AwardPartner2018-2x
Business awards logo
AwardPartner2016-2x
Excellence in Business Development 2015 AU
MYOB EXO Award 2015
AwardPartner2013-2x
AwardSolutions2012-2x
Telstra Awards 2012