Article ID: 36163
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.
If the workpaper is still locked after waiting 5 minutes, contact MYOB Client Accounting support on 1300 555 666 and quote KB 36163.
MYOB INTERNAL STAFF ONLY
In the VPMSER (also called AEDB1 or AODB1) 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 (i.e 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.
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.
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.
e.g. How to delete an invoice.
Just the online help, not phone support or the product itself.
Give us a call or speak to us on LiveChat
Check out our help for how-to information and feature overviews.
See what other users are talking about and ask your own questions.
Watch quick videos
Copyright © 2017 MYOB Technology Pty Ltd. All rights reserved