Contact Us


Contact Us


Contact Us


ERP Software Blog | SAP Blogs | MS Dynamics 365 Blogs

Creating a Selection Criteria Name in Financial Accounting Reports

By D1 Technologies, LLC

If certain accounts are often selected together (example, checking all AP control accounts, or certain expense accounts), it is tedious to select the same accounts again and again.  Depending on the structure of the Chart of Accounts you may not be able to even see the name of the account.

Create a Selection Criteria Name that saves your selection. 

Financials > Financial Reports > Accounting > General Ledger




1 - Enter CTRL-A

2 - Select GL account(s). 

3 - Enter a name for the Selection Criteria Name.

4 - Click on the Save button.     Execute to run the report.




When returning to the GL report, click on the round choose from button in Selection Criteria Name, or enter the criteria name.




Example in Document Journal:  frequently run the report  to show types A/P Invoices, A/P Down Payments and A/P Credit Memos.  Enter program.  Enter CTRL-A.  (unsaved data will be lost message).  Enter selection criteria, example, go to Expanded button and select the document types.   Go back to main screen.  Enter a selection criteria name.  Click on SAVE.    Click OK to run.

When returning to the program, click on round choose from button in Selection Criteria Name field, highlight and use Choose button to select.




For the financial reports (Balance Sheet, P&L, Trial Balance) if only specific accounts are desired, create a Financial Report Template (in Financials).













When running the Financial Report, use the drop down box to select the new template.












Click on the “x” column for row 1 to include all of the GL accounts in the template.  It is not necessary to display all levels of the template.

Using the template eliminates having to individually select the GL accounts to return on the report.

















For more information, contact Mark Burt at D1 Technologies, Cayce, SC  at (803) 740-5008.

Topics: SAP Business One

Recent Posts

How Alternative Items Can Save The Day in SAP Business One!

Oct 8, 2019 11:24:59 AM

How to Check Addresses on the Map in SAP Business One!

Sep 30, 2019 3:42:54 PM

How to Set Gross Profit Rate for Service Docs in SAP Business One!

Sep 24, 2019 2:17:19 PM

Don't Receive Same Batch Twice in SAP Business One!

Sep 9, 2019 12:04:20 PM

Don't Navigate. Look Up Menus in SAP Business One!

Aug 26, 2019 10:09:48 AM

Posts by Topic

see all