Tax Bills Adjustment Failure Bill Posting getDefaultDiscountRuleIdForBillAndChargeId
- Knowledge Assistant
When adding new Charge codes to a Real Estate bill through the Tax Bills program, an error occurs during the Bill Post.
Failure bill posting.
Error occurred adding line.
ERROR EXECUTING THE SQL STATEMENT getDefaultDiscountRuleIdForBillAndChargeId.
Failure bill posting Category: XX, Bill Year XXXX, Bill Number: XXXXXXXX. See error log for specific errors.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value 'X.0 ' to data type int.
MD Property Tax Billing
Tax Bills
Real Estate
Charge Codes
Related to the Charge code being subject to discount.
Bills created in a version prior to 2021+ and migrated to 2021+ will not have a discount rule assigned to the charge or bill line on the back end.
Development is currently researching the issue.
Current workaround at this time is to unselect the Discount checkbox on the Charge in the Charge Code's program before creating the Adjustment. Reselect the Discount checkbox after the Adjustment has been Bill Posted and GL Posted.
For versions 2021+, if there is only one charge code that is subject to discount, the discount rule can be set up in Tax Year Settings and this will allow the adjustment to get Bill Posted without error.
Contact Enterprise ERP Tax Support for further assistance.