Tracing a Journal entry from SFM to SIMS interface

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:
  1. The €150 entry were x2 (AA) Adjustment Add (note that the system sums the Totals in one transaction on SFM).
  2. 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.



Idea
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 ...

    • 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 ...

    • 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 ...

    • 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. ...