Bill of Material Components MSSQL Table?

(0) Share

Report

Posted on by Dezryth

Hello Forum, First post!

I'm wondering if anyone can direct me to the right MSSQL table used by Great Plains for the Bill of Materials Entry window. I'm currently trying to create a function that I can pass a BOM item-number and will return a table of all the components required to build it.

Thanks for any help!

*This post is locked for comments

All responses (3)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Bill of Material Components MSSQL Table?

Although this is resolved, but I like to add additional piece of information for the the general benefit since you are working with BOM. When it comes to BOM on the SQL level, I recall Mr. Mariano's great achievement on Using T-SQL and recursive CTE to generate a BOM tree

Addition great resource Recursive Querying in SQL Server
Dezryth 90 on at

Like (0)

Report

RE: Bill of Material Components MSSQL Table?

Thank you! This confirmed what I suspected but I wanted to make sure.
Verified answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: Bill of Material Components MSSQL Table?

I believe you need BM00111 – Bill of Materials Component.

An excellent reference for GP tables can be found at www.victoriayudin.com.

Regards,

Kirk