Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

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Ā 


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • General BillingGB
  • Recurring Invoices (gbrecurr)


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

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


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

Development is currently researching the issue. Install MUN-436454 once available

Work around is to manually remove all Invoice Detail lines from the Recurring Invoice record receiving the issue. Once all are have been removed, manually add each charge code back. The next available Line number will restart and increment from 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)

...