kyariexcel
Programmer
One of our departments is looking for a way to manage job tickets more efficiently. They would like a four-column table with Job #, Location, Job Status, and Job Notes (underneath "Phases" on the report). They use Service Manager - specifically, Document Entry - to manage them currently, but AFAIK there is no simple way to consolidate only these fields into a view. The only thing is, I'm kinda lost on where to start poking in the DB, although I've had to in the past for requests of a different nature so I'm not unfamiliar with the process.
I reference the Sage Application Object Model 6.0 for such requests, querying SQL with PHP to create an HTML result table. But I don't see anything relating to Service Manager in the AOM documentation. Do I need separate documentation specific to Service Manager to find the necessary tables? Or is the information locked away in the existing tables found within the AOM?
I reference the Sage Application Object Model 6.0 for such requests, querying SQL with PHP to create an HTML result table. But I don't see anything relating to Service Manager in the AOM documentation. Do I need separate documentation specific to Service Manager to find the necessary tables? Or is the information locked away in the existing tables found within the AOM?