We had our DB converted by Epicor and all seems fine. We knew that we would have to fix/change some custom reports. I have several updateable BAQ’s that have errors. The errors seem to think that some fields don’t exist. Once is a BAQ that is updating some UD fields. These fields do exist in UD Maintenance and I have run the data model Regen again. Still gives me errors. I am really not sure where to go. It appears that the updateable BAQ creation has changed in E10 from E9. Here is the error I see…
Can you check what is in the Column initial expression for Character01 and Number01 via
Think there must be an invalid expression there.
I checked Column expression and got this error. I wonder if this is change between E9 and E10? In E9 it has ttResults…I would think there conversion could convert this…some came over and others didn’t.
We’re in the process of updating from 10.1 to 10.2 so I thought I’d check the difference …
From the help file in 10.2:
“The ttResult variable is not allowed in Initial Expressions. It causes errors when the Check Syntax, BAQ Analyze, or query validation (on save) action is performed and is not supported by auto-complete. The presence of ttResult is not verified during import so legacy queries may be imported without any errors.”
It was allowed in 10.1, but it appears Epicor have decided that default values can’t depend on other fields in a new row, which I can understand from a technical point of view but looks like it leaves a problem if that’s what was done previously.
I am not sure what was issue with conversion but I updated the DLL under menu maintenace and now it works. I did some other things too like check all Updatable BAQ Method Directive and Updatable BAQ Maintenace and deployed.