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 ...
21st April 2009, 03:29 PM #1
- Rep Power
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?
IDG Tech News
21st April 2009, 03:49 PM #2
If you started accessing data direct from the MSSQL you invalid your license.
By pale_kid in forum MIS Systems
Last Post: 7th March 2009, 09:38 AM
By Stuart_C in forum MIS Systems
Last Post: 3rd March 2009, 12:16 PM
By dave20046 in forum Windows
Last Post: 25th February 2009, 12:13 PM
By mtnewman in forum MIS Systems
Last Post: 2nd September 2008, 09:55 AM
By Oops_my_bad in forum MIS Systems
Last Post: 20th March 2008, 08:28 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread