This module will provide line-by-line cost, sale, profit and margin information, similar to the View Job Cost module, but does not require material to be assigned, just entered as a line item on the Job. Additionally, the module will print a detailed job cost report on any Job in the system, whether open or closed. The job cost data on the report combines data that previously had to be viewed from several different areas of the system, which makes it an incredible tool, especially for large commercial dealers. Everything you need to see as an owner or manager on each Job has been combined together on one page of this report. The Budget is displayed showing the Actual Costs, the Budget as it was set in the beginning and then the Difference between the two. You can also see the salesperson commission amount, including the commission base and the percentage. That information is followed by all the totals on the job, such as line totals, tax, the total sale, profit and margin, and then information on the Invoice if one has been created. The end of the report lists each line on the Job with the corresponding cost, sale, profit and margin. On any labor lines where labor has been posted in the system, the Installer ID will also display along with his rate, total paid to date, and any quantity remaining to be paid. If you wish to see Unit Costs on this report, you will need to set the System Control 2 menu option “Work in Progress – Print Vendor” option to “Y” for yes.
When you enter this module, the system will prompt the following: Please Enter Job Number, or (F1) to Look-Up. Type in the Job Number or use the F1 key to perform a look-up by Customer ID. Once you have selected a Job, the system will display all the lines on the Job, whether inventory is assigned or not. The screen will appear as follows:
Material does not have to be assigned on a line in order for it to display in this screen. This module costs material, labor and special charges the same way the Billed vs. Unbilled – Costs From JC report does—see the details of the report explained below. When material lines are first entered, the costs come from the catalog; they are subsequently updated from purchase orders, receiving inventory, and then bill posting in Accounts Payable. Labor costs come from the catalog and are then updated in Job Labor Mtc./Installer Payments if any changes apply. In addition to viewing the Sale, Profit, and Margin on each order line, there are two additional functions you can perform from this screen. If you wish to view the Customer’s account information, simply type a “C” and the system will pull up the Customer Account Status Inquiry screen for this Customer. If you type a “P” for Print Job, the system will produce a one page report as explained at the beginning of this section. Only the first Invoice number and date will display on this report but the Current Balance is continually updated through Post Cash Receipts. Where you see a “-p” at the end of an Invoice number, that indicates the Invoice has been paid through A/P. For Accumulator items, such as Pad and other supplies, since multiple Invoices are tied to the inventory record, in place of the Invoice number, the printed report will display “ACCUM.”