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

Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_1.png

Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_2.png

 

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.

 

Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_3.png

 

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

 

 Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_4.png

 

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.

 

 Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_5.png

 

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

 

 Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_6.png

 

 

 

 

 

 

 

 

 

 

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

 

 Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_7.png

 

 

 

 

 

 

 

 

 

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.

 

Creating_a_Selection_Criteria_Name_in_Financial_Accounting_Reports_pic_8.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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

Topics: SAP Business One

Recent Posts

Do You Need Help in Packaging inside SAP Business One?

Jan 23, 2019 12:58:06 PM

How to Set Rate for Selection Criteria in SAP Business One!

Jan 14, 2019 10:35:26 AM

Evaluate Employee Performance with Spy Software for PC

Dec 22, 2018 5:08:49 AM

Setting Batches? Choose The UoM in SAP Business One!

Dec 11, 2018 3:53:07 PM

How to Set Your Sequence for Check Printing in SAP Business One!

Dec 4, 2018 11:54:31 AM

Posts by Topic

see all