Skip to main content

Notifications

Announcements

No record found.

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... / How to associate Poste...
Small and medium business | Business Central, N...
Suggested answer

How to associate Posted Sales Invoices to Posted Purchase Invoices

(0) ShareShare
ReportReport
Posted on by Imari 154
Hi. How can we link the posted sales invoices to the related Posted Purchase Invoices? If we would like to automate a report from Business Central specific to Posted purchase invoices that are due the following week and we need to have the associated information from the posted sales invoice, how do we go about that? 
 
Do we have a specific field somewhere in the Sales Order or Purchase Order that we can use to link both documents thus, whenever we have Posted Purchase and Sales Invoices, we will know which one is associated with which? Thank you in advance. 
 
Can we use the reminder feature in BC for Purchase Invoices or vendor payments? 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,797 Super User 2025 Season 1 on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    Both the posted and unposted sales and purchase lines have a Drop Shipment Field. This can be used to filter/identify lines that are tied to a drop shipment.
     
    However, as far as I know, there's nothing on sales/purchase header documents to identify a Drop Shipment order. A custom calculated field could be added, the calculation would be that if any of the lines on the document have the drop shipment = true, then its =true on the header as well.
     
    For example, in the purchase lines:
     
     
     
  • TJ_BCFunctionalGuy Profile Picture
    TJ_BCFunctionalGuy 15 on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    @YUN ZHU - Big Fan btw. I had a question regarding the DropShip linkage, I am having a hard time filtering to identify Dropshipped Orders from the Posted Purch./Sales Invoice. So say I have 10-15 dropped shipped orders a month, if I do not tag it with an identifier, there no way I can filter to find it natively other than finding the customer/vendor and tying it based off that.
     
    I remember in NAV, I worked on a client where this was readily available. Appreciate your feedback in this matter. 
  • Imari Profile Picture
    Imari 154 on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    Currently, we create quotes convert them to order then invoice. We haven't used the flow from Sales Order to PO. However, with our current process, we have one is to many relationships. We can have one sales Order with multiple POs. We have tested this process but it seems that the SO doesn't still have a direct correlation or link to the PO. It didn't get the SO number or anything related to the Sales order when it created the PO. Is it how that works? 
  • Imari Profile Picture
    Imari 154 on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    Thank you. The reason why we need to associate a specific sales document with a Purchase document is for us to help identify if a specific sales invoice for example has been paid versus the vendor invoice records for reporting purposes. 
     
    Using the PO from a SO, this means that it will be created directly from a PO and not from a PQ, is this correct? 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 78,989 Super User 2025 Season 1 on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    I'm not sure what you need to associate with it, that might have to be customized.
    I think you could try the Drop shipment and Special Order feature first.
    Drop shipment:
    Special Order:
     
    And, Quickly Create Purchase Document from Sales Order
     
    Hope this helps.
    Thanks.
    ZHU
  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 999 Moderator on at
    How to associate Posted Sales Invoices to Posted Purchase Invoices
    Are you creating one purchase order for each sales order or can the demand from one sales order come from more than one purchase order?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,041 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,856 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans