Creat a total on a field in a Dataport

dsi

I am trying to create a dataport that creates a file using the G/L Entry Table. I need to include a control record at the end of the file that sums the values in the Amount field. Is this possibe?

Sbhat

Sure, why not. Declare a variable for Amount called TotAmt.On the dataport OnAfterExportRecord TotAmt := TotAmt + Glentry(Amount)

Declare a variable called GlEntryFile Data type File

CLEAR(GlEntryFile);
glentryFile.TEXTMODE := TRUE;
glentryFile.WRITEMODE := TRUE;
glEntryFile.QUERYREPLACE := TRUE;
glEntryFile.CREATE(FileName);

glentryfile.write(format(TotAmt,0));

Cheers !
S.

dsi

Thank you