Sage 100

Anyone else seeing this? (Note that if they never check their GL they may have the issue and not know it): ""Ever since we have update to SAGE 100 [2013, latest updates] we have an issue when updating daily labor. If anyone has time tracker or a job that has time applied to it open we get an error when updating. The only way to get out of the error is to kill it through task manager. After we make sure everyone is out when run the update again and it says it has been interrupted. We continue and it updates. We thought everything was okay because it seemed like it was posting to the work ticket correctly. When our CPA was checking the records for July it seems like it is posting to the work ticket once but to the G/L multiple times.

Is there a stated error, or does the update just hang?

Something like ""J/T work ticket in use update will continue to try."" but it doesn't even when everyone gets out, and the task can only be killed via ctrl-alt-del

Maybe the Activity log has recorded an error that may detail why the ""work ticket in use"" message displayed?

Look at JT_DailyLaborControl, do you see records with control key U, P and R with only a transaction date, delete these (3) and then update without issue. If these exist, you will get the message about the WT being in use. The multiple times in the GL are from processing the update multiple times.

@LisaDion - so DFDM those records while the in use message is up and it will then continue?

I haven't used this while the message was up, but I removed these after the first time with a ""in use"" message appeared and it didn't happen again.

Did you have to kill the task first?

They have had repeats but the file currently has 0 records

Yes, then removed those records. Sometimes killing this task jtd1XXX remains in sy0ctl and this needs to be deleted before updating

also check the validation report and correct any errors. Sometimes you get an ""in use"" message when it's actually a data issue.