MRP report Blank Title 59905

Michael,

Extract the following data via ODBC into Excel or Access (table names
are reflective of Vantage 6.1):

1. Open sales order demand by top-level part number (OrderHed, OrderDtl
and OrderRel tables).

2. Purchased parts (and possible manufactured sub-assemblies) from Part
and PartMtl.

3. On-hand quantities from PartWhse and PartBin.

4. Unreceived purchases from POHead, PODetail and PORel.

Next, use Excel IF or Access IIF statements to create
daily/weekly/whatever buckets for your sales demand.

Now use your demand buckets to drive child part demand derived from
parent-child and quantity-per-parent data from the PartMtl table. Pay
special attention to the depth of your BOMs. If you only have flat (one
level) BOMs, this will be an easy extract. If not, you'll have to loop
through the BOM structure until you run into a "Pull As Assembly" flag
on the child part (assuming your engineers configured the BOMs correctly).

Fold in your onhand data and on-order data from 3 and 4. Mix well and
bake for several hours.

Note, all of the above is non-trivial. If you have VBA expertise on
staff it can be done. Our particular solution involves dumping the
above data into Access, slicing and dicing with VBA, then presenting to
the user as an Excel spreadsheet for their personal analysis pleasure.
Given the amount of time we spent developing the solution, I am unable
to share it with my peers. However the road map I've presented is
accurate for Vantage 6.1.

have fun,
john





Michael McWilliams wrote:
> Before I go making this report, does anyone have something similar or
> know how to get it from Vantage 8.03. I do not have the MRP module.
> For every purchased part a cross tab by week that shows: Demand, On
> Hand, and On Order.
Before I go making this report, does anyone have something similar or
know how to get it from Vantage 8.03. I do not have the MRP module.
For every purchased part a cross tab by week that shows: Demand, On
Hand, and On Order.