How to customize and save data grids in SFM

How to customize and save data grids in SFM

Customizing and saving data grids in SFM

 

All forms in SFM (windows containing data) can be customized to your liking, enabling you to have optimal usability of your SFM system. SFM provides options for you to add, remove, and move columns around on screen to set up your data forms in a way that best suits your needs. It allows you to click and move columns in the order you prefer, and you can also choose which columns you want visible in your forms. Additionally, your column setup will not interfere with the setups of other SFM users, as each user can modify their columns and data grids as they please.




Organizing column order


To set the column order in a form, click and hold your pointer over the header of the column, and then drag it to where you want it positioned.





Click on the black arrow within the column header to sort your data according to that column.

Choosing columns to show in forms


Further, to choose the columns you want available in a given form, click on the black down arrow in the top-left corner of the form (as highlighted in the image below). Then, in the dropdown menu, click on Columns to open the Select Columns pop-up window.


Items marked with a check mark indicates that they are currently shown in the selected form. With the Select Columns open, select the columns you want visible in the form, and then click OK to confirm the changes.



Saving column customization and reverting to default setting

Finally, you can instruct SFM to remember your form customization. To do this, click on the black down arrow, and then click Save. The system will save the column setup for that particular form and for all future uses of the form. 

If you want the form to revert to its default columns, click on Default.


    • Related Articles

    • Can I export the contents of the grids as they appear on the screen?

      SFM has a Form Customisation functionality that allows a user to customise the forms' grid to their needs by displaying or hiding the desired columns and arranging and sorting the columns in the desired order.  SFM has also the functionality to ...
    • How to import and export data through Excel

      You can export data to Excel by going to Support > Stock cards and right-clicking the blue box button in the top-left corner of the data grid (near the column headers). Then navigate to Export to Microsoft Excel and select the required fields (note ...
    • Displaying EMVS messages in SIMS

      EMVS 2.2 (with SIMS 3.0.25) provides you the option to display EMVS messages in the grid of your Add and Deduction Adjustments and Invoices pages, providing you with even more visibility on decommissioning alerts and warnings. A new column ...
    • Inserting a Logo to SFM Documents

      The user can upload their own logo to the following document templates: Sales Invoice/Credit Note/Cash Sales & Cash Returns Client Receipts Client Statement Supplier Remittance The image type should be a PNG (.png), JPG/JPEG (.jpg/.jpeg), or bitmap ...
    • How to Export or Import Entity Details in SFM

      In this article, you will learn about exporting and importing entity details into SFM. The process is the same for both client entities and supplier entities. Remember to access Current Year > Sales > Client Maintenance for clients, and Current Year ...