Sales order - There is nothing to post.

(0) Share

Report

Posted on by Esteban Navarro

233

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:

Sales

All responses (4)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Sales order - There is nothing to post.

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
Suggested answer

YUN ZHU 70,099 Super User 2024 Season 2 on at

Like (0)

Report

RE: Sales order - There is nothing to post.

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
Suggested answer

Inge M. Bruvik 32,744 Moderator on at

Like (0)

Report

RE: Sales order - There is nothing to post.

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

https://yzhums.com/16513/
Suggested answer

MahGah 15,419 on at

Like (0)

Report

RE: Sales order - There is nothing to post.

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.