Announcements
No record found.
Hi All,
I am looking for an easy and accurate way to calculate the number of invoices and credit notes generated in one month. Pls suggest any suitable methods. Thanks in advance.
Ver : Dynamics Ax 2012 R2
Hi Icarus777,
You can export the invoices to Excel; filter by date and then perform a count.
Thanks very much for the response
We have several companies on one AX database. Is there any easy way to select the invoice details for ALL companies at the same time using SQL queries? Reason code details (customer Name - field captured at POS terminal) also need to be exported to excel. Appreciate your assistance.
Hi icarus,
Is this the same question related to the count question? If this question is different, please create a new one on the forum. Otherwise please explain how this is related to the count question.
Hi Andre,
Yes. This is related to the invoice count query. We need to export the invoices for all the companies on the database and obtain the total number of invoices generated. Doing this for each company individually will be time-consuming. So I was trying to find out if there is any other way. Thanks.
In this case, you can consider using a SQL script on the AX database or a custom form which will present the details cross company.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 681
André Arnaud de Cal... 448 Super User 2026 Season 1
Syed Haris Shah 218 Super User 2026 Season 1
