BOM Items

[Chris Kelleher]

SL4.0.2
Is there a quick way to access all items in all BOM's? I wanted to
programatically set the backflush flag so a user didn't have to do it
manually, but I don't see a 'bill of materials' table in the schema.

~~~~~~~~~~~~~~~~~~~~
Michael Fisher
IT Developer
Wallingford Electronics
~~~~~~~~~~~~~~~~~~~~

 

[Chris Kelleher]

All data is in the jobmatl table. Look for jobmatl of job with a type of
"S". If you are on standard costing then the current job has a suffix of
000 and the standard job has a suffix of 001. All other costing types, look
for the suffix of 000.

 

[Chris Kelleher]

Don't forget to look at the backflush location if you want to change this
also, and you need to also investigate the item master to allow backflushing
of the item.

Marty Sosso