How to remove text and numbers from SIMS in bulk with Excel
With this method, the user can delete multiple text or numerical fields at one go using an imported Excel sheet.
- Go to Support > Stock Cards.
- In the grid menu, select 'Export to Microsoft Excel'.
- In the next modal, select the fields you would like to amend by highlighting the field name in 'Available Fields' and clicking the 'Add' arrow to add them to 'Fields to Export'. IMP: Stock Code is mandatory. When you have finished, press Ok.
- This will open an Excel spreadsheet with columns for the fields you selected.
- To remove text from a field and leave it blank, type [REMOVE] in the cell.
- To zero out (0.00) a numerical field, type -1 in the respective cell.
Use the Remove option ONLY on those fields that are NOT mandatory.
Please note that Barcodes cannot be deleted with this method. If the user needs to clear barcodes in bulk please contact Support for help.
Related Articles
How to Change a Stock Code in SIMS
To change a stock code: Open SIMS. Click on Admin > Change/Delete Stock Card > Change/Delete Stock Card. 3. Input the old stock code, leave the Delete box unchecked, and input the new stock code. 4. Click on the Save button (floppy disk icon) 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 ...Can I change or delete stock codes in SIMS?
SIMS provides the option to change or delete a stock code, as detailed below. Both options can be accessed from Admin > Change/Delete Stock Cards. Change a stock code When you access this function, click on the insert button to add the stock code ...Creating and Updating Contracted Prices in SIMS using Excel
Creating New Contacted Prices Scenario 1: Adding a new contracted price for an existing client Go to Support > Clients and choose the client. Click on the Contracted Prices tab. Press + or 'Insert' on the keyboard. Enter the stock code and choose a ...How to post an Adjustment in SIMS
To post an Adjustment of Stock in SIMS: Go to Main > Adjustments > Adjustment Add or Deduct. Press the + Sign to input a Stock Card. Type ? in the 'Stock Code' field. Another window will pop up to search the Stock Card, double-click on the Stock ...
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 ...SIMS - User Manual
The attached PDF includes the necessary functions and features of SIMS to get you started. SIMS User Manual.pdf