Troubleshooting: How do I resolve the issue of an item being locked by a purchasing document?

Troubleshooting: How do I resolve the issue of an item being locked by a purchasing document?

Issue: Item cannot be updated because the item is “locked by a purchasing document”. 


Resolution: Use the Items Locked report to determine which purchasing document(s) the item is on, and zero out the quantity to resolve the on-order quantity that is locking the item and allow it to be updated.  Note: This task will require edit after commit permissions. If you do not have edit after commit permissions, you will need to see your onsite admin. 


  1. Navigate to Standard reports>Troubleshooting>Items Locked



  1. Select Generate. Note: This report does not have filters and will return every item locked. 


  1. Right Click in the column header SKU or Item Description and select Apply Column Filter


  1. Enter the SKU or description for the item in question into the pop up and select OK

 

  1. The item entered will return an entry for every purchasing document the item is on. Right Click column header Locked By and select Copy Selected Cell to copy the purchasing document number. 


  1. Navigate to Purchase Orders in the Purchasing area of Yellow Dog and right click to Paste, or Control-V to paste the Purchasing document number copied from the items locked report into the search bar 




  1. Double Click to open the Purchase Order, navigate to the item in question and update the qty to 0. Select Save & Close in the bottom right. 


  1. If you are unable to update your item immediately, hit refresh data at the top of Yellow Dog and try updating again. 





    • Related Articles

    • Troubleshooting: How to I resolve the issue of not being able to add an item to a purchasing document?

      Issue: The item is active, but I am unable to add it to a purchasing document  Resolution: Confirm that the item is configured to be added to purchasing documents. Note: Other Details tab in the item editor is required to perform this task. If you ...

    • COGS Troubleshooting

      This document was designed to help users pinpoint where and why there are discrepancies in their COGS reporting.  Why COGS are inaccurate: If COGS numbers are appearing incorrectly in Yellow Dog one of the following will be the cause: Invoices were ...

    • Troubleshooting: How do I start investigating variances in my physical?

      The first place to start investigating variances in your physical is an Item History report. This report will provide detailed information regarding when your item was purchased, received, manually adjusted, sold & inventoried. Variances are most ...

    • What are Yellow Dogs best practices for catching up on purchasing?

      Yellow Dog understands that every team is busy, and sometimes things fall through the cracks. Below are Yellow Dogs best practices for when you need to catch up on purchasing.  Purchase Orders:  Review the items locked report. This can be located ...

    • How do I navigate the Purchasing Module?

      Purchasing The Purchasing section of Yellow Dog Inventory enables users to handle every aspect of the “Purchasing Flow.” Each purchasing screen has filters at the top. The main filters are for Store, Vendor, Status, Committed Date Ranges and the ...

    • Recent Articles

    • Feature Overview: Client ID

      What is a Client ID? The Client ID is a unique identifier assigned to each Yellow Dog Inventory system. Who is it for? The Client ID will be used by any user that will access a Yellow Dog mobile or web app. What is it used for? A Client ID is ...

    • Feature Overview: Password Recovery

      What is Password Recovery? Password Recovery is a built-in feature that allows Yellow Dog users to securely reset their login credentials independently by answering predefined security questions. This self-service option reduces the need for ...

    • 377 Food & Beverage Webinar

      Curious about Yellow Dog Inventory version 377? New features, smarter workflows—watch the 377 Webinar now! Want to join the live webinar? We're hosting the 377 Food & Beverage Webinar weekly. Click HERE to sign up.

    • Feature Overview: Retail Price Fields

      Yellow Dog offers 3 different retail price fields (Default Retail, Current Retail, Starting Retail) in the item editor to provide different retail price tracking functions. Where: Item Editor > Retail Details tab Who: Retail users who manage retail ...

    • Yellow Dog/Silverware Integration Overview

      This document will provide an overview of the Yellow Dog Silverware Integration Integration Approach This can be setup as a 2Way – Push items and Pull sales or a 1Way – Pull sales Sales – Pulled from the Silverware API Codes – Pulled from the ...