Unbilled Cost Report (JCR410)

Using Reports

Use this program to print a list of all transactions that have not been billed for all jobs in the jobs file.

This report should be run previous to Automatic Job Selection since it indicates which invoices will be created.

Report information includes the following:

Summary: job number and name, status, billing type and frequency, customer number and name, manager, warehouse, cost extension, and billing amount.
Detail: summary plus cost type, and for each cost code: total units and unit of measure, cost extension and bill extension.
Transactions: detail plus every transaction posted for each cost code including: cost rate, and bill rate, markup method, and the posting memo.

Report totals include the total number of jobs on the report and the total dollar amounts for cost and billing.

Use the following fields to print a report of unbilled transactions:

1. Order

Select the order in which you want the report to print. Options are J-job number, M-manager, C-customer number, or K-job class order. The program defaults to job number.

2. Beginning Order Choice

Enter the beginning job number, manager, customer number or job class order. Use this field to set the beginning of the document’s range. Select the $image\ex_allft_shg.gif$ icon to start with the first code on file for the selected print order choice. Press F2 or select the $image\find_shg.gif$ icon to perform a search.

3. Ending Order Choice

Enter the beginning job number, manager, customer number or job class order. Use this field to set the end of the document’s range. Select the $image\ex_allrt.gif$ icon to start with the last code on file for the print order choice. Press F2 or select the $image\find_shg.gif$ icon to perform a search.

4. Warehouse

Enter the warehouse or warehouse to include on the report. Entering a valid warehouse code displays the warehouse description. The program defaults to the warehouse assigned to the terminal. Press F2 or select the $image\find_shg.gif$ icon to perform a search. Press $image\all_shg.gif$ or F1 to default to ALL.

5. Customer/Manager

Enter a valid customer number (or manager if customer was selected in field #1) to which/under which the jobs were sold. Entering a valid customer/manager displays the customer/manager name. Press F2 or select the $image\find_shg.gif$ icon to perform a search. Press $image\all_shg.gif$ or F1 to default to ALL.

6. Status

Select whether to print only those jobs which are A-active or C-cost complete. Press $image\all_shg.gif$ or F1 to default to ALL.

7. Billing Type

Select whether the billing type to print is F-fixed contract, C-cost plus, T-time and materials, N-no charge, or A-all.

8. Billing Frequency

Select whether the billing frequency to print is M-bill monthly, C-bill when complete, D-bill on demand (whenever there are invoices), or A-all. .

9. Cost Type

Select the cost type of the transactions to print or A-all. Choices are user defined in the Cost Type F/M.

10. Cutoff Date

Enter the transaction cutoff date to print. This is the date of the original posting from the source code module. Transactions with dates after this entered dated are not included. Select the $image\ex_allrt.gif$ icon to start with the last date on file. Press Enter (CR) to default to NO CUTOFF.

11. Scope

Select to print S-summary, D-detail or T-detail with transaction information. Press Enter (CR) to default to S.

Unbilled Cost Report (JCR410)

Using Reports

Use the following fields to print a report of unbilled transactions:

See Also