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

Notifications

Announcements

No record found.

News and Announcements icon
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

(1) ShareShare
ReportReport
Posted on by MK-07080536-0 6
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)
  • Daniyal Khaleel Profile Picture
    Daniyal Khaleel 752 Most Valuable Professional on at
    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.
  • DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    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

  • MK-07080536-0 Profile Picture
    MK-07080536-0 6 on at
    @DAnny3211 i think i need help.  i do not think i can do Item Reclassification Journal since the items are "In Transit".  Would you pls help to review the entries and let me know how to do the reclassification to fix this?  i would appreciate it.  i did check and i see a Transfer Shipment No in Item Ledger Entries that does not exist when actually search in Posted Transfer Shipments.  This is very confusing of what has happened.  One thing i am really confused, how can i do reclassification that remove the inbalance from specific Transfer Order / Receipt Line Tracking Lines?
    @Daniyal Khaleel same issues, 
    Remove the existing item tracking lines manually (if allowed). - NOT ALLOWED
    Correct the lines (if possible). - NOT POSSIBLE
    can you gentlemen pls help?  i would highly appreciate this.
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,397 on at

    Hi Mik,

    This issue with negative undefined quantity in item tracking lines during warehouse receipt posting in Business Central Cloud can be tricky, especially after using "Undo Shipment." Here's a possible approach:

    1. Verify Item Ledger Entries: Check the item ledger to confirm the inventory status and location after the undo operation. The "Undo Shipment" should return the items to the original warehouse, but tracking lines may not update correctly.

    2. Use Item Journal Carefully: The workaround you mentioned—temporarily disabling "Use as In-Transit" on the location card and using the Item Journal—can work, but it's risky. The system may not correctly link the reversal to the original entry, leading to inconsistencies.

    3. Recommended Approach:

      • Create a new transfer order to move the items back from In-Transit to the original location.
      • Use correct item tracking and unit of measure.
      • Post the transfer receipt properly to clear the negative quantity.

    4. Consult Microsoft Support or a Partner: If the tracking lines are corrupted or unclear, it's best to consult support to avoid data integrity issues.

    Let me know if you'd like help walking through the transfer order setup!

    Best regards,
    Daniele

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 75 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 52 Super User 2025 Season 2

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 42 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans