I am writing a SPOC and need help with the logic portion; please show examples
I need it to
1.Need a Stored Procedure that will scan the Item table for negtest items.
2.Once they are found look up the Itemloc record and find any negative quantity on Hand records.
3. Once found place into the test table for review in the negtest Error Processing screen.