finding sum as per date in dialog program

Former Member — Fri, 01 Feb 2008 09:30:47 GMT

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.

Re: finding sum as per date in dialog program

Former Member — Fri, 01 Feb 2008 09:55:05 GMT

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

topic finding sum as per date in dialog program in Application Development and Automation Discussions

finding sum as per date in dialog program

Re: finding sum as per date in dialog program