Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fill Rate
- Thread starter Zbob
- Start date
Zbob,
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
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
- Status
Similar threads
- Locked
- Question