I have inherited managing and older BaaN IVc4 system. It seems the production team will use Generate Outbound for a range of orders to get a list of shortages, then cancel the outbound.......most of the time :mad:

Is there a built in Shortage Report in BaaN capable of this? Seems like this would be a standard feature.

If not, I am getting pretty good with the tables so what tables would I use to make my own Crystal Report?

I don't recall one - we created our own shortage reports. That is the one thing we did a whole lot of when we used 4C4 - create reports.

Do you happen to know the tables you pulled from? I know the Inventory tables to get the counts of what is on hand and on order. I just need some idea where to pull open requirements for shop orders.

Well what we did was use the planning table tipgc500 to generate our supply/demand table. So not quite that simple - so we generated this table daily after our GRP runs. It would pull in the supplies and net them. We were running - so these were all the baan tables it used. I am not sure you use the same tables as we do.

table ttipgc001 | Group Items
table ttipgc010 | Pegging Data by Group Item
table ttipgc820 | Build Item/Sub Item/Unit/CCN Link
table ttpptc100 | Project Elements
table ttipgc500 | GRP Planned Inventory Transactions

There is no standard report that do the job. Outbound is the way to really hard allocate to order and then look for shortages.