If you do this, you will most likely need to read from both open (OEORDLIN and OEORDHDR) and shipped (OELINHST and OEHDRHST) tables.
There is another table to help you do this, the OEINQORD table, that tells you by way of the Ord-Fg field if an order is in Open Orders Only (flag="O", History only ("H" or both ("B"
Another thing to watch out for is that because of backorders, there could be multiple lines of data in the OELINHST and OEHDRHST tables for the same order line, and you will need to isolate these for the first shipment only.
Let me know if you have any questions.
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.