JimA
3 years agoExperienced Cover User
Custom Purchase by Item Report
Hi,
We are an electrical contracting business in the commercial construction centre doing multi-million dollar projects.
With Greenstar certification becoming more prevalent, we have to as part of our hand over documentation, submit the dollar value for all PVC purchases broken up by type, i.e. pvc pipe, cable etc and conforming or non-conforming.
I currently use a modified (Purchase (Item Detail) report that shows Name, Id No., Date, Job No. Job Name, Quantity and Amount. I select the date range I'm after, pick the products I'm after and then run the report. I then export to Excel to remove the unwanted jobs. My question is, is there anyway to further filter that for a single job?