Open Source ERP Academy

Advanced Searches and Better Business Partner Info

The purpose of this enhancement is to improve your ability to find records in the system by:
  1. Create new windows called "Advanced Search" where you can find orders, shipments, invoices, etc... by either header or line information. In other words, you can find order by search on products.
  2. Updating the Business Partner Info so that you can zoom from the subtabs.

Installation

You can find the installation files as part of the iDempiere Installation script. They are located in the Source menu => /apps/AdvancedSearch folder. There are two files. One is a SQL script. The second is a Pack In Zip.
  1. Execute the SQL script against your database using either psql or phppgadmin.
  2. Log in as the System Administrator role, open the Pack In window, create a new record, attach the zip, and process the Pack In.
  3. Log in as your normal user and look for the Menu folder named Advanced Searches. You will find about 8 windows under this folder.

Enhancements

Version 1 has the minimum columns and details to determine if this plugin is valuable. If you like it, please let me know. I can add many more columns and details to the search windows. You can always add them yourself as well. I did not reuse any existing system views; therefore, you are free to modify the views without risk of breaking something else.