Perform Authomatic Calculation on tables

Business Central/NAV Developers Forum
1

I have a table with employee ID, timein, timeout and total time columns. I have imported the ID, timein and timeout column. The total time is not imported and it is zero. But when i modify any value on either the timein or timeout, then the total time is calculated.Doing this for 1000’s of records could be tidious.

Is there any way i can do this on a large record very fast?

thanks

2

The calculation is apparently called from the OnValidate-trigger of either of the fields.

Create a report - processing only.

Let this report loop through the imported records, and do a validate on e.g the timein-field.
Remember to also do a modify, to store the total time value calculated.

3

Thanks. I created a code unite to do it. Here is my code

Stafftimesheet.RESET;
IF Stafftimesheet.FINDSET THEN
REPEAT
Stafftimesheet.VALIDATE(“Time Out”);
Stafftimesheet.MODIFY(TRUE);
UNTIL Stafftimesheet.NEXT = 0

but i am getting errors. It says the time is not not.

4

Its working now. Thanks [:)]