How does the material status icon (red) get displayed for shortages on job entry tree view? Is it based on a SQL field value or is it based on a calculated value?
Were you able to discover the SQL field relating to the status icon?
Posting for reference:
Table = JobMtl
Column = ShowStatusIcon
Seems to be, at least in my environment, that these are the only values listed: