Advance Search Function

What can we help you with?
Table of Contents
< All Topics
Print
Million Accounting
Million Search Function

This topic shows how to use Search Function in Million. There are several searching methods in Million. Advance Search Function allow user to search for GL accounts, debtors, creditors and products information in one screen without navigate from menu to menu. Listing Search allow user to search the name in debtor/ creditor maintenance listing and product listing, project listing and etc. Other method also included such as account search in GL transaction and product searching during invoicing.

Search functions Method 2 to 5 only available for patch file after June 2019.

Below are the overall content for this topic.

Method 1 : Advance Search Function
Step 1: Access to Advance Search page
Step 2: Enter search data
i.   Search GL Account
ii.  Search Debtor / Creditor Account
iii. Search Product Maintenance

Method 2 : Listing Search Function – Search For Name
Step 1: Access to Maintenance Listing
Step 2: Search for Name

Method 3: Search master account in GL Transaction
Step 1: Access to GL master account

Method 4: Search item during invoicing
Step 1: Access to invoicing
Step 2 : Search by criteria
i.  Search by bar code
ii. Search by more criteria

Method 5: Search item name during POS Cash Sales
Step 1: Access to POS Cash Sales
Step 2 : Search item name

Method 1: Advance Search Function

Step 1: Access to Advance Search page

1. Login into accounting main screen.

2. Click Search on the top right section

Advance Search Pic 1

Step 2: Enter Search Data

Search GL Account

1. In Search For text entry, enter account no. and system search account no. accordingly.

2. If enter description, system search description accordingly.

3. Double click on the account and system show GL Account information.

Search Debtor/Creditor Account

1. In Search For text entry, user can search for numeric data.

2. Enter search character.

3. Double click on the data and system show Debtor/Creditor information.

Search Product Maintenance

1. In Search For text entry, user can search for product.

2. Enter character and numeric and system search data accordingly.

3. Double click on the data and system show product information.

Method 2: Listing Search Function - Search For Name

Step 1: Access to Maintenance Listing

1. Go to Debtors > Debtor Maintenance and system display the listing

Step 2: Search for Name

1. Enter the name directly on the screen and system will auto capture and change the ‘Name’ title to ‘Search For xx’ title.

2. System will auto filter the name listing according to the search data.

3. This search function also included in creditor maintenance, product maintenance, project and department maintenance and sales agent maintenance.

Ready to Buy Million Software System?

Method 3: Search master account in GL Transaction

Step 1: Access to Maintenance Listing

1. Go to General > GL Transaction > Add

2. User enter account name in master account entry and press down arrow key in keyboard.

3. System displayed the filter according to the search data.

Method 4: Search item during invoicing

Step 1: Access to invoicing

1. Go to Sales > Invoice > Add

2. Enter header information and continue to Body Tab entry.

3. In Product code, click on the drop down list button.

Step 2: Search by criteria

Search by bar code

1. Scan the bar code at Scan Code Entry.

2. User can choose to display Brand, Price or Qty Bal at the Show Last Column Option.

3. Click on Search

4. System displayed the result accordingly.

Search by more criteria

1. To search for Group, Subgroup or Brand, please enter the search data.

2. Click More Search Criteria if want to search from product remark 1 to remark 10.

3. Enter search data on remark accordingly. Click OK

4. System displayed the result accordingly.

Method 5: Search item name during POS Cash Sales

Step 1: Access to POS Cash Sales

1. In POS Cash Sales, click on Search

Step 2: Search for Name

1. On the listing screen, direct enter search description.

2. System auto change the ‘Description’ title to ‘Search For XXX’ and filter the search data accordingly.

Ready to Buy Million Software System?