Error: "Sales Analysis Column name and number of supplied values does not match table definition."

The issue is a result of an upgrade that missed table changes to the [Company]UNI database.

To verify if this is the case, perform the following test:

1. In Microsoft SQL Management Studio, expand the [Company]UNI database and find the UXARINVH table

2. Expand the table, then expand the columns.

3. verify these three columns and their datatypes.

1. SFPAURL char(100)
2. SFPAID char(36)
3. EDN char(30)

4. If the columns are missing, or the datatypes are incorrect, an alter script would need to be run to repair the database.
Note. Sage Software does not assist in database repair, run the below script at your own risk, if you choose to move forward then backup your [Company]UNI database.

ALTER TABLE UXARINVH DROP COLUMN SFPAURL --may not have to run if the column is present.

ALTER TABLE UXARINVH DROP COLUMN SFPAID --may not have to run if the column is present.

ALTER TABLE UXARINVH DROP COLUMN EDN --may not have to run if the EDN column is present.

ALTER TABLE UXARINVH ADD EDN CHAR(30)

ALTER TABLE UXARINVH ADD SFPAURL CHAR(100)

ALTER TABLE UXARINVH ADD SFPAID CHAR(36)