Keith, looking at this report/chart Work order Cost Summary Chart(I can't find one by the work order cost by work order type chart). It appears that you can remove the labor by unchecking the box on the right when you run the report and if you want it to always be unchecked we can change that on the parameters tab of the function. Is this what you are looking for? Then you don't have to make a copy and modify the base report. Please let me know if I am miss understanding the question, thanks.
Hi Michelle, The base chart in the start up screen SC0002 is the one I was wanting to modify - copy. I was thinking it woudl be a useful startup chart for maintenance managers to have for purchases from ERPLN
SELECT TO_CHAR( cws_date, 'YYYY' ), TO_CHAR( cws_date, 'MM' ), r5o7.o7get_desc( 'planguage', 'UCOD', cws_jobtype, 'JBTP', '' ), COALESCE(cws_costdefcurr, 0)
WHERE cws_org = 'userorg'
The problem with that is that we don't have the ability to modify the view that is used it was created by Infor(r5scworkordercost). We could create a chart to pull the data you are looking for but we would have to create a new query based on a either a new view that we created or tables in the database. When we do this we do have to have the parameters that is calls for but if you go to the chart setup screen it explains the parameters needed to build the chart.
Thanks Michelle. I will get some help on this from Matt to make this.