Payments Report Invalid column name charge_group

Payments Report SQL Server Error

SQL Server Error Invalid column name 'charge_group'

• Munis

• Accounts Receivable

• Payments Report

• Reporting

In this scenario users will come across a SQL Server Error when running the Payments Report with a Charge Group range in the define and the Display only selected charges/charge group check box enabled. 

Currently support has escalated this issue to the Accounts Receivable Development team for review, research and resolution. This article will be updated as more information becomes available however in the interim, please see the workaround below. 

Workaround

The current workaround is to retain the current define but to disable Display only selected charges/charge group check box and remove the Charge Group range. Select the results, export the report to Microsoft Excel and use the Sort and Filter feature from within Excel on the Charge Code column to select only the charge codes that are within the Charge Code group the define was originally  intended to report on. For reference and to confirm what charges are within a Charge Group, please navigate to General Revenues>Accounts Receivables>Setup>Accounts Receivable Miscellaneous Codes>Charge Group Codes.