There are absolutely no record locks or warnings of any type placed on worksheets that are opened concurrently in 2 different locations meaning that the contents and the status of a worksheet are defined by the person who closed it last. Let's say 2 people have an Inventory Transfer worksheet open at the same time and are adding product to it. User 1 finishes and saves the worksheet. User 2 closes it a few moments later. The changes that User1 made to the WS are overwritten completely. There is no record of his additions or changes. Subsequent opening of the WS shows it as how User2 left it.
It extends even further. Lets say User1 opens the Inventory Transfer WS at the end of the day and forgets to close it before leaving for the day. At the end of the day User 2 opens the worksheet on another system and approves it for processing. Overnight the WS is processed at the stores involved. Early the next morning the transfer orders are issued and receieved at the affected stores. Later on in the morning User 1 returns to his workstation still seeing the WS as he left it the night before, still unapproved. He may be edits it and saves it. The WS which was actually processed is now saved as unapproved. The History on the WS shows that it was approved, processed then edited again. This WS can then be approved again, sent down to the stores overwrting the original transfer orders which were already completed and closed. All this with absolutely no warning.
Headquaters should place a record lock on open worksheets to prevent this or at the very least place a warning when you try to open, save or approve a WS that is open elsewhere. It is ridiculous to expect a user to check with all his other colleagues who also have to access to worksheets before he goes to edit one to make sure it isn't open elsewhere.
Chris Zandbergen Factor One Technology
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.