Safari
Member
- Local time
- Today, 18:11
- Joined
- Jun 14, 2021
- Messages
- 95
HI ALL
IF YOU PLEASE I WANT YOUR HELP TO COMPELET MY QUERY
I WANT TO ALLOCATE THE QUANTITYOUT FILED ON QUANTITYIN , I UNDERSTAND THE IDEA BUT ITS HARD FOR ME ..
FOE EXAMPLE:
ID Transactiondate Itemcode itemname QuantityIn QuantityOut AllocateQuantity
1 01/01/2000 1 Apple 50 50
2 01/02/2000 1 Apple 100 90
3 01/03/2000 1 Apple 100
4 01/04/2000 2 orange 50
5 01/05/2000 1 Apple 60
I WANT TO ALLOCATE ( QUANTITYOUT ) 60 UNIT TO QUANTITY IN ( 50 + 10 )
AND THE BALANCE IS RUNNING IN NEW COLUMN 50-50 =0
100-10 = 90 ... ETC
HOW CAN I DO IT
I ATTACHED MY DB DO EDIT
IF YOU PLEASE I WANT YOUR HELP TO COMPELET MY QUERY
I WANT TO ALLOCATE THE QUANTITYOUT FILED ON QUANTITYIN , I UNDERSTAND THE IDEA BUT ITS HARD FOR ME ..
FOE EXAMPLE:
ID Transactiondate Itemcode itemname QuantityIn QuantityOut AllocateQuantity
1 01/01/2000 1 Apple 50 50
2 01/02/2000 1 Apple 100 90
3 01/03/2000 1 Apple 100
4 01/04/2000 2 orange 50
5 01/05/2000 1 Apple 60
I WANT TO ALLOCATE ( QUANTITYOUT ) 60 UNIT TO QUANTITY IN ( 50 + 10 )
AND THE BALANCE IS RUNNING IN NEW COLUMN 50-50 =0
100-10 = 90 ... ETC
HOW CAN I DO IT
I ATTACHED MY DB DO EDIT