Sage 300 can display the error "Sales Analysis Column name and number of supplied values does not match table definition." after an upgrade. This issue occurs when table changes are missing from the [Company]UNI database.
An upgrade missed required table changes in the [Company]UNI database.
To verify the issue:
- Open Microsoft SQL Server Management Studio, and expand the [Company]UNI database.
- Locate the UXARINVH table.
- Expand the table, and then expand Columns.
- Verify these columns and data types:
- SFPAURL char(100)
- SFPAID char(36)
- EDN char(30)
- If any column is missing or a data type is incorrect, run an ALTER scripts below.
CAUTION:
Sage Software doesn't assist with database repairs. Back up the [Company]UNI database before you run any database repair script.
Use the following script to recreate the columns:
ALTER TABLE UXARINVH DROP COLUMN SFPAURL -- You don't have to run if the SFPAURL column is present
ALTER TABLE UXARINVH DROP COLUMN SFPAID -- You don't have to run if the SFPAID column is present
ALTER TABLE UXARINVH DROP COLUMN EDN -- You don't 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)
- Solution ID
- 240207183449057
- Last Modified Date
- Wed Aug 19 17:52:52 UTC 2026
- Views
- 0