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 ...
    • 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 ...
    • 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 ...
    • 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 ...
    • How to enable the Non-EU Export option for EMVS clients

      The Non-EU Export option is used when wholesalers send pharmaceuticals outside the EU. The option decommissions the goods in the system. When this option is selected in the client account, the items will be decommissioned when an invoice is issued, ...