How to Create an Advanced Filter in SIMS
The advanced filter is a tool to show select fields in any module.
Below is an example of an advanced filter in Support > Stock Cards to show items with a quantity higher than Zero.
- Go to Support > Stock Cards.
- Right-click on the blue box in the top left corner and choose 'Set Filter'.
- In the next box, head into the advanced section and choose the field you wish to have a filter on, in this case 'Quantity'.
- Double click on it or use the highlighted button to move the field chosen from the left to the right.
- To get items with a quantity greater than zero, write >0 at the end of the text in the right-hand box.
- Press 'Validate', and then press 'Add Filter'.
- The selected filter will appear in the 'Criteria' box.
- Press on the floppy disk icon to save, then give it a name and press 'OK'.
- Finally press on the green tick sign to apply the filter.
- In this way, the system will only show items that have the selected criteria.
Please note that if the Stock Cards window is closed the filter will be reset, but will be saved so that you can apply the same filter another time without having to go through the setup process again.
- To apply a saved filter, go to Support > Stock Cards.
- Left-click on the blue box in the top left corner and the filter name will come up. Click it to apply the filter.
This advanced filter is available through all-out SIMS so it can be used in different modules.
Related Articles
SIMS Search Functionality
Accessing the Search function in any SIMS Grid Navigate to any Grid (we are going to use Support > Stock Cards as an example). To enable the search function, press any letter key on your keyboard. The search function will appear between the toolbar ...Error: Cannot send email through SIMS
Problem The user tries to send a document from SIMS, but the email program does not open. Environment SIMS Solutions 1. Default Email Program Settings Go to Start in your Windows toolbar. Type 'Default' and click on the below: Then choose the default ...Adding images to POS buttons from SIMS
You can assign images to Buttons to help POS users identify a product more quickly during a sale. Buttons pictures are best created from SIMS so they can be replicated to all POS stations in the company. In SIMS, go to Main > Point of Sale > Others > ...Managing BCRS Purchase Charges in SIMS
Introduction All purchases in SIMS are only allowed to inventory products and not to non-inventory items. With the implementation of BCRS from Monday 14th November 2022, and if you purchase products that fall within this new scheme, you will be ...How to Push a Group Right from One Company to Another in SIMS
If you have multiple SIMS companies, the user can have different permission for each and every one of them. The admin can create a group permission folder for a group or a user. This same folder is visible in all companies, but the permissions in it ...