Troubleshooting: Custom fields' Value Are Blank after being Added to the table

Problem Description

When recently added Custom Fields to the Purchase Order. The fields appear in the PurchaseOrderLine table as CustomFieldPurchaseOrderLineTEST, CustomFieldPurchaseOrderLineGroupTEST, and CustomFieldPurchaseOrderLineGroupLineTEST but return no data. We have the optimizer set ON with "The start of every new connection (with "Load Updated Date" first). I manually ran the Load Updated Data this morning and still have no data.

Solution

Please turn off the optimizer and rerun the same query in QODBC Support Wizard to see if you can get the custom field records. If so, try the question below to optimize the PurchaseOrder table as an option manually:

sp_optimizefullsync PurchaseOrderLine

Or reset the optimizer file via How to switch OFF or RESET the QODBC Optimizer.

See also: How to set up QODBC Optimizer and where are the Optimizer options.