Job Analysis by Invoice Date This report was adapted from the Billed vs. Unbilled – Costs From JC report. It shows most of the same information, but does not have the Billings Earned or Over/Under Billed columns. It is also a landscape formatted report and must be printed on a laser printer. An added feature to this report is that it will sort by Salesperson and by Job Type. Jobs that have been canceled in the system will reflect values on this report unless all of the order lines on those Jobs have been deleted—be sure to delete all order lines on canceled jobs. To print this report for another Branch, you must switch to that Branch and then print this report.
When you enter this report module, the system will prompt you to enter a Beginning and Ending order date to include on the report. It will also prompt you to enter a Job Type Code, or you can hit enter to include all Job Types in the report. The last prompt is for a Salesperson ID. You can type an ID or hit enter to include all Salespeople in the report.
When you have entered through the last prompt, the system will bring up the following question: Print Only Jobs With Zero Cost To Complete? (Y,N): N. Hit enter to include Jobs that still have outstanding costs, or type a “Y” to print only Jobs with zero costs to complete. The next question appear as follows: Include Unassigned / Unordered Material In Costs to Complete? (Y,N): Y. Hit enter to include unassigned/unordered material, or type an “N” to exclude. The final question will appear as follows: Print Only Jobs That Have Been Closed (Y,N): Y. This question was added so that you can customize the report to display only completed (closed) Jobs, or both in process (open) and completed Jobs. Hit enter to print only closed Jobs, or type an “N” to include both open and closed Jobs.
When you have entered through the last question, the report will begin printing and the system will place the cursor at an Eject Page prompt; hit enter and the system will place you back in the Job Cost Reports menu.