Concept:

Note: This is an optional validation rule; do not set this rule if your company does not require this type of validation.

Field Descriptions:

• This Rule is Active—Select this check box to activate the rule. If two fee line items contain a duplicate charge, the rule will be triggered. This means that a warning message will be inserted into each incompliant line item charge, unless the Auto-adjust incompliant charges to zero option is checked.
• A duplicate fee line item charge criteria—Select the check boxes next to the items that may not have another duplicate fee item charge in the same invoice.
  • Project
  • Line Item Service Date
  • Timekeeper
  • Line Item Task Code
  • Line Item Quantity
• Warning Message—Type a warning message to display when this rule is triggered. If the rule is applied to validate only one invoice, a line item contains a duplicate fee item charge, the second and every duplicate line item after will receive this warning. The default warning message is either:
  • "Potential duplicate charge, see line item %s", where "%s" is used to display the duplicated line item number.
  • Potential duplicate charge on: <invoice number or "current invoice"> (line item <line item number>)(line item 1, 2, 3 ...), ...
    
    For example, Potential duplicate charge on: current invoice (line item 1, 2, 3, ... ), INV-101 (line item 1, 3), INV-121 (line item 1, 2), INV-129 (line item 20), INV-131 (line item 11, 14), ...
    
    In the resulting warning message "..." indicates either more than 3 line items of an invoice or more than 5 invoices break the validation rule.
     
• Auto-adjust incompliant charges to zero—If this option is checked, incompliant charges will be adjusted to zero. In this case, the information about this adjustment along with the adjustment reason (which should be selected from the Adjustment Reasons lookup table) will be recorded in the adjustment history. The Adjusted By value will be System.
• Check Across All Invoices—Select this check box to enforce this rule against all existing invoice fee line items (for non-rejected invoices). By default, this check box is cleared.

Sample Scenario One

For example, if the Check Across All Invoices check box is selected and the Auto-adjust incompliant charges to zero check box is cleared then the following would apply:

Assume that all Duplicate Fee Line Item Charge Criteria are selected (Project, Line Item Service Date, Timekeeper, Line Item Task Code, Line Item Quantity). Also assume an invoice already exists with a fee line item for project (Accident Claim 20-304), with service date (03/17/2009), Timekeeper (John D.), Task Code (Accident), and Units/Quantity (3 hours).

If you create an invoice that contains a fee line item for project (Accident Claim 20-304), with service date (03/17/2009), Timekeeper (John D.), Task Code (Accident), and Units/Quantity (3 hours), the invoice validation rule would be triggered and the duplicate values in the Duplicate Fee Line Item Charge Criteria fields would cause the new invoice to be rejected.

A warning would be added to the fee line item of the new invoice.

Sample Scenario Two

If both Check Across All Invoices and Auto-adjust incompliant charges to zero check boxes are selected then the following would apply:

Assume that all Duplicate Fee Line Item Charge Criteria are selected (Project, Line Item Service Date, Timekeeper, Line Item Task Code, Line Item Quantity). Also assume an invoice already exists with a fee line item for project (Accident Claim 20-304), with service date (03/17/2009), Timekeeper (John D.), Task Code (Accident), and Units/Quantity (3 hours).

If you create an invoice that contains a fee line item for project (Accident Claim 20-304), with service date (03/17/2009), Timekeeper (John D.), Task Code (Accident), and Units/Quantity (3 hours), the invoice validation rule would be triggered and the new invoice's fee line item Units/Quantity value would be auto-adjusted to 0 hours.

A warning would be added to the fee line item of the new invoice. The Warnings column for the new invoice, fee line item would display a green check mark, indicating that the line item was adjusted.

Note: Warnings resulting from breaking this invoice validation rule only display on the line items of invoices you are currently trying to create or update. The warning message will list pre- existing invoice fee line items that meet the invoice validation rule's current Duplicate fee line item charge criteria.

Note: If you select both the Auto-adjust incompliant charges to zero and Check Across All Invoices check boxes, and if you create (or update) an invoice that contains fee line items that would break the current conditions of this rule, the auto-adjustment would only apply to the fee line items of the new/updated invoice and not be applied to any fee line items of previously saved invoices.