Can anyone give me waterproof, correct query criteria required for fetching open Purchase and/or Sales Order Lines in Baan (tdpur401 & tdsls401). By open I mean lines which still have at least 1 piece to still be delivered.

This is always a hassle, and purchase & sales don't work in the same way.

It is rather hard to find waterproof rules and selection criteria. Often after running certain queries there seem to be some exceptions which are not correctly handled by the query. I think many of us could benefit from these exact criteria.

Thanks in advance,

Eli Nager

Hmmm - it is difficult and nothing is perfect(at least in the purchasing area). I can not imagine any code that would work 100% of the time. Plus doesn't some of this depend on how your system is setup? I do know that with different users we have used different queries to define what is open. So in one case(just an example) anything with a back order might be open and in another it would be considered closed.