Sum Routing Line table field

Veselin

Hello.
I need to sum a field real time, where center no is M-150.
I need to do it without flowfield.

I make this, but gives me only 0 as result.

Routing Line table -> new field -> Sum M-150 as decimal field
Routing Line table -> new funcition -> SumTotal150
Variables for this funcion -> RoutLine, datatype is record, subtype is Routing Line

Code:

RoutLine.RESET;
RoutLine.SETCURRENTKEY("Routing No.", "Work Center No.");
RoutLine.SETRANGE("Routing No.","Routing No.");
RoutLine.SETRANGE("Work Center No.", 'M-100');
RoutLine.CALCSUMS("Real Time");


Save this result.

I go to my new field Sum M-150 on validate() and place there name of the function like this -> SumTotal150;

Result is everything 0

Where do I make a mistake?

TallyHo

Classic client:

TallyHo

Add a return variable to funtion SumTotal150.

add
exit(RoutLine."Real Time");
as last line of the function.

Put the function SumTotal150 in your page, where you now put the field "Sum M-150".
Set the page field to editable FALSE.

bostjan.les@gmail.com

Some code snipet pls

Veselin

bostjan.les@gmail.com wrote: »

Some code snipet pls

new field Sum M-150



onvalidate field Sum M-150



function

Veselin

TallyHo wrote: »

Add a return variable to funtion SumTotal150.

add
exit(RoutLine."Real Time");
as last line of the function.

Put the function SumTotal150 in your page, where you now put the field "Sum M-150".
Set the page field to editable FALSE.

Nothing changed.

TallyHo

Do not put the function in onvalidate of the field.
Add the function to the form or page, just like you added the field like this:

TallyHo

Classic client: