Job description
I will commission a SQL report for SUBIEKT NEXO PRO
calculation works on the principle of :
Check the stock
check the minimum stock of this assortment
check the bookings on ZK
check how much assortment is ordered on ZD
so for example 1 :
stock is 200
minimum stock is 100
reservations on ZK is 99
on ZD 0
then the column quantity to order will show 0 ( because it is above the minimum stock )
example 2 :
stock is 200
minimum stock is 100
reservations on ZK is 150
on ZD 0
then the column quantity to order will show 50 ( because it is below by 50 pcs from the minimum stock )
example 3 :
stock is 200
minimum stock is 100
reservations on ZK is 150
on ZD 10
then the column quantity to order will show 40 ( because it is below the minimum stock by 40 pcs )
In addition, I would like this report to still have a "keeper" for this assortment - pulled from a custom field and / or commodity group.