Material status icon on job tree view and logic (SQL)

Epicor ERP 10
1

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?

2

Hi Jay,

Were you able to discover the SQL field relating to the status icon?

3

Posting for reference:

Table = JobMtl
Column = ShowStatusIcon

Seems to be, at least in my environment, that these are the only values listed:

ShowstatusIcon
Attention
AttnComp
BackFlush
Complete
MtlZero
MtlZeroI
Normal

1 Like