Start Recompute T&M Revenue

Purpose:

It is not always possible to finalize the job setup for its construction jobs prior to real costs posting to JCH.  This includes the list of Cost Codes, the Schedule of Values (Billing Items), the Default Billing Items for Cost Codes, the Rate Schedule info, etc.

This function's purpose is to retroactively apply Rate Schedule rates and default Billing Items to already-posted JCH data for a user-specified Job. The function presents a list of qualifying job history entries for this Job.  For each selected JCH entry, it 're-thinks' billing information and updates the JCH record when changes are required.

This function also evaluates and makes adjusting Job Journal entries for billed JCH data. For any JCH entries that qualify for re computation, a Job Journal entry is generated to capture the difference in revenue amounts after the function is run. The Job Journal entries are then eligible for billing and could result in an additional invoice or a credit memo.

Usage:

This process cannot be performed on a job that has an Invoice Status of either 'Ready' or 'Printed'.  If the specified job has an Invoice Status of either 'Ready' or 'Printed', the user is given the opportunity (via form prompter) to reset the status to Hold.  The user can either abort the recompute or elect to have the status reset to 'Hold'.

Entries Which Are Skipped:

1. GMP Special Revenue-type rows will be processed ONLY for the purpose of resetting their Billing Item Rns when necessary.  Their revenue values will NOT be recomputed.

2. Entries from the following source journals are skipped:

AR Cash Receipts - AR Sales - GL Journal
Job Budget - Job Cost EOM
Bill Adjustment - IM Journal -
Quote Budget - Projected Cost - PR Check
Shop Ticket - Shop Order Jrnl

3. Reversing and reversed entries are skipped.

Entries Which Make the Selection List:

1. Entries that satisfy one or more of the following revenue-based criteria:

(a) new Revenue Rate, (b) new Billing Rate Type Id, (c) new Extended Revenue.

2. Entries also make the selection list when the JCH Billing Item no longer matches the Default Billing Item from the JCH Cost Code record.

3. Both billed and unbilled JCH data (supporting the above criteria) will be considered. .

Record Change Log entries are created for each changed JCH record and changed Source Journal Record.

An attempt is made to find and update the corresponding original source journal child lines to keep them consistent with the revised JCH.  Values updated are the Revenue Rate, Unit Price, Extended Price, Billing Rate Type Id and Billing Item.

Important Fields: Range Screen

Job Id:
Enter the Job Id of the Job to be processed. This field is required.

Cost Code:
This range may be used to limit this function to the Job Cost Code(s) specified in this filter.

Billing Item:
This range may be used to limit this function to the Job Cost Code(s) specified in this filter.

Click the Go button to continue.

Important Fields: Checklist Screen

Do
This field enables you to select which lines should be recomputed. Double-click on the Do field to select or deselect an item (or press the Spacebar when the caret appears on this field). The following fields are displayed for informational purposes:

Type:-  Date: - Quantity/HourSource Journal - Unit Cost - GMP Special Revenue?
Old Bill Item - Old Bill Type - Old Rvne Rate - Old Unit Price - Old Total Revenue
The current Job History detail up for recomputation.

Bill Item - Bill Type Id - Revenue Rate - Unit Price - Total Revenue
The new job history detail which will be generated when this line is recomputed.