Small and medium business | Business Central, N...

Sales order - There is nothing to post.

(0) Share

Report

Posted on by Esteban Navarro

241

Hello everyone,

I have multiple Sales Ordes with this error. Problem is that all the lines on those Sales Orders are complete. If i delete the lines and paste them again lets post the Sales Order. I have more than 90,000 with this error and copy, delete and paste is not an efficient method.

5584.pastedimage1644187320072v1.png

Thanks for the help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

MahGah 15,613 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Can you check those lines and see what it has in "QTY to Ship" and "QTY Shipped". If QTY Shipped is equal to SO QTY then you should be able to invoice the order but you cannot delete the line. the only exception is if you already invoiced that line (Invoiced QTY populated) if QTY to Ship and QTY Shipped are both blank then you need to populate QTY to Ship then try.

Go to Sales & Receivables Setup and check for the following. This is the setup that define what numbers populate in QTY to Ship.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Here is one way you can have you fully invoiced salesorders deleted automatically:

https://yzhums.com/16513/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,417 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, What MahGah mentioned is one possibility. But you said that there is no problem after pasting, it may have nothing to do with that option.

I'm very concerned about one thing, how are these lines added to the system?

This looks to be imported in the program and not validate to other quantity fields.

For example:

SalesLines.Quantity := 10; -> This can cause problems

SalesLines.Validate(Quantity, 10)

You can open the Sales Line table and see if there are any values in the fields below.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Esteban,

Adding to other replies.. Not sure how you copied and pasted the Sales Lines but if I were you I would copy the Sales Lines to an Excel spreadsheet, just to have them. 2nd, I would delete the back Sales Order. I would create a new Sales Order and use the Copy Function and point the Copy to the Posted Sales Invoice and it will copy in the Sales Lines, with Quantities. Here is an example:

Posted Sales Invoice with 2 Lines:

New Sales Order using Copy:

As for Sales Order that are completed Shipped and Invoiced, you can remove them using the Delete Invoiced Sales Orders that have been Completely Shipped for all lines.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No