Hi all,
I need to make a function that calculates if the needed qty can be transfered.
My problem is that the function has to decide wather the warehouse is in prior to recieve the qty of goods according to reservation date
description:
i have a table1 with the following data
StockCode qtyrez warehouse date qtyneed centralwarehousebalance
123 5 01 2013.02.25 5 8
123 3 02 2013.02.27 3 8
123 2 03 2013.03.15 2 8
123 2 04 2013.03.01 2 8
for example i do an automatic calculation today(2013.03.27) from central warehouse to warehouse 03. Warehouse 3 need 2 qty of stockcode 123 but according to date this warehouse made reservation in newest date so it does not deserve to get that stockcode cause there are warehouses waiting for that longer. Does anybody have an idea how to write a function that would check if that warehouse can have qty of their goods by checking all other warehouse by reservation dates. my goal is to check and if i need to tranfere to show finaly the qty if i don't need to transfere to show 0
Thanks
I need to make a function that calculates if the needed qty can be transfered.
My problem is that the function has to decide wather the warehouse is in prior to recieve the qty of goods according to reservation date
description:
i have a table1 with the following data
StockCode qtyrez warehouse date qtyneed centralwarehousebalance
123 5 01 2013.02.25 5 8
123 3 02 2013.02.27 3 8
123 2 03 2013.03.15 2 8
123 2 04 2013.03.01 2 8
for example i do an automatic calculation today(2013.03.27) from central warehouse to warehouse 03. Warehouse 3 need 2 qty of stockcode 123 but according to date this warehouse made reservation in newest date so it does not deserve to get that stockcode cause there are warehouses waiting for that longer. Does anybody have an idea how to write a function that would check if that warehouse can have qty of their goods by checking all other warehouse by reservation dates. my goal is to check and if i need to tranfere to show finaly the qty if i don't need to transfere to show 0
Thanks
