Sage MAS 90 and 200 Entry Grid Searches & Customization
Beginning with Sage Mas 90 and 200 version 4.00, grids are being added to more and more data entry programs in the system. Version 4.00 added grids to GL Journal Entries, 4.10 to AR Invoice Entry and SO Sales Order and Invoice Entry, and 4.20 to AP Invoice Entry. Two nice features of these grids are Grid-customization, and Grid searches.
Grid customization
Users can customize data entry grids in by clicking on a column, and either moving that column’s location on the primary grid, or moving that column to the secondary grid. Columns from the secondary grid can also be re-arranged, or be moved to the primary grid, and placed in any location. This allows you to put your important fields on the primary grid in the best sequence for your needs. Columns that are not important to you can be moved to the secondary grid. An important additional feature in 4.10 SO Order and Invoice Entry is the Change-View option activated by the icon beneath the Credit button on the upper right. Change View (you can un-change it) changes the entire Lines screen to a wide view, with the secondary grid on the right instead of the bottom. This is helpful when you enter data into a lot of columns, since it displays more fields on the secondary grid without having to scroll down to access them. The system saves your customizations so your customized screen appears the next time you access it.
Grid Searches
Grid Searches are done by clicking the magnifying-glass icon to the right of the Quick Row field (different locations on different screens). Click the icon and a Search Grid window will appear. This allows you to search by any field on the grid in a variety of ways. First select the field you want to search with. Then specify a search with beginning, ending, greater-than, less-than, containing, or not-equal-to searches. Then enter the search-value. Handy search examples include: cost=zero, description contains “wire”, extension greater-than $1000.00, etc. The Search-Grid dialogue remains displayed with a Find-Next button that highlights each line on the order for you to step through. You can change an applicable line, then click Find-Next and control goes to your search field on the next line meeting the criteria. The search can move up or down the lines, so you can re-check your entries. Nice Features!!