Feature - Added Phantom Locking to Item File Maintenance

Release date: 6/4/2018

In the past, when a user brought up an item master record in Item File Maintenance Change mode, the item record would be locked.  Any other users who tried to update that item record -- including quantity on hand, on order, or allocated -- would receive an Item Record Locked message.  In many cases, the user who brought up the item master record in Change mode -- and who without realizing it, had locked the record -- could stay in the Change mode for an extensive period of time, and thus cause operation problems for other users.

In this update, we introduce "phantom locking" logic to the Item Master Maintenance program to reduce locking conflicts.  That is to say, the system now does not lock the item master record after a user brings up that item in Change mode.  Instead, the system will check if the changes to the item master can take place.  If no other user changes the item master in between, then the changes are updated back to the item master.  Otherwise, a conflict message will be displayed.  The user will need to make their change again.  This mechanism also nudges the user to finish their change in item master quickly without hogging that record.  This is good behavior that we like to encourage for other areas where "phantom locking" is not yet applicable.

There are new situations where updates of the record will not be possible and an error message will show the reason.

Item File Maintenance (IM0101) error posibilities:

1) "Record Locked By Another User. Update Aborted. Try Again." - If an update or delete

of an item is attempted but the record is locked by another user.

2) "Item xxxxxxxxxxxxxxx Changed By Another Workstation, Changes Not Saved" - If an

update or delete of an item is attempted but the record has been changed by another

user.

3) "Record Locked By Another User. Try Again" - If an item number is entered and that

item is currently locked by another user attempting an update.

Modified program: IM0101

DLM

• Related Articles

• Feature - Added Phantom Locking to Customer File Maintenance

  Release date: 6/4/2018 In the past, when a user brought up a customer master record in Customer File Maintenance Change mode, the customer record would be locked. Any other users who tried to update that customer record -- including when printing a ...

• IM0101 Inventory Management Item File Maintenance 1

  Maintenance Item File Maintenance Application Overview Any inventory system, whether it is manual or computerized, must have some way of recording what parts are in inventory, and in what quantity. In fact, this record of what is in inventory is the ...

• IM0101 Inventory Management Item File Maintenance 2

  Forecasting Forecasting accurately how much of an item you are going to need at some point in the future can be very important to a company's profits. If the forecast for an item is too high, too much of it may be produced and then have to be kept in ...

• Feature - Added Item Price Mismatch Event in Sales Order Import

  Release date: 4/19/2022 Version: 8.5 and Up You can now subscribe to the Item Price Mismatch Event in Sales Order Import. This will trigger an email when there is a price discrepancy between the import price for an item and the calculated price in ...

• IM0101 Inventory Management Item File Maintenance 6

  Manufacturing Data - Third Screen This information will only be displayed if the I/M Setup manufacturing flag is set to Y. Name Type and Description 70. Average Error A standard quantity format. This is the average deviation between the forecasted ...