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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Line Item Quantity Shi...
Small and medium business | Business Central, N...
Answered

Line Item Quantity Shipped and Invoiced but Open

(2) ShareShare
ReportReport
Posted on by JE-20081519-0 3,898
Hi:
 
How can a line item on a Sales Order still remains as Open, with its Quantity showing in "Qty. to Ship" and "Qty. to Invoice", even though that line item was shipped for the full quantity as shown in its Posted Sales Shipment document?
 
Does this happen when posting was conducted for only the Shipment and, when posting was later conducted for the Invoice, the end user chose to post "Shipment and Invoice" instead of simply choosing "Invoice"?
 
Thanks!
 
John
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 100,132 Super User 2026 Season 1 on at
    Hi, I'm not sure which field you mean by "Open". I did a simple test and it works fine.
  • JE-20081519-0 Profile Picture
    JE-20081519-0 3,898 on at
    "Open," means Qty. To Ship and Qty. To Invoice equals Quantity, even though all quantity of the line item has been shipped.  :)
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 2,704 Super User 2026 Season 1 on at
    Hello,
     
     
    From the Posted Sales Shipment card page, you can check the Order No whether it is the same Sales Order that is still open.
    I doubt that will be the case considering it is the standard behaviour, are there any extension installed?
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 15,136 Super User 2026 Season 1 on at
    Hello John,
    Not normally — a fully shipped line should not still show Qty. to Ship and Qty. to Invoice as open just because someone later chose Ship and Invoice instead of Invoice. In standard Business Central, shipping first and invoicing later is supported, and once the shipment is posted the line quantities should update accordingly; so if the line still remains Open even though the Posted Sales Shipment shows the full quantity, that usually points more to a posting/update problem, quantity mismatch, interrupted posting, or customization/extension behavior than to normal user choice during invoicing.
     
    Regards,
    Oussama Sabbouh
  • JE-20081519-0 Profile Picture
    JE-20081519-0 3,898 on at
     
    It looks like it was a back order situation.  The Outstanding Sales Order Status report is showing this line item as back ordered with its full Quantity, Qty. to Ship, and Qty. to Invoice displaying as "Remaining Back Order" and "Back Order", and there were two Posted Sales Shipment documents processed for this Sales Order.
     
    The Sales Order has a lot of line items.
     
    Also, even though there were no returns, I do see in one of the two Posted Sales Shipments where a few line items' quantities are negative instead of positive.
     
    As I recall, Back Orders can be confusing.
     
    Any thoughts?
  • Suggested answer
    Alex A Profile Picture
    Alex A 3,127 Super User 2026 Season 1 on at
    Look at the Quantity Shipped and Quantity Invoiced columns on the sales line. These tell the status of a Sales Order. Compare these with the Quantity column to see what's left to ship or invoice.
     
    If everything has been Shipped and Invoiced then you can delete the Sales Order because all the information has been transferred to the Posted Sales Invoice and Posted Sales Shipment documents.
  • JE-20081519-0 Profile Picture
    JE-20081519-0 3,898 on at
     
    Good point.  But, why did the Sales Order not "stay" in synchronization with the Posted Sales Shipments and Posted Sales Invoices?
     
    Why would the Sales Order have to be either manually updated or deleted?
     
    Ultimately, why did it (or its lines items) stay in "open" status?
     
    John
  • Verified answer
    Alex A Profile Picture
    Alex A 3,127 Super User 2026 Season 1 on at
    If there is a quantity showing in "Qty. to Ship" and "Qty. to Invoice" columns it doesn't mean that the Sales Order is still open. These are manual input fields. Or if there is another measure by which you determine it is still open then please explain.
     
    BTW, sometimes Sales Orders will not auto-delete when they are fully shipped and invoiced. This usually happens when someone deletes a line from the Sales Order late in the game or something about how the order was handled by the user.
     
    However, there is an Administrative processing report called Delete Invoiced Sales Orders that you can run to remove those when it happens.

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 April 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,957 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 956 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 645 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans