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 :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Link between sales ord...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Link between sales order lines and invoices lines

(3) ShareShare
ReportReport
Posted on by Elodie Baudin 137
Hello, 
 
I would like in F&O to make the link between sales order lines and invoices lines, to make statistics about the number of invoices for a sales order. 
 
Is that possible to make it easily, without any customization? 
 
Many thanks in advance for your help
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 240,748 Most Valuable Professional on at
    There is a link, but the number of invoices for an order doesn't need looking at lines. You can utilize CustInvoiceSalesLink table instead.
     
    (Moved from D365 general forum.)
  • Layan Jwei Profile Picture
    Layan Jwei 8,292 Super User 2026 Season 2 on at
    Hi,

    If you go to custInvoiceTrans, you can see the relations for SalesId field

    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 21,437 Most Valuable Professional on at
    If you just would like to see the invoices created by the sale sorder, you can directly look from the invoice journals and select the ones that have Sales Order Id.
  • Martin Dráb Profile Picture
    Martin Dráb 240,748 Most Valuable Professional on at
    Don't forget that an invoice may cover several sales orders.
  • Layan Jwei Profile Picture
    Layan Jwei 8,292 Super User 2026 Season 2 on at
    Hi,
     
    Is your question answered? If yes, then please verify the answers that helped 

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

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 July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 426 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 358

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 353 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans