Tracing a Journal entry from SFM to SIMS interface
This article provides a step-by-step guide on how to trace a journal entry from SFM back to the source of the posting.
In the below example, we have identified a journal entry through the Nominal Audit Trial listed as JR 000040 with values of €150 and €30.
Steps to identify the Journal Entry:
1. Navigate to SIMS > Admin > SFM Interface > SFM Export Audit
2. The following menu will display all export batches from SIMS to SFM. The Audit No is the same as the JR number found on SFM (in our example 000040).
3. Highlight the Export Audit by clicking on it >
4. Print button (Toolbar) > Interface Reports for Current Export > Preview
In our example, from the preview report we determined that:
- The €150 entry were x2 (AA) Adjustment Add (note that the system sums the Totals in one transaction on SFM).
- The €30 entry was an (AD) Adjustment Deduct.
You can further trace the entries by accessing the SIMS audit Trial by navigating to SIMS > Main > Audits > Transactions. Through the Audit Trial, you can search for the Tranref and print the transactions from there.
To quickly locate a specific transaction in a multi-page report, use the Search function (Binoculars icon) and enter the exact transaction amount.
Related Articles
Managing BCRS Purchase Charges in SIMS
Introduction All purchases in SIMS are only allowed to inventory products and not to non-inventory items. With the implementation of BCRS from Monday 14th November 2022, and if you purchase products that fall within this new scheme, you will be ...Setting Up and Using the Intercompany Journal
Setting up Inter-company Accounts makes it easy to automatically update journal entries in multiple companies, helping you increase your efficiency. Step 1: Creating an Intercompany Account Log in on one of the companies required for the multiple ...SIMS and SFM Interface Posting
The following table identifies the accounting entries posted in the Shireburn Financial Manager from transaction in the Shireburn Management Inventory System. The link from the inventory to the accounting system is available from the stock group or ...Error: No accounting details for code when exporting from SIMS to SFM
Problem Error: No accounting details for code when exporting from SIMS to SFM Environment SIMS, SFM Solution The Accounting details on SIMS from Stock Groups or Location need to be updated. It is important to first: 1. Confirm which accounting ...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. ...
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 ...How to run the SIMS Archive process
The SIMS Archive function reduces the size of the data store in Live by splitting the same data set in a different database, within the same company. This process improves the SIMS performance as it compacts the Live data set. Users can then access ...