I noticed this question from Chandra as a comment on our popular discussion thread from 2009: Useful SAP B1 queries
We need to skip the non inventory item for QC approval.
Based on the OITM inventory Y/N provide the query to add in GRN approval.
in 10 GRN rows if any one item is haveing the inventory Yes it need to proceed for approval.
in 10 grn rows all items are non-inventory items, skip the approval
Richard, can you help?
Retrieving data ...