Issue/Symptom/Question

This invoice was cancelled and the user checked Y(Yes) to keep adjustments after cancelling the invoice in the Reverse A System Generated Invoice, but the user ended up having to adjust after cancelling the invoice cycle all together.  
The user also noticed after the labor rates were adjusted they too do not pull in correctly on the invoice. The error comes into play when trying to adjust to add an equipment line. The user didn’t have any issues until after completing the invoice and then reversing the invoice to make corrections.

An error has been detected in a SQL Statement.

EQP017 -1 ORA-00001: unique constraint (PENTA.INVOICE_WORK_PK) violated

inf003 - copy rows(s)

Applies To

PENTA for Windows

Billing & Accounts Receivable >Credit Memos/Reversals > Reverse A System Generated Invoice

Resolution/Fix/Answer

If you experience this problem please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

• include a bullet point list of the information needed such as:
• Job ID
• Employee ID
• Check Date
• Etc.