finding sum as per date in dialog program

[Former Member]

Hi Experts,

i have problem with report,plz help me out

my problem is, i have a ddic table for which i createsd a screen to enter values into table,

n i kept buttons called GENERATE, UPDATE ,LIST.and fields in my screen are

BILL_OF_LADING TYPE ZRIN-BILL_OF_LADING,

ASSIGNED_RIN TYPE ZRIN-ASSIGNED_RIN,

CALENDAR_YEAR

EPA_COMPANY_ID

EPA_FACITILY_ID

RIN_BATCH_CODE

EQUIVA_VALUE

CELLULOSIC

START_GALLONS,

END_GALLONS

RIN_NO

TRANSFER_OR_EPA ,

FILL_DATE

VOL_TRANSFERED

so when i enter data through this screen there r two field called(END_GALLONS ) it should get SUM with previous END_GALLONS with respect to FILL_DATE , how to do that.its MODULE POOL PROGRMMING,plz help me out,very urgent.

[Former Member]

Hi

In the PAI event of the screen, retreive the END_GALLON value from table according to thegiven date and sum it to the screen value of END_GALLEON. Now process the PAI as per user input.

Regards

Vijai