Count number of invoices generated from a sales order

(1) Share

Report

Posted on by Community Member

My team wants to get the number of invoices that have been generated from a sales order. We want to do this through a function that gets the number when request is made rather than having to manually filter the invoices from the sales order and then count one by one. Is there a function already in D365 F&O to do this? If not, how can we use X++ to create this function?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (2)

Report
You can write an x statement to count CustInvoiceJour records where SalesId is your sales id.

You can add this method to SalesTable:

public int MYgetNrOfInvoices() { CustInvoiceJour custInvoiceJour; select count(RecId) from custInvoiceJour where custInvoiceJour.SalesId == this.SalesId; return int642int(custInvoiceJour.RecId); }

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (2)

Report

I don't think that looking just at CustInvoiceJour.SalesId is correct. If one invoice include multiple orders, only of them will be referenced in CustInvoiceJour.SalesId. A better approach is using CustInvoiceSalesLink table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry, could you please clarify that? Does it mean to replace every "custInvoiceJour" in Nikolaos's answer with "custInvoiceSalesLink"? Or does it mean to do something (which is?) in CustInvoiceSalesLink instead of SalesTable?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (2)

Report
Sorry, I didn't realize that it's not sufficient information for you. Here is the code:

public int myGetNrOfInvoices() { CustInvoiceSalesLink invoiceLink; select count(RecId) from invoiceLink where invoiceLink.OrigSalesId == this.SalesId; return int642int(custInvoiceJour.RecId); }

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

Some country localizations have invoice cancellation structures. It is useful to be careful if you have it too (or you may not want to count invoices with credit note depending on the development demand)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No