Query create on Master Data for the items that has not shipped

Hi all,

Is it possible to report/query on Items on Master Data that has not inoviced or has not been shipped?

Running query on Sales overview cube will not bring the right data since that cube only captures the items that was invoiced. Please help!

Thanks in advance,

BW

P:S Points will be assigned.