How to get Yield Field from BOM Maintenance Screen

Posted By Michael20070101 over 7 years ago

I am sorry. I cannot find MAS90 group so that I post this question under MAS100.

I have tried to figure out where the base quantity for Bill of Material in MAS90 system is stored. I was told that the Yield field in the Bill of Material Maintenance screen is the base quantity for the BOM. See the circled number (137.67) in the picture below.

I tried to search this number in MAS90 database. However, I cannot find it in any BOM related tables or item master tables, such as BOM header and BOM detail tables. Does anyone happen to know which table this number might be stored in MAS90? or maybe this is a calculated field. Does anyone know how it is calculated from?

Thank you very much.

0 StefanouM over 7 years ago

The field "Yield Percent" is located in the BM_BMHeader If you are on an older version of Sage 100 called MAS 90 or MAS 200, it may be called "BM1".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 7 years ago in reply to StefanouM

That "Yield" may be a custom field / UDF. Edit the value, save, then look in the \MAS90\MAS_###\BM\ folder for the file just updated and you'll find the place that is stored.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steve Passmore over 7 years ago in reply to Kevin M

In versions 4.30 and older, User Defined Fields added to the Bill of Materials header would be stored in BM_95.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Michael20070101 over 7 years ago in reply to Steve Passmore

Thank you for your suggestion. Our version is 4.30 but I cannot find a table BM_95 by using ODBC driver.

I also tried Kevin's suggestion by changing a little bit this field and saving the change. But when I check the last modification date under BM folder, I do not see any date changed to today's date.

I will keep digging. but thank you for the help.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steve Passmore over 7 years ago in reply to Michael20070101

BM_95 is the physical table (the file name would be 'BM_95' + <company code> + ".SOA". The problem is that file is not accessible through ODBC.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

How to get Yield Field from BOM Maintenance Screen

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING