Symptom
Error in Day Closure Run: “Creation of period closure date for employee XYZ failed. No valid offsetting acct found for source account ABC (YYYY.MM.DD - YYYY.MM.DD) on YYYY.MM.DD”
Subsequently, when trying to Adjust Time Account Rules and setting the Period end rule of time account to Set to zero, there are many errors as :
"Labor resource assignment mandatory for project time confirmation on YYYY.MM.DD"
Reproducing the Issue
-
Go to Time Administration
-
Select the Employee and Click on Edit
-
Go to Time Profile Tab
-
Select Adjust Rules
Cause
"No valid offsetting acct found for source account ABC (YYYY.MM.DD - YYYY.MM.DD) on YYYY.MM.DD"
This error message comes up because a time account rule is trying to post something from one account to another one but the posting on the date YYYY.MM.DD. An example would be a carry forward of hours from one account to the next years account while you have already closed the account / delimited the bookable period for the next years account (Time accounts tab, bookable to) to a date before the posting date
"Labor resource assignment mandatory for project time confirmation on YYYY.MM.DD"
This error message is telling us that there are labor resources assigned to a time recording that might have changed. The system will retrigger the valuation and detect the changes in the labor resources.This change also means that any carry forward from those years forward (This does not remove the time account. It only gets rid of the error of the period closure run as there is no carry forward anymore. )
Resolution
The proper way to remove a time account that you do not want to use anymore would be to close the time account of the previous year.
This should have been closed at the end of uear and the value should have been set to zero. Then you need to create a new time profile split that starts on the the current year that does not have the time account anymore (You can copy the old time profile and only remove the time account). This is to make sure that the time account does not get created anymore.
- Close the Time account to the end of the previous year ie. YYYY.12.31 and Set the Posting Type to "Set to zero"
- Save it
- Copy the Time profile
- Change the Start date of the newly created time profile split to the beginning of current year ie. YYYY.01.01
- Save it
- Remove the Time account rule in the new time split that starts on the YYYY.01.01
- Save it
After performing the above steps and Day Closure Run, the issue should be resolved.
Keywords
Time Account Rule, Day Closure Run , KBA , SRD-HR-TLM , Time and Labour Management , Problem