Recurring Invoices creates a blank Invoice Detail line when adding a charge code

When adding a charge code to a GB Recurring Invoice, a blank Invoice Detail record is added

When Generating Recurring Invoices receiving one of the following errors:

• Unknown insert error on General Billing Inv Proof Detail

• Error verifying invoice line

• Unknown error on execute insert. Status: 268 ISAM 2601

• Cannot insert duplicate key row in object dbo.gbrecurd with unique index gbrecurd1. The duplicate key value is 

• General Billing

• Recurring Invoices

Recurring Invoices properly function with two digit Invoice Detail Lines. When a Line number is three digits, newly added Invoice Detail lines are creating a blank charge code with a NULL Line number

Development is currently researching the issue.

Work around is to manually remove all Invoice Detail lines from the Recurring Invoice record receiving the issue. Once all have been removed, manually add each charge code back. The next available Line number will restart back at 1.

1. Navigate to General Revenues > General Billing > Invoice Processing > Recurring Invoices

2. Search for the Recurring Invoice record

3. Click the Invoice Detail tab

4. Click Delete from the ribbon (Important: if you click Delete while focused on the Recurring Invoice tab, the entire Recurring Invoice record will be deleted. Be sure you have selected the Invoice Detail tab to ensure you are only deleting the individual Invoice Detail record)