web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
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 on at
    Link between sales order lines and invoices lines
    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 on at
    Link between sales order lines and invoices lines
    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 on at
    Link between sales order lines and invoices lines
    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 on at
    Link between sales order lines and invoices lines
    Don't forget that an invoice may cover several sales orders.
  • Layan Jwei Profile Picture
    Layan Jwei on at
    Link between sales order lines and invoices lines
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans