Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »





Article ID: 36163

Error: "Period X to Y is locked by " when opening a Workpaper period

Accountants Office Suite
Accountants Enterprise Suite
New Zealand
Workpapers (NZ)
AE Workpapers (AU)

ARTICLE LAST UPDATED: 3/10/2016 4:02:00 PM

In MYOB Workpapers you may experience the following error "Period X to Y is locked by <Username>" when opening a Workpaper period.

When a workpaper is opened the system locks that workpaper so that other user cannot open the same workpaper at the same time.

This lock automatically clears 5 minutes after you close the workpaper.
To resolve this error within 5 minutes of another user having closed the workpaper, you need to wait the 5 minute delay before attempting to open the workpaper.


MYOB Internal Notes:

In the VPMSER database view the dbo.WP_Lock table.

Where there is only 1 record, the lck_message matches the message you are experiencing. If it is > 5 minutes since the lck_locked date, ie the lck_duration is 300 seconds, delete this record.

If there are multiple records, determine the required record and delete only the record relating to the client code experiencing the issue.