Hi
I need help in solving the below issue.
I have stock of product say "X" 100 units.
I have 5 different orders for 80 MT.
This stock should get adjusted to these orders with certain criteria say earliest ordered date.
like this I have n number of products and there will be orders for these stocks. some orders might not have stocks.
all these are in one single table.
is there a way out by assigning any formula or do we need to write a macro.
Rgds
Shankar
I need help in solving the below issue.
I have stock of product say "X" 100 units.
I have 5 different orders for 80 MT.
This stock should get adjusted to these orders with certain criteria say earliest ordered date.
like this I have n number of products and there will be orders for these stocks. some orders might not have stocks.
all these are in one single table.
is there a way out by assigning any formula or do we need to write a macro.
Rgds
Shankar