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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Clearing Excess Quantity Received and Shipped but Not Invoiced

(0) ShareShare
ReportReport
Posted on by 225

Hi,

We moved to Business Central this year and I am not clear about a few things.

  1. We use Drop Shipment to Receive and Ship Goods.
  2. User has posted wrong quantity while Receiving / Shipping the items.
  3. Accounts invoiced correct quantity.
  4. Now there are Item Ledger Entries showing Qty received but not invoiced and Qty Shipped but not invoiced.

How can we clear the Quantity?

We attempted to create separate invoice at Zero value, but it allocates cost between 2 invoices. 

Appreciate your help!

Thanks & Regards,

S Merchant.

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    I do see we have an idea out there that is requesting an easier way to fix these types of documents.  Below is the product suggestion from our Ideas site:

    experience.dynamics.com/.../

  • ShaishavM Profile Picture
    225 on at

    Thanks Andy!. This was idea submitted by our Microsoft Support Staff. Appreciate if community can help voting for it.

  • Suggested answer
    Community Member Profile Picture
    on at

    Shaishav,

    Sadly, as you know, there is no undo related to the Drop Shipment functionality when the Post Receive takes place. I have told my customers to do the following to make a correction:

    NOTE: When you create a drop shipment, upon Purchase Receipt it is auto-Ships the Sales Order linked. So in order to undo this, you do in fact have to go back to the sales order in order to undo the process, in a round-about way.

    Go to the your Sales Order and Reopen the document. Insert a second Sales Lines for the Item, duplicating the item with the incorrect Shipment, and indicate it is a drop shipment as well.  The key difference will be to put a negative sign in front of the quantity.

    Go back to the Purchase Order and Reopen the document. Then Get the NEW Drop Shipment Sales Line from the Sales Order as a new second Purchase Line, with the negative quantity. When you receive the item this time, you will be receiving in the negative amount, and thus cancelling out the original shipment.

    Hope this helps.

    Thanks,

    Steve 

  • Suggested answer
    ShaishavM Profile Picture
    225 on at

    This is an interesting work-around. I will have it tested and revert.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,993 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,116 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans