Troubleshooting: Custom fields Value Are Blank after Added to the Table

Problem Description

When recently added Custom Fields to the Purchase Order. The fields show up in the PurchaseOrderLine table as CustomFieldPurchaseOrderLineTEST, CustomFieldPurchaseOrderLineGroupTEST and CustomFieldPurchaseOrderLineGroupLineTEST but returns 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 then run the same query again in QODBC Support Wizard to see if you could get the custom field records. If so, try the query below to manually optimize the PurchaseOrder table as an option:

sp_optimizefullsync PurchaseOrderLine

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

See also: How to setup QODBC Optimizer and where are the Optimizer options