Bill of Materials report

[hencyt]

This may be too broad of a question, but maybe someone can give me a jumping off point.

I need to write a report that will allow the user to enter a list of Bill numbers- the report will take that list of bills and explode them to the lowest level to find out if we have enough of each item (at each level) on hand to produce the current on SO qty of the top bill item.

Ideally it will also pull the on SO and PO qty and report how much is still needed to fill all orders in system for those items.

Are there any samples or examples out there that might help me start this?

I figure I will have to be using BM1 and BM2 for the most part, and probably aliases or views of each as well.

I would appreciate any advice!

Thanks in advance,
SunnyD

 

[Sorebrek]

I have made reports similar to this using MS Access with an ODBC connection to MAS. You can store the list of desired items in a table. Link to the BM tables to blow out your BOM requirements. You can then also link to PO or SO tables as you desired to pull those into the report as well.

Sorebrek.