UD Boolean field error?

ERP 10
1

Opening Sales Order Entry in Epicor shows value of a UD Boolean field represented by a checkbox to be false ( Unchecked). Doing a BAQ on the OrderHed shows the UD Boolean field to be false (unchecked). Everything looks great.

Opening the OrderHed view in SQL shows the value to be true. Opening the OrderHed table, finding the SysRowID and matching it up to the OrderHed_UD table using the ForeignSysRowID, shows a value of True. How is this possible?

Epicor 10.1.400.18

2

Are you sure you have the correct record queried in SQL? Dumb question I know…

3

Aaron, No question is a dumb question. My SQL guy was supposed to be working in the test database but used a view from production. There is no Epicor error.

2 Likes