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

Status
Not open for further replies.

Zbob

MIS
Apr 25, 2002
94
US
Anybody tried or done a fill rate report in an enviroment with many back orders.

Completed line/total lines=fill rate

First shipment only.

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top