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

Notifications

Announcements

No record found.

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 215

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
    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
    215 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
    215 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

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans