How to export the contents of the grids in your SFM system

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 export the grid in the users specific layout. This can be achieved by clicking on the down pointing arrow  at the top left hand corner of the grid to trigger a pop-up menu as shown in the figure below. 



From the pop-up menu, select Export. Then, choose either to export all the columns that can be displayed in the grid or the ones that are currently visible.







    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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.

    • Displaying EMVS decommissioning alerts and warnings in Cash Sale

      EMVS 2.2 (SPOS 3.0.30) provides you the option to display EMVS messages in the grid of your Cash Sale screen, providing you with even more visibility on decommissioning alerts and warnings. A new column called EMVS Message can be enabled to display ...

    • 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 ...