Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Inventory Allocation

Hi all,

I am looking for a best practice to allocate available inventory from a plant-inventory table to a set of orders, which will need to be prioritized by the scheduled date of the order. It will only fill the order in the column "Available Qty" if the remaining inventory can fill the entire order.

Example Table of Inventory:

Material
Plant
Inventory
100-1A1,000
100-1B10,000
500-2A500
500-2B0

Table of Orders:

Order Number
Material
Plant
Order Qty
Delivery Date
1100-1A1,0001/5/2013
2100-1A5,0001/7/2013
3500-2A101/10/2013
4100-1B20,0002/1/2013

Final Expected ResultOrder

Order Number
Material
Plant
Order Qty
Available Qty
Delivery Date
1100-1A1,0001,0001/5/2013
2100-1A5,00001/7/2013
3500-2A10101/10/2013
4100-1B20,00002/1/2013

Number

Order Number
Order Number

1 Solution

Accepted Solutions

Re: Inventory Allocation

See attached qvw.


talk is cheap, supply exceeds demand
1 Reply

Re: Inventory Allocation

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser