Report Setup
The following report needs to be manually deployed and have its locations set:
Job Schedule by Cost Code
The Job Schedule by Cost Code report is included with Signature 2018 R4. This report needs to be deployed and have the location path set for each user's computer that will be accessing Schedule.
Deploy the Report
- Launch Microsoft Dynamics GP and then go to Microsoft Dynamics GP > Tools > Setup > Service Management > Module Setup > Service Options.
- Under Reporting at the bottom of the window, select Run Wizard and then select Continue.
- Select Next.
- Complete the server information and select Next.
- Select the System Database and then select Next.
- Verify the information and select Next.
- In the next window, unmark all checked boxes.
- Expand Job Cost. by choosing the +.
- Mark the checkbox next to Job Schedule by Cost Code and select Deploy.
- After the report has deployed, you are returned to the Report Wizard window. Select Cancel to close the window.Repeat this for any additional company databases.
Set Location Path
- Launch and connect to the SQL Server.
- Run the following SQL statement to update the Job Schedule by Cost Code ReportLocation, replacing Report URL with your actual report URL.
UPDATE WSRepts SET ReportLocation = 'Report URL
' WHERE ReportReference = 'Job Schedule by Cost Code'