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

    • Reporting Explained: Troubleshooting- Items Locked

      Business Need: This report is helpful for customers who need to manage items that are locked due to being on a purchasing document. It also helps in locating the purchase order number for any item with an on-order quantity. How it works: When an item ...
    • 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 ...
    • 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

    • Yellow Dog/Spot On(Appetize) Integration Overview

      The document will provide an overview of the Yellow Dog Spot On(Appetize) integration Integration Approach The integration between Yellow Dog and Spot On (Appetize) can be configured to be a 1Way (sales pull only) or 2Way (sales pull and item push) ...
    • Yellow Dog/InfoGenesis Integration Overview

      The document will provide an overview of the Yellow Dog InfoGenesis Integration Integration Approach This integration can be setup as a 1Way (Sales Pull Only) or a 2Way (Pull Sales & Push Items) Sales – pulled in from a .txt file provided by ...
    • Yellow Dog/Shopify Integration Overview

      This document will provide an overview of the Yellow Dog Shopify Integration Integration Approach This integration can be set up in 4 primary ways: 1Way - pull sales only 2Way – pull sales and push on hands 2Way – pull sales and push items and on ...
    • Yellow Dog/Simpony2 w/Oracle Integration Overview

      This document will provide an overview of the Yellow Dog /Simphony 2Way integration Integration Approach The Yellow Dog/Simphony integration is a 2Way integration Sales – pulled in from files provided by Oracle once per day Codes – pulled from the ...
    • Yellow Dog/NCR Silver Integration Overview

      This document will provide an overview of the Yellow Dog/NCR Silver integration Integration Overview The Yellow Dog/NCR Silver integration is a 2Way integration Sales – Pulled from the NCR API Codes For reporting codes are pulled from the NCR API For ...