Skip to Content
0
Former Member
Jan 06, 2011 at 11:11 AM

After 8.8 Upgrade Invalid Column Name error on UDF in Sales Order

24 Views

I have upgraded a dtaabase from 2005A to 8.8 SP00 PL15.

I encountered a UDF/UDT warning (Note 1360832) in the Pre-Upgrade CHeck but proceeded in any case.

After the upgrade as soon as I enter the BP in a Sales Order, I get the following error.

[Microsoft] [SQL Server Native Client 10.0] [SQL Server] [Invalid Column Name U_CampPB1.2)

[Microsoft] [SQL Server Native Client 10.0] [SQL Server] Statement 'Withholding Tax' (OWHT) could not be prepared.

This UDF was one of many reported in the Upgrade Wizard Log File as having an incorrect Type.

" Type is different; Should be A, Is M".

There are hundreds of instances of this message in the log.

I don't know whether the error is related to the Type is different warning.

I don't get the error when I add an AR Invoice.

In addition I cannot find any documentation on the different UDF Type codes.