Receiving an Error Trying to Update AP Aging Buckets (Internal)

Issue:

When trying to update the Aging Setup we receive an error that the number of supplied vales does not match table definition.

A screenshot of a computerDescription automatically generated

A screenshot of a computer errorDescription automatically generated

Resolution:

The error can be caused by an added field. We have seen an issue where there is an additional field in the table called Column_Zero_Heading_OPT. If this field is present the error will be returned.

--- Check table for Column_Zero_Heading_OPT column ---

select * from AR_Setup_Aging

--- Remove the extra field ---

ALTER TABLE AR_Setup_Aging

DROP COLUMN Column_Zero_Heading_OPT

Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.