LOOP in SCRIPT

[#1]

Hi together,

I'll hope someone can help me.

I have to create Stock Transfer Orders. for example

2 items X and Y
3 companies A, B, C

company item onStock Sell_last_30days TRANSFER
A X 30 10 +20
B X 4 10 -6
C X 2 20 -18
A Y 4 20 -16
B Y 10 5 5
C Y 2 4 -2

I want to get a table like this:

comp item TransferOut TransferIN
A X 20 0
C X 0 18
B X 0 2 (because we have only 20 TransferOut)
B Y 5 0
A Y 0 5

Thanks for any help......

[spsrk_84 · Accepted solution]

Hi,

Can u explain the base table structure i mean how the actual table looks like ,from which u want to create the table1 and table2..

if possible attach the data file .......

Cheers,

Ajay

[#3]

Hi Ajay,

I've mad some XLS Files. I think i have the solution, but could you please check my
code. I think this must be done easier.

thanks

Wolfgang