11.3.4 Values for Employee Expenses didn't match
I applied all formulas correctly and check the data loaded, having a correct validation, but still the amounts where different from those in the sample image.
Checking the data in EMP02 Employee Expenses, for the Line Item Left? I identified that for all employees withe a Leave Date, had this checkbox marked, even if the Leave Date is in a future date.
This is the formula I had:
Start Date <= 'SYS00 Time Settings'.Last day of Month AND ISNOTBLANK(Leave Date)
And modify it with the following formula:
Start Date <= 'SYS00 Time Settings'.Last day of Month AND ISNOTBLANK(Leave Date) AND Leave Date <= 'SYS00 Time Settings'.First day of Month
Now data for all Employee Expenses line items are similar to the sample image