Customizing 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 ...Changing grid view on SIMS
This configuration setting will work on almost any window on SIMS. It's important to Save once you finish up editing the grid. Another useful function is to Auto Arrange the column size automatically.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 ...
Recent Articles
How to Reverse a Sales/Purchases Transaction in SFM
Reversing Entries in SFM Once users confirm an entry in SFM, they cannot modify any of its elements. The only available option is to reverse the entire transaction and re-post it with the correct values. The system supports both simple reversals and ...Setting Up BOV SEPA v9
Before proceeding, please ensure you are using the latest version of SFM. Starting October 5th, 2025, Bank of Valletta (BOV) will begin processing live transactions using the new SEPA file format (version 9). The older version 3 format will no longer ...How do I process a Nominal Reconciliation?
Procedure for Reconciling a Nominal Account (Current Year > Nominal > Nominal Reconciliation) Account Field: Select the relevant Nominal Account from the drop-down menu that you wish to reconcile. Details Field: Enter any necessary free text in the ...How to Update SFS
For optimal results, update SFS directly from the server. Important notes before updating: - All Users: Log out of SFS, SIMS and SFM (if applicable). - Remote Desktop Users: Log out of SFS, SIMS and SFM before disconnecting from the remote session. ...How to Add Custom Footers per Client basis
If you want to apply the same footer across all your invoices or the same footer across all your statements, please refer to this article: How to insert document footers in SFM If you need to use different footers for specific clients, SFM also ...
Popular Articles
How do I process an End Of Year in SFM?
Overview SFM allows posting into two financial years simultaneously. This means that users do not need to finalise 2024 before starting to post entries into 2025. The end of year procedure will move the “Current Year” data into the "Previous Year". ...Do I need to Process an End-of-Year in SIMS?
SIMS does not require an end of year procedures to be run. However, SIMS controls users to only allow posting of transactions, such as sales invoices, cash sales, adjustments and purchases, within a range of dates referred to as the Posting Period. ...How to setup a System Control Account in SFM? (Bank Account, Cash Account, Stock Control, etc...)
Create the Account in your Chart of Accounts as seen below. Please make sure you use the code depending on your Heading and Sub-Heading digits. After creating the account, you need to specify the account as a System Control Account. Go to Support > ...How to reset your Shireburn remote desktop service (RDS) account password
The password for the Shireburn RDS Account used to connect to RDS server is set to expire after 90 days. A notification is provided to the user daily starting 5 days prior to the expiry date. In order to change password, the following steps need to ...How to run the SIMS Archive process
The SIMS Archive function reduces the size of the data store in Live by splitting the same data set in a different database, within the same company. This process improves the SIMS performance as it compacts the Live data set. Users can then access ...