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
SIMS Release Notes
2025 22nd December 2025 | v.3.0.95 Enhancements You can now control who can change the salesperson in the Sales Quotation and Sales Orders screens via the permission SO_SPERSON and SLS_SLSPRS for sales transactions screen. The new permission ...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 ...
Recent Articles
How to Manage Barcodes in SIMS
How to Manage Barcodes in SIMS SIMS provides a straightforward way to manage barcodes through its Support > Barcodes section. Here’s a quick guide: Export Barcodes to Excel Navigate to Support > Barcodes. Right-click the blue rectangular button and ...How to print a Remittance Advice
How to print out a Remittance Advice from SFM: Supplier > Print button > Remittance Advice Select the Reference number* of the selected Range of Payments to print out the Remittance. *Import - Fixed Assets
The Shireburn Financial Manager (SFM) provides facilities to allow the importing of accounting data from third-party applications and/or your own work sheets into SFM. The options include the import of the Fixed Assets. Attached are the template and ...How to generate the INTRASTAT Report
SIMS supports the INTRASTAT module, which is available as a separate add-on. If you are interested in activating this module, please contact us at sales@shireburn.com. Updating Items with INTRASTAT Details Navigate to Main Menu > Purchases > Receipt ...Sending Remittances in Bulk using e-Reports
To send outstanding remittance advices in bulk, follow these steps: Navigate to the Remittance Advices Section Go to: - Current Year > Sepa > Sepa Maintenance - Sepa Tab (on top) - Highlight Sepa - Print > Remittance Open the e-Reports Module In the ...
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 2025 before starting to post entries into 2026. 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