Error: "Period X to Y is locked by " when opening a Workpaper period
Accountants Office Suite
Accountants Enterprise Suite
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 STAFF ONLY
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.
Was this information helpful?
How would you improve this page?
Unfortunately, we won't be able to respond to your feedback. Please don’t enter any personal information—if you need urgent help, contact our support team instead.
Thanks for your feedback.
Thanks! Anything you'd like to add?
We’d love to know what worked so we can keep improving our help. Please don’t enter any personal information—if you need more help, get in touch with our support team.
Did you find what you were looking for? *
What are you looking for help with? *
e.g. How to delete an invoice.
Overall, how satisfied are you with this help centre? *
Just the online help, not phone support or the product itself.