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 :
Business Central forum

Create a Purchase order from a Sales order error

(0) ShareShare
ReportReport
Posted on by

When I try to create a purchase order from a Sales order and I got thsi error:

Purchase Order No. must have a value in Sales Line: Document Type=Order, Document No.=S-ORD101001, Line No.=10000. It cannot be zero or empty.

I dont understand where I miss a part.  Why I get this error?  I dont found any line call sales line?  I try same error in the demo Cronus.

Categories:
  • Tammy Torgerson Profile Picture
    Microsoft Employee on at

    Hi Jean-François,

    Thank you for the question. The button that you are clicking in the Sales Order is intended to allow you to navigate to a Purchase Order which is already linked. Since you do not have the line linked to a Purchase Order, you have the error returned.

    In order to create and link the Purchase Order, you must open the Purchase Order page. The help page which contains instructions can be found here: [View:https://madeira.microsoft.com/en-us/documentation/sales-how-drop-shipment/:750:50].

    Also, the specific instructions are here:

    To create the purchase order for drop shipment

    To prepare a drop shipment for the item to be sold, you create a purchase order as normal, except you must indicate on the purchase order that it must be shipped to your customer, not to yourself.

      1. Create a purchase order. Do not fill any fields on the lines. For more information, see How to: Record Purchases.
      2. In the Sell-to Customer No. field, select the customer that you are selling to.
      3. Choose the Drop Shipments action, and then choose the Get Sales Order action.
      4. In the Sales List window, select the sales order that you prepared in the "To create a sales order for drop shipment" section.
      5. Choose the OK button.

    The line information from the sales order is inserted on the purchase order line(s).

    You can now instruct the vendor to ship the items to your customer, for example, by mailing the purchase order as a PDF.

    I hope that this information helps. Please respond if you have further questions on this topic.

  • JF Robidas Profile Picture
    on at

    Hi Tammy, thank you for this information, it works fine in that way.  You know I read the purchasing section in Dynamics website and this kind of information wasn't be mentioned.  I come from Dynamics 365 Enterprise and I can easily state, by my difficulty to found how to do some task and other question i see in the forum, the learning content need to be improved significantly for Financials.  but I can say you gave a really good support, no comment on that.  With a better learning material you you probably less questions like that.

  • JF Robidas Profile Picture
    on at

    Hi Tammy, I followed this instruction but I got a error:  ''There were no lines to be retrieved from sales order''.  What I do wrong?

  • Verified answer
    Tammy Torgerson Profile Picture
    Microsoft Employee on at

    Hi Jean-François,

    Are the lines on the Sales Order flagged as drop ship? We are able to create a Purchase Order and have it associated with the Sales Order for drop ship lines. However, we cannot create an association between the Purchase Order and Sales Order for non-drop ship lines.

    If these lines are not drop ship lines, then there are a just a couple of options:

    1. You can create a Purchase Invoice directly from the Sales Order. But this just lets you record the receipt and invoice of the goods--and omits the Purchase Order and any business processes associated with it. This may not be ideal for your business situation.

    2. You can manually create the Purchase Order. It will not be linked to the Sales Order.

  • JF Robidas Profile Picture
    on at

    For now we creating manual purchase order.  But it's not really usefull to reenter all items.  We hoppe to get resolve soon in a closer update.

  • Iain Smith Profile Picture
    on at

    I am also interested in this. We don't generally hold stock but may collate items from multiple vendors for a short period before shipping to the customer.

    - How can we "drop-ship" but get vendors to deliver to us (keep the SO to PO linking) or

    - How can we create Purchase orders (possibly to multiple vendors) for the line items in a sales order without using drop-ship or re-entering all of the line items?

    - In other systems we have used stock and the system detects there is insufficient stock to fulfil the sales order so allows you to generate a purchase order for the shortfall.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans