Can anyone help me to build a workflow to assign order volumes to contract month lines?
The idea is:
I have an order file and a contract file. Key in both is customer and product, I need to assign an order to a contract month line where the rule is, -->use older month lines first and order volumes cannot exceed the contract month line volume, orders can not be divided over two month lines. If order is bigger then the first available month line, then try second month line etc. After order 1 is placed on a month line, then order volume should be deducted from the month line volume and the second order can be linked. The output should be : 1) which order is linked to which contract month line? 2) which orders could not be assigned with a reason a) month line volumes are too small or b) no applicable contract in place
I attached example data. Would be great if somebody could help, or point me into the right direction
