MIS Systems Thread, Capita FMS duplicate Reconciliation Entries in Technical; Hi,
i work for an LA that delivers regualr periodic reconciliation files to schools but we do not support the ...
17th June 2013, 11:55 AM #1
- Rep Power
Capita FMS duplicate Reconciliation Entries
i work for an LA that delivers regualr periodic reconciliation files to schools but we do not support the schools SIMS/FMS installs (this is handled by a support company of the schools choice) Since the new financial year we have had users reporting duplicate entries in FMS after an import of the files sent. I have checked the files we generate & send out and have found no duplicates within the file & therefore suspect that the users are importing the reconciliation files twice or more.
has anyone had this issue (especially recently) and is this possible? I assumed (i know i shouldnt!) that capita's FMS module would recognise the file (name, time stamp etc...) and issue a warning like "hang on -you've already imported this file!" and error out.
Im i wrong in assuming this and can anyone point me in the direction of any instructions that i can send out to schools to remove these entries (at the minute its to advise a complete restore of the DB which is a bit of a pain for both the users, the 3rd party support companies and the LA)
Also, is there a log of what files have been imported into FMS and when so we can see if a user has indeed imported the same file multiple times?
20th June 2013, 04:48 PM #2
- Rep Power
Unless things have changed, is was always the case that a file with the same name could not be imported twice. The Audit Trail in FMS will include details of when reconciliation starts, including the file name used. e.g. 17/05/2013,10:35:13:58,2013,NW,GS,Auto. Rec. of 6131301.REC started
By RobT in forum MIS Systems
Last Post: 14th September 2011, 11:18 AM
By Stuart_C in forum MIS Systems
Last Post: 3rd May 2011, 12:01 PM
Last Post: 1st March 2007, 12:43 AM
Last Post: 20th February 2006, 08:35 PM
By Dos_Box in forum Hardware
Last Post: 16th December 2005, 01:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread