In this article, you will learn about exporting and importing entity details into SFM.

Before you begin, it is important to note that from the time the data is exported to Excel and then imported into SFM, no changes should be carried out on the entity details from SFM directly.

Exporting Entity Details in SFM

1.  In SFM, go to: Current Year > Sales > Client Maintenance.  (Or Current Year > Purchases > Supplier Maintenance for suppliers.)
   
   
   
   
   
2. When the grid opens, select the Printer icon - you can find it in the left-hand icon list.
   
3. In the Printer menu, go to Exports > Export Client Details.
   

   
   

   

   
   

   
   
4. The Clients Export List modal will open. Under the 'Export Options' section, select 'Export client details in import template format' and press Export. (If you are exporting suppliers, the modal and option are labelled with 'Suppliers' instead of 'Clients'.)
   
   
   
   
5. Save the import template to your preferred location (ex Desktop).
   

1. Make sure the template you want to import into SFM is saved on your desktop and closed.
   
2. In SFM, go to Current Year > Sales > Client Maintenance. (Or Current Year > Purchases > Supplier Maintenance for suppliers.)
   
3. When the grid opens, press the Excel button at the end of the left-hand tool list, followed by Import details option.
   
   
   
   
4. A confirmation message will ask 'Are you sure you want to Import Clients details?', click Yes to continue.
   
5. Select the Excel template from the desktop and click Open.