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

    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
    • How To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • How To: Update Items Store Availability via the Balto Import Tool

      This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • Yellow Dog/Jonas File Exchange Overview

      This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...
    • Yellow Dog/Jonas API Overview

      This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...