Skip to main content

Notifications

Business Central forum

How to view the link between a Sales Order and a Purchase Order

Posted on by 454

We create Purchase Orders by entering the Sales Order and then using the function Create Purchase Document.  Once the documents are created, how do I view the link from the Sales Order and Purchase Order?  I see that I can click on the line for the PO and the SO and select Order, but the only links that I can view are for Drop Shipments, Special Orders, and Blanket Orders.  Where is the link for standard Purchase Orders?

Categories:
  • grantb Profile Picture
    grantb 25 on at
    RE: How to view the link between a Sales Order and a Purchase Order

    The Sales Line table carries fields for "Purch. Order No." and "Purch Order Line No.". When I use the Requisition Worksheet > Drop Shipment > Get Sales Orders, and create the PO this way, the Sales Line table is populated with the PO and PO Line. I would imagine using the Create Purchase Document does the same, but haven't tested it.

    Unfortunately, in BC cloud version, be default you are not able to personalize the sales line subform to bring these fields to view. But you can Inspect Page to see them. You could do a small page extension to make them viewable in the page.

    2020_2D00_09_2D00_09_5F00_11_2D00_26_2D00_55.png

  • Suggested answer
    RE: How to view the link between a Sales Order and a Purchase Order

    You need to use reservations. Settign an Item to reserve always will do it automatically. Setting an Item to reserve optional, n=means you can then manually set the reservation. once the reservation is set, there is a sales reservation report, and purchase reservation report you can track to see what is what.

  • Verified answer
    Janelle Riley Profile Picture
    Janelle Riley 454 on at
    RE: How to view the link between a Sales Order and a Purchase Order

    That answers my question!  Thanks for your quick response.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to view the link between a Sales Order and a Purchase Order

    Hey Janelle,

    If you use the function "Create Purchase Document" a purchase order is created for the items that are not (enough) in stock. These purchase orders aren't linked in any way to the orginal sales order, because they serve for a different purpose. This function is mainly used to supplement the inventory, while a drop shipment is for purchase orders that are directly sent to the customer.

    Because of this different purpose a purchase order is only linked to a sales order if it's based on a drop shipment or special order. In all other cases, these documents aren't linked to each other.

    Kind regards,

    Floris

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans