How to run a re-index in SFM

How to Reindex SFM

The Reindex Application Data files option performs a Reindex of those data files related only to the particular company which is in use.

These data files include the company and system data files. This process also clears the Number of Logins field in the Active User List. In the case of users on a network, it is important that all users are out of the system when this Reindex is affected otherwise an error may occur.


To access this, go to the Administration Menu > Reindex:





You can choose what files, modules and which years to reindex. You can also choose to run a Validation right after the reindex is complete:


A problem may occur if users are using the system. An error example:



The best option to identify who is locking your files is to go to Administration and select Network Files Monitor, you need to know the administrator password of the server.



    • Related Articles

    • How to Reindex SIMS

      Reindex is mostly used to fix corrupted indices. If they are not repaired, the utility will indicate which databases need attention.  It is important that all users are out of SIMS (and SFM if applicable) or else an alert will pop up that another ...
    • How to Reindex POS

      Reindex solves most of the issues that can be caused by a power cut, or any other event that may affect the functionality of the POS. There are 2 ways to reindex POS. Method 1: Via the Toolbar You can go to Admin>Reindex: The below will pop up: ...
    • 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 ...
    • How to Install SFM

      Installing SFM To install SFM, follow the below steps: Launch SFM.exe.  Press Next and accept the terms of service. You may need to install .net framework 3.5 when doing this as your device may not have it installed. Leave the install folder path ...
    • Error 7017 | Corrupt indexing error upon logging in to SFM

      Problem An SupplierSadsTable: Error 7017: Corrupt .ADI, .CDX, or .IDX index error pops up upon logging in to SFM. Environment SFM Solution A re-indexing would need to be carried out. Before proceeding with the re-indexing, it is important that all ...