ALLOCATE QUANTITY (1 Viewer)

[Safari]

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

 

[arnelgp]

see running balance query.

 

[Safari]

see running balance query.

@arnelgp

THERE NOTHING CHANGE ITS THE SAME DB WITHLOUT ANY CHANGES
ALLOCATE QUANITITY EMPTY .. NO CODES
I WANT TO ALLOCATE 60 LIKE ( 50 + 10 ) IN ALLOCATE FILED

 

[Safari]

@arnelgp

 

[Safari]

@arnelgp

 

[Cronk]

See #3 first line in this thread