Identify missing products for forecasting

[lizzie]

Greetings

Would love to hear suggestions as to how to solve the following problem:

Everybody prints to a networked printer. As such, it is imperative that we have stock of all consumables at any one time.

I thus created a subsummary report which identifies the unused consumables in stock. The next step is to identify those consumables that aren't in the subsummary report so as to flag those as "super urgent" stock to be ordered.

My mind is completely obsessed with combinatorics and I cannot see another way of identifying what consumables are missing from the subsum report.

I'm looking for a change in direction! Surely there is an easier way to identify the "missing parts"?

I have attached an exported version of my report thus far!

Any help or advice would be great! Haven't got stuck into FM for a while and I seem to keep hitting brick walls!

Phaser.fp7.zip

[Fitch]

Using GTRR(all) and Show Omitted, I believe the attached may work for you.

Phaser.zip