Important - For the attention of the SIMS FMS6 Operator

Financial Services for Schools

SIMS FMS6

USER BULLETIN No. 128

New LMSFR 10 & 11

February 2012

Included in this Bulletin

Checking Ledger Codes

Setting Up New Ledger Codes

Setting up The New FMS LMSFR 10 & 11 Report

Printing the Report at Year End

Checking The Ledger Codes

The Report has been designed to import into FMS6 user defined reports.

First you will need to make sure all the following codes have been set up in FMS.

(I08)

Income

723501,737001,737101,737501,749401,720711,723521,

723511,720801

(I07)

Income –

720001,742001.742002,742003,742004,742005,723531,

720203

To check the ledger codes please go to

Tools | General Ledger Set Up | tab 5 ledger codes | type in the ledger code number.

Setting Up New Ledger Codes

Tools | General Ledger Set Up | Tab 5 Ledger codes.

Add

Select the type of ledger code (for this example Income)

Click on Next

Through the browse select the ledger Group the new code belongs too.

Click on Next

Select the fund to attach to the new ledger code.

Click on Next

Enter the new code and new description

Click on Finish

It will bring you to the Ledger Code Definition Screen

You will need to select through the appropriate Normal Vat code

Once complete Save.

Setting Up The New FMS LMSFR 10 & 11 Report

You will find the report on the grid at

Setting up the FMS6 report

Please save the export file on your desk top (Right click on file and save target as)

Files you will need:

Importing report

Reports | General Ledger | User defined Reports

Select | User Defined reports (On the tool bar)

Select | Import Report

It will bring up an Import Report File box.

Select the from your desktop | open

The following message should be displayed.

Select | OK

Once the report has been imported it will need to be modified.

Sitting within Report details you should now see

Double click into this report / line.

The report details will be displayed.

These have all been created for you.

Next you will need to Check the Row set.

Click through the looking glass by the side of Row Set.

The Row Set Browse will be displayed.

Double click into

This will be highlighted for you.

This will bring you to the Row Set detail screen.

As you can see the order, type, and row names have been set up.

To check that each code has pulled through you will need to double click into each line that has a ledger code number in the row name..

It will display the Row Details

The following will need to be checked

Data - Ledger

The ledger code and Name match

The Income is viewed as a positive, please make sure the radio button is in ‘Treat Income as positive/Expenditure as positive’

Save

Once all lines have been checked save.

Make sure the row set name LMSFR 10 & 11 is highlighted.

Click on Select

Then save at the main screen.

Printing The Report at Year End

At year end you will need to print this report along with the other LMSFR’s (please see the Bulletin for Completing Year End) and have it signed by the Head Teacher and The Chair of Governors.

Reports | General Ledger | User Defined Reports | LMSFR 10 & 11 Report

To print Open the report and click on.

It will bring the report to screen click on the again.

There is a section at the bottom of the report for the Head Teacher and The Chair of Governors to sign.

This will need to be sent in with your year end documents to the School Funding Unit.

If you require assistance please contact the Helpline:

 01992 555753 Option 1

Or

e.mail  :

Financial Systems Helpline
Tel. No.: 01992 555753 Option 1
Fax No: 01992 555727
Email:
Bulletin 128 February 2012 / 1 /