Dynamics NAV/BC - Columbus Foods - How to fix Incorrect Quantity on Warehouse Shipment

• A number of Warehouse Shipment lines could not post because the picking was done for more Quantity or Alt. Qty than existed.
• To correct this, the following steps were taken
• Attempt to ship and invoice the Warehouse Shipment
• Get error message that the system cannot find sufficient stock in the lot
• Reverse the pick for that line
• Search for Registered Warehouse Pick List
• Find your pick>Click on the number to view the line details
• Select the line you want to reverse
• Click Line>Undo Selected Lines
• The system will automatically enter negative lines on the pick to reverse that specific line
• Check the actual stock available
• Items>Quantity on Hand and Qty on Hand Alt columns
• Adjust stock to the correct quantities if necessary (Research the correct reason before adjusting quantities)
• Go to Warehouse Physical Inventory Journal
• Process>Calculate Inventory
• Enter Whse. Document No.
• Enter any filters required>Click ok
• Edit the Qty. (Phys Inventory) and Qty. (Alt.)(Phys Inventory) fields to the amount of stock you want to have on hand
• Process>Register
• Go to Item Journals>Action>Function>Calculate Warehouse Adjustment
• This will summarize all warehouse journals, and apply costing
• Click Action>Posting>Post & Print
• This will adjust the stock to the desired quantity
• You can confirm by checking the Items>Quantity on Hand and Qty on Hand Alt columns
• Create a New Pick
• Search for Warehouse Shipments>Click No. to view line details
• Click Process>Create Pick
• A pick will be generated for any outstanding quantities on the shipment
• Search for Warehouse Picks> Click No. to view line details
• Take Line>Enter Bin, Qty to Handle, Qty to handle Alt, Lot, Container (if applicable)
• Place Line>Enter Lot
• Click Process>Register Pick
• Post and Print the Warehouse Shipment
• Search for Warehouse Shipments>Click No. to view line details
• Click Posting>Post and Print
• This will consume the stock and generate the invoice

*Related Errors

If the Sales Order, Lot Qty, or Bin qty are in different UofM's, you will run into problems when trying to pick on ADC. Use the Unit Conversion feature on the Bin Status screen to convert units prior to picking.