Revenue adjustments enable you to discount or mark up labor, material and other charges on Work Order invoices (for service compute jobs), and to add management fees to the total. This functionality is also supported by Quote Master / Quote Manager.
Service Work Orders: The Revenue Adjustment defaults from the Job record when the Work Order is created in New Call. The Adjust Revenue button on the Gross Margin tab of the Work Order must be clicked to implement new Revenue Adjustments on a Work Order. The Adjust Revenue button should be clicked after the Ok To Invoice button (on the invoicing tab) has been clicked, all costs have been imported to the work order (so that revenues can be adjusted correctly).
Quotes: The Revenue Adjustment Id referenced on the Quote Scope is used to generate Revenue Adjustments when the Quote Scope is saved. These Revenue Adjustments will be written to the Work Order when the Quote Approval Wizard is run.
The upper section of this screen displays the primary Revenue Adjustment information and default discounts (or mark ups) for Labor, Material, Other and Subcontractor charges.
The tabs on the lower section of this screen display the Revenue Adjustment 'child' tables. These are used to specify the management fee structure and to specify exceptions to the default discounts or mark ups listed in the upper section. Click on the following buttons to see additional information:
Revenue Adjustment Id:
Uniquely defines this record. This field is required.
Revenue Adjustment Description:
Briefly describes this record.
Labor: Material: Other: Subcontract:
If you wish to implement discounts or mark ups by category, the fields in this section should be completed. Specify the following fields for each type of discount (Labor, Material, Other and Subcontract). .You may not mix invoice total adjustments with adjustments by category; if the Total fields are completed, none of the category fields may be filled in, and vice versa.
GL Account Id:
This field sets the default adjustment account for the entries on the RevAdjust Work Order and Quote Scope tabs, and is typically an income type account. For a discount, it will be debited (as an offset to the credits for this type of income) when the work order invoice is posted.
Invoice Description:
Enter the description to be printed on the invoice for this type of discount. If this field is blank, no discount will be taken.
Rate%
The default discount or markup percentage to apply to this type of income. Exceptions to this rule should be specified on the Exceptions tabs in the lower section of this record.
Rate Type: Add Deduct
Deduct will apply the Rate% as a discount. Add to applies the Rate% as a markup.
Total:
These fields support adjustments at the invoice total level. You may not mix invoice total adjusting with adjusting by category; if the Total fields are completed, none of the category fields may be filled in, and vice versa. Exceptions noted on the lower tabs will be applied as applicable.
GL Account Id:
This field sets the default adjustment account for the entry on the RevAdjust Work Order tab or Quote viewer, and is typically an income type account. For discounts, it will be debited (as an offset to the credits for this type of income) when the work order invoice is posted.
Invoice Description:
Enter the description to be printed on the invoice for this type of discount. If this field is blank, no discount will be taken.
Rate%
The default discount or markup percentage to apply to this type of revenue. Exceptions to this rule should be specified on the Exceptions tabs in the lower section of this record.
Rate Type: Add Deduct
Select Deduct to apply the Rate% as a discount. Select Add to apply the Rate% as a markup.
Important Fields: Lower Section
Management Fees Tab
This tab is used to specify the management fee structure (if any) that should be added to the invoice after any applicable discounts have been taken.
Cost Category Id:
The default Cost Category for this fee. The GL Account specified in this Cost Category record will be credited when the work order invoice is posted.
Invoice Amount:
The highest Invoice Amount (after discounts) to which this management fee applies.
Invoice Description:
Enter the description to be printed on the invoice for this management fee.
Mgmt Fee: Fee Type - Flat Rate?
These fields define the management fee to be assigned to invoices in this Invoice Amount bracket. If the Flat Rate Box is checked (by pressing the Spacebar, or double-clicking on the field), the system considers the Management Fee to be entered in dollars. If the Flat Rate Box is blank, the Management Fee is assumed to be a percentage of the invoice after discounts.
Example
Suppose that you wanted to assign a management fee of $50 to invoices totaling (after discounts) $500.00, a 10% fee for invoices totaling between $500.00 and $10,000.00, and a flat fee of $1000 for invoices over $10,000. To do so, you would set up the Invoice Amount, Management Fee, and Flat Rate fields as follows:
Invoice Amt: MgmtFee: Fee Type: Flat Rate Box
500.00 50.00 √
10000.00 10.00
999999.99 1000.00 √
Labor Exceptions Tab
The tab enables you to override the default labor or total discount in the upper portion of this viewer.
Labor Rate Id:
Enter a valid Labor Rate Id (or double click to select from a list). Time entered for this Labor Rate will be discounted according to the Discount % on this line. The discount amount will be debited to the Labor GL Account Id: located in the upper section of this viewer.
Invoice Description:
Enter the description to be printed on the invoice for this type of labor.
Rate%
The default discount or markup percentage to apply to this type of labor revenue. If this field is blank, no discount or markup will be taken.
Rate Type: Add Deduct
Select Deduct to apply the Rate% as a discount. Select Add to apply the Rate% as a markup.
Inventory Exceptions Tab
The tab enables you to override the default material or total discount in the upper portion of this viewer for Inventory Items belonging to the specified Inventory Groups.
Inv Grp Id:
Enter a valid Inventory Group Id (or double click to select from a list). Inventory Items entered belonging to this Group will be discounted according to the Discount % on this line. The discount amount will be debited to the Material GL Account Id: located in the upper section of this viewer.
Invoice Description:
Enter the description to be printed on the invoice for this type of inventory materials.
Rate%
The default discount or markup percentage to apply to this type of inventory revenue. If this field is blank, no discount or markup will be taken.
Rate Type: Add Deduct
Select Deduct to apply the Rate% as a discount. Select Add to apply the Rate% as a markup.
Other Exceptions Tab
The tab enables you to override the default Other and Subcontractor or Total discounts in the upper portion of this viewer for other charges Items belonging to the Other Rates.
Other Rate Id:
Enter a valid Other Rate Id (or double click to select from a list). Charges entered at this Rate will be discounted according to the Discount % on this line. The discount amount will be debited to the Other or Subcontractor GL Account Id: located in the upper section of this viewer. The Cost Category specified in the Other rate will determine which GL Account is debited.
Invoice Description:
Enter the description to be printed on the invoice for this type of discounts.
Rate%
The default discount or markup percentage to apply to this type of other revenue. If this field is blank, no discount or markup will be taken.
Rate Type: Add Deduct
Select Deduct to apply the Rate% as a discount. Select Add to apply the Rate% as a markup.