Need more help?

HTML Wrap

class	section group

HTML Wrap

class	col span_3_of_5

div

id	rnwid

Article ID: 36163

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

HTML

<!--Product families-->
<div style="display: none;" data-swiftype-name="productFamily" data-swiftype-type="enum">Accountants Office Suite</div>
<div style="display: none;" data-swiftype-name="productFamily" data-swiftype-type="enum">Accountants Enterprise Suite</div>
<!--Countries-->
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">Australia</div>
<div style="display: none;" data-swiftype-name="country" data-swiftype-type="enum">New Zealand</div>
<!--Product capabilities-->
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">Workpapers (NZ)</div> 
<div style="display: none;" data-swiftype-name="productCapability" data-swiftype-type="enum">AE Workpapers (AU)</div>

div

id	rnwdate

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.

div

class	internalnote

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.

HTML Wrap

width	15%
class	col span_1_of_5

HTML Wrap

float	left
class	col span_1_of_5

div

id	id

div

id	date

div

id	productlist

Page tree

Versions Compared

Old Version 1

New Version 2

Key

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

Was this information helpful?

Why not?

How would you improve this page?

Thanks! Anything you'd like to add?

Need more help?

Learn about MYOB Practice Solutions

Community Forum

Videos