/
General Billing Invoice Adjustment errors when changing Parcel

General Billing Invoice Adjustment errors when changing Parcel



Description of Issue

GB Invoice Adjustment error when changing the Parcel field after clicking Release Adjustment:

  • Error approving Adjustment. Process canceled.

  • gbinvmnt.post_routine: CALL TO BatchManager.approveTransaction FAILED.

  • ERROR EXECUTING THE SQL STATEMENT insertORUpdateBillLocationParcel.


GB Invoice Adjustment IVA Workflow error when approving adjustments from the Hub containing a change to the Parcel field:

  • Error updating Adjustment life cycle step.



Context
  • General Billing

  • Invoice Adjustment

  • Workflow



Cause

Issue caused when changing the Parcel field and not specifically Workflow related. 



Resolution

Install the following release for resolution to the errors received when Releasing Adjustments:

  • MUN-462376 (2021.7.0.1534)

  • MUN-473973 (2021.8.0.1255)

  • MUN-473974 (2021.9.0.998)

  • MUN-473970 (2021.10.0.687)

  • MUN-473971 (2021.11.0.319)

  • MUN-473972 (2021.12.0.0 Base Release)

  • MUN-473975 (2023.3.1.0 Base Release) 

Development is currently researching the issue for IVA Workflow Approvals.

As a workaround, the original General Billing Invoice with the incorrect parcel can be deleted or adjusted to $0 and then a new General Billing Invoice with the correct parcel can be created. 



Additional Information












Related content

Invoice Entry and Proof Batch Has Already Been Locked for Posting
Invoice Entry and Proof Batch Has Already Been Locked for Posting
More like this
General Billing Adjust Invoices Revenue Amount must be greater than zero
General Billing Adjust Invoices Revenue Amount must be greater than zero
More like this
General Billing Recurring Invoices returns an Unexpected Error when approving from Invoices
General Billing Recurring Invoices returns an Unexpected Error when approving from Invoices
More like this
Hub IVA workflow for Invoice Adjustment Approvals returns error when clicking the pop out button
Hub IVA workflow for Invoice Adjustment Approvals returns error when clicking the pop out button
More like this
Error saving Invoice Adjustment detail data Process canceled when trying to adjust the GL accounts on a General Billing invoice
Error saving Invoice Adjustment detail data Process canceled when trying to adjust the GL accounts on a General Billing invoice
More like this
Error adding approval request in General Billing Invoice Entry and Proof
Error adding approval request in General Billing Invoice Entry and Proof
More like this