+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Reporting in SIMS FMS in Technical; I'd like to run off reports from SIMS FMS to show all the purchases from a particular supplier, or for ...
  1. #1

    Join Date
    Dec 2007
    Posts
    149
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    16

    Reporting in SIMS FMS

    I'd like to run off reports from SIMS FMS to show all the purchases from a particular supplier, or for a particular part/description but both our finance person and their support at the LA say it can't be done, only reporting by cost centre is possible. I know it can be done but just not through the FMS application as the data is all there in a database.

    Has anyone else had to set up reporting from sims FMS using third party tools? My SQL isn't quite up to "inner joins" and I've looked at the table structure and its all a bit involved.

    Also does anyone have a tool that will produce a graphical representation of the tables in a and MS SQL database and all the links between the tables?

    Thanks ChrisJ

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,406
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    If you started accessing data direct from the MSSQL you invalid your license.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMs Reporting
    By pale_kid in forum MIS Systems
    Replies: 5
    Last Post: 7th March 2009, 08:38 AM
  2. SIMS Attendence reporting
    By Stuart_C in forum MIS Systems
    Replies: 6
    Last Post: 3rd March 2009, 11:16 AM
  3. Sims FMS problems
    By dave20046 in forum Windows
    Replies: 15
    Last Post: 25th February 2009, 11:13 AM
  4. Sims Reporting - Deleting Favourites
    By mtnewman in forum MIS Systems
    Replies: 2
    Last Post: 2nd September 2008, 08:55 AM
  5. Auto-reporting in SIMS and permissions
    By Oops_my_bad in forum MIS Systems
    Replies: 2
    Last Post: 20th March 2008, 07:28 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •