web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / how to remove negative...
Service | Customer Service, Contact Center, Fie...
Suggested answer

how to remove negative undefined quantity in item tracking line while posting warehouse receipt

(0) ShareShare
ReportReport
Posted on by MK-07080536-0
Hello,
We have ran into an issue with negative quantities in item tracking lines.  We are on Business Central Cloud.  Here is how we ran into the problem.
We did create a transfer order from one warehouse to another warehouse.  We then went ahead and issued warehouse shipment and post it.  After posting, we have found we made a mistake on unit of measure, and we used "undo shipment" under line tracking in posted warehouse shipment.  After that, we fixed the issue and went ahead and created a new shipment warehouse and post it.  Now that we want to do a warehouse receipt, we see a negative undefined quantity in item tracking line, which does not let us post the warehouse receipt.  We were under impression that by performing "undo shipment" the inventory will be moved from "in transit" to original warehouse location, which looks like is not the case.  Also, based on my research, BC does not let moving "in transit" inventory to any location.  Can someone please help and let us know how we can resolve this issue?  I have looked in some answers and someone suggested to export In-Transit location card out of BC, change the status of "Use as In-Transit" to false, import it back, then use item journal to move this negative number from there, then do the same thing and change the status back to true.  However, I am not sure if this will work as how the system will know which specific entry would be reversed.  Your help will be greatly appreciated.
Categories:
Dynamics 365 Customer Service
I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 Moderator on at
    how to remove negative undefined quantity in item tracking line while posting warehouse receipt

    Hi MK-07080356-0,

    Thanks for the detailed explanation—this is a tricky situation that can occur when handling transfer orders and item tracking in Business Central Cloud.

    Here's what you can consider:

    1. Undo Shipment Behavior

    You're correct that using Undo Shipment should ideally reverse the inventory back to the original location. However, in some cases, especially with tracked items and unit of measure discrepancies, the reversal may not fully clear the In-Transit entries, leading to undefined or negative quantities.

    2. In-Transit Location Handling

    Business Central does not allow direct movement of inventory from In-Transit to a warehouse location without a proper receipt. Changing the “Use as In-Transit” flag temporarily, as you mentioned, is a workaround—but it’s risky and not officially supported.

    3. Recommended Steps

    Here’s a safer approach:

    • Use Item Reclassification Journal to manually adjust the inventory, but only after confirming the exact entries involved.
    • Review the Item Ledger Entries and Warehouse Entries to identify the transaction causing the negative quantity.
    • If the undo didn’t fully reverse the tracking, you may need to manually adjust the Item Tracking Lines in the warehouse receipt to match the expected quantity.

    4. Alternative: Create a New Transfer

    If the tracking is too tangled, consider:

    • Cancelling the current receipt.
    • Creating a new transfer order with correct unit of measure and tracking.
    • Posting shipment and receipt cleanly.

    Let me know if you'd like help reviewing the ledger entries or setting up a reclassification journal.

    If this answer was helpful, please consider marking it as accepted.
    Best regards,
    Daniele

  • Daniyal Khaleel Profile Picture
    Daniyal Khaleel on at
    how to remove negative undefined quantity in item tracking line while posting warehouse receipt
    Cancel the Open Transfer Receipt Line:
    If you're unable to receive due to the error, cancel the open transfer receipt and reopen the transfer order. Here’s how:
    Navigate to the Transfer Order.
    Use the function: "Reopen" (if it’s marked as released).
    Remove the existing item tracking lines manually (if allowed).
    Correct the lines (if possible).
    Cancel the current receipt using Warehouse Receipt > Cancel (if created).
    2. Use Item Reclassification Journal (as a workaround):
    If the inventory is stuck in In-Transit but not physically shipped:
    Use "Item Reclassification Journal" to move the inventory back to the source location (NOT using In-Transit).
    This will allow you to match physical and system inventory.
    Only do this if the stock never physically left and you’ve confirmed the warehouse ledger entries match.
    3. Manually Create a New Transfer Order:
    Once inventory is correctly returned to the source location:
    Create a new transfer order with correct UOM and tracking.
    Post new shipment and receipt as needed.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans