Message Boards

Fill rate metric based on item availability at time of order

Jared Housley, modified 3 Years ago.

Fill rate metric based on item availability at time of order

Post Date: 11/29/17 (Bronze, 1 Post) Recent Posts

My company has just implemented 2016 EE at one warehouse site and everyone here, including me, is new to QAD.  We are trying to get a metric for Fill Rate that we use for our other warehouses.  We define Fill Rate as: per line, the items coded as A, B, C, or D is in the warehouse at the time the line is entered.

Example: A customer calls for 50 of an item and it is in stock, then good (100%).  Another customer calls for 30 of an item and only 25 are in stock, then it is bad (0%).  Our fill rate is 50%

Any help anyone could give me on how I might accomplish this would be appreciated.  I would like to do this without any programming since I am not a programmer; however, I can create and modify browses, though.

thumbnail
Phill Norrey, modified 8 Years ago.

Re: Fill rate metric based on item availability at time of order

Post Date: 11/30/17 (Yoda, 1010 Posts) Recent Posts

I assume from your comment that you are in a make to stock environment.  So when a S/O is taken you should already have the inventory there?  So this also means that you try to satisfy orders on the date the order is taken?  So based on how you measure there are numerous ways you could get the data.  For example look at Sales Order Tracking Inquiry.  You see the results from a shipment as an invoice and there you can see the qty ordered, qty shipped.  You can also see the different dates, e.g order date, due date, ship date etc.

QAD holds history in a lot of detail.  So for example you could create a browse based on tr_hist for transaction type "ISS-SO" and pull data from there in a browse.

thumbnail
Raymond Chin Kwie Joe, modified 8 Years ago.

Re: Fill rate metric based on item availability at time of order

Post Date: 12/3/17 (Rhodium, 825 Posts) Recent Posts

Since you are new to QAD, I would advice you to get an online training on the Metrics tool (hyperlink)..

There are many courses start with the overview to get an idea of what you can expect.

thumbnail
Raymond Chin Kwie Joe, modified 8 Years ago.

Re: Fill rate metric based on item availability at time of order

Post Date: 12/3/17 (Rhodium, 825 Posts) Recent Posts

Regarding your question, depending on "when" you want to know something data is stored in a different table/file.

For example: is the file rate based on what you "want to ship" or what you "have shipped"?

Or is the fill rate also based on "due date"? If you want 100 pieces on the 20th of the month (due date) and today is the 10th. Is there a fill rate calculation and what is it?

If you have defined all these questions it is advisable to hire a consultant who can help you (initially) find the data files.

After this first start you can find more help in the QAD manuals. (database definitions / file relations)

NOTE: In 2016 there are many standard metrics available. type "metrics" in the menu bar.

Message place holder