Unable to remove budget from cost centre

A budget appears in Focus>Budget Management>Cost Centre Allocation but there are no ledger codes so it is not possible to remove it Go to Tools>General Ledger Setup>C/Centre Ledger Links Click on the radio button for Hidden If there are any for the cost centre concerned then unhide all of them, save The budget should then show…

Insurance Premium Tax

Insurance Premium Tax (IPT) is not the same as Value Added Tax (VAT) and therefore cannot be reclaimed as VAT. When processing invoices including IPT you will need to pay this tax along with the fee. Reviewed 14/05/2018 KB17874

How do I add a new bank account in FMS?

Please see below steps, if you need to add a bank account or additional bank in FMS In FMS, select: Tools> General Ledger setup> Click tab 5, Ledger codes> Click green plus button and select the ledger code type, in this case “Bank Account”   Click the spy glass and select the group the ledger code…

How to carry out a Contra / Cancel Payment within FMS

In some instances it is necessary to cancel a payment within FMS, also known as contra payment.  Please see the below scenarios of how to deal with cancelling a payment within FMS. Scenario 1 – Invoice status- Authorised If you have processed an invoice and have marked the invoice as “Authorised”, you can cancel the invoice by…

Ledger code not mapped for service term

This appears when the service term mapping cannot be found for the ledger code associated with the current reconciliation item in Personnel Links. Start in Personnel and make a note of the Service Term and Financial Sub Group for the relevant contract In FMS check the service term/ledger code mapping under: Focus > Personnel links…

Invoice missing in Lloyds Link but appears in BACS File

In FMS go to Accounts Payable>Suppliers and open the Supplier the missing Invoice was for. Open the Additional Tab and Enter the correct Account Number and Sort Code, then save the changes. Once you have done this you will need to amend the BACS file to include the new Bank Details. Further information on amending…

Unable to reconcile BACS run

BACS run is not appearing in the browse to add to the bank statement. Check the list of BACS runs – are there any with duplicate references with a Type of ‘R’?  If so the school has used the recreate file button rather than manually re-input the data. To resolve:- Create a new BACS run…

How to search transactions within FMS

Within FMS; Under Tools > Find A/P Transactions, you can then search for key words in the ‘Find transactions pertaining to’ box.   This will search all invoices, purchase orders, credit notes & deliveries and can be defined using the tick boxes.   You can only search for the year you are currently in, so…

CFR Apportionment – Preliminary Close Down

When running the Preliminary Close within FMS the following message is displayed: “All Fund Allocations must be fully apportioned for CFR before FINAL close can take place.” Go to Focus | Budget Management | Fund Allocation | Double click on the fund. Go to tab 2 – History and open the Narrative. Within here enter an amount…

How to import the approved HCSS Budgeting scenario into FMS

Once the completed scenario has been approved by governors and published within HCSS Budgeting schools will need to import the scenario into FMS. The first step of this will be to log into the HCSS Budgeting Web Companion and log into the FMS link. Once logged in you will need to use the bottom section of…

How to set up BACS within FMS

Setup the Bank Account Go to Tools>General Ledger Setup>Tab 5 Ledger Codes (if you have not already defined your bank account then you should create one now) Enter the Account Name, Sort Code and Account Number details. Account Code – only numbers can be entered here and the field defaults to 0. You should accept…

School changing to local payments

FMS PROCESSES REQUIRED FOR CHANGING FROM CENTRAL TO LOCAL PAYMENTS Tools>General Ledger Setup>ledger codes Add bank acct (usually BK01) Add petty cash (usually PC02) Tools>Books> Cheque Books – add Order books – add LPS one Petty Cash books – add LPS one Tools>Non-Invoiced Income Parameters Change from Central to Local Tools>Define VAT Periods Set up…

Unable to find reconciliation file from AnyComms (North Somerset)

Files for reconciliation should be downloaded to the \Sims\Transfer\In folder but must be in the format required for FMS. North Somerset use the format YY_1234R.12A If there is only one file to download there is not usually a problem but if more than one are downloaded all together then AnyComms will zip the file, giving…

FMS Bank statement balances are incorrect

Problem:When viewing opening and closing balances in bank reconciliation,the balances are incorrect Solution: Please open the bank reconciliation browse and press F7 key.  FMS will then verify your bank statements and adjust the opening and closing balances to what they should be. Please contact the Scomis Service desk, if you require further assistance. Reviewed 13/04/2018 kb16988…

How to amend a BACS file

The following presumes that the bank has rejected the file for some reason which needs amending in FMS, in this example it is an incorrect bank account for a supplier. Firstly, cancel the BACS run and make the changes to the bank account details in FMS via Focus>Accounts Payable>Suppliers Then go to Focus>Accounts Payable>BACS Processing…

How to add an apportionment to a different fund

On occasion it is necessary to apportion salaries to a different fund, eg 30% of a Teaching Assistant post from Fund 10 to fund 91.  These are the steps required in FMS. Step 1 – Tools>General Ledger Setup Tab 2 – ensure a cost centre exists for both funds Tab 5 – ensure the required…

BACS report missing suppliers

When running the BACS report not all chosen suppliers appear on the print out. This is a known issue, please log a call for patch 19221 to be run on your data. Reviewed 13/04/2018 KB16187

Fatal Error in FMS

Fatal Error generated when accessing areas of FMS This is usually a permissions issue where the user does not have create/write permissions for the directory path where the FMS SQL database is located eg: c:\program files\sims\fmssql or the user does not have permissions to the LOCKDIR directory containing the PDOXUSRS.NET file. TO RECTIFY Make sure…

Where are emailed pdf orders stored?

Emailed PDF orders are created dynamically when they are required so will not be stored anywhere. The user can look in their sent items or do a PDF print preview of the order after the event to view the order. Reviewed 13/04/2018 KB15246

FMS Recording Charge Card Payments

In the Spring 2015 upgrade, functionality for recording card payments was introduced into FMS.  We have put together a guide to utilising this for your school. Charge Card Functionality – Spring 2015

FMS, Salary Projection – My cost centres and staff have duplicate entries

  FMS, Salary Projection – My cost centres and staff have duplicate entries. This happens when amendments have been made to cost centre names by adding letters or numbers in front of the existing cost centre in Tools>General Ledger Setup> Tab 2 Cost Centre. To resolve this issue go to Tools>Define Financial Year> Define Salary…

How do I find out why an order was cancelled in FMS?

To find out why an order was cancelled you will first need to know the date of when the order was cancelled. The reason why it was cancelled will be what was typed by the user who cancelled the order. Once you know the date: Click Reports -> then General Ledger -> Audit -> Audit Trail…. Enter…

How Do I Re-print FMS PDF orders

1)Select Focus, Accounts Payable, Purchase order. 2)Double click the required purchase order and select order. 3) Click the icon as shown by the red arrow, labelled pdf preview, this will open the purchase order, in Adobe reader, enabling you to reprint the order.   kb13156 Last reviewed 21/12/2017      

Pay Scale incorrect within FMS

If a staff member has a higher pay scale within Salary Projection within FMS than they have on their contract within SIMS and this is incorrect please follow these steps: – Find the staff member’s personnel record within SIMS – Open their contract – Put an end date on their current Salary Scale Record that…

FMS Financial Reporting Suite (FRS)

Here are some known issues and recent queries.  It is planned that this is a rolling FAQ so may be added to in future. PDF too small to read? check  the page layout, zoom and resolution in the Acrobat report by going to Edit | Preferences | Page Display. Capita suggests view as page layout…

Claim Preparation – No fund/ledger codes showing to select

Claimants are showing to select and add in claims for additional contracted hours and supply but on selecting the fund and ledger there is nothing to choose. Check in FMS that the financial year is Started. In Claims Preparation use the Refresh Cache option. If this is the first claim they have prepared since having a new FMS…

New Licence for Payroll2FMS

When trying to access Payroll2FMS you will see the following window as your licence will have expired on 30th September.  Enter the details exactly as shown in the email that you have been sent.  All details are case sensitive.  Once the details have been entered click on “Validate Licence”  and the “Licence Code is Invalid” should…

Financial Reporting Suite does not retain server and database information

In FMS FRS using the route Reports>Financial Reporting Suite the fields for Server Name and Database are always blank. These fields should be populated after the first use but if this does not happen either log onto the workstation with an administrator account. Log into FMS and access Financial Reporting Suite. Close the Financial Reporting…

Reconciliation item fails for reason ‘order number not sent’

In FMS check under Tools>Accounts Payable Parameters>Authorisation Slips For Devon central payment schools using the FCR database the order prefix field should be blank. Any changes will not take effect until new invoices are exported from FMS and returned by DCC for reconciliation.   Reviewed on 08/04/2016