web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
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... / Add fields from the Pu...
Small and medium business | Business Central, N...
Answered

Add fields from the Purchase order to Sales order

(0) ShareShare
ReportReport
Posted on by BchM 92

I made a Purchase Order from a Sales Order (Actions -> Create Purchase Document -> Create Purchase orders) and now I want the "Quantity Received" and "Quantity Invoiced" fields belonging to Purchase Line to appear in Sales Line.

I made an extension of the table "Sales Line", in which I try to create such fields using "CalcFormula = Lookup ..."

pastedimage1640655567988v1.png

pastedimage1640655605724v2.png

But it didn't work, since for some reason the fields "Purchase order no." and "Purch. Order Line no." appear empty.

How can I link the Purchase Order with the Sales Order? Is there any other way to do this? I'm new to this and i feel lost

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Use the purchasing code on the sales line. You can then generate a PO as a special order or as a drop shipment. No dev required. Info on the topic: docs.microsoft.com/.../sales-how-to-create-special-orders

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 7,142 Super User 2026 Season 1 on at

    Sorry, no programming advice, but rather a way to accomplish your goal without programming.

    Using the process you used (Actions > Create Purchase Document > Create Purchase Orders) to create the Purchase Orders will not link the two documents. If you set the Sales Line with a Purchasing Code of Drop Ship or Special Order, when the system creates the Purchase Document it will link the two documents.

    pastedimage1640700727561v1.png

    The Special Order and Drop Ship process flow is different than the above, so you’ll want to review the process to ensure it still meets your needs. Both can be found in the Req. Worksheet.

    pastedimage1640700727562v2.png

    When using this process you will have a link between the Sales and Purchase Documents. If using Drop Shipment you will also have a link between the Purchase Receipt and the Sales Shipment, as the package will never enter your facility.

    I would encourage reaching out to your partner to step through the process and make sure it meets your needs.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 653 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 414 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 394 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans