<div>
Please post a sample output of the tables that the current report uses. &nbsp;We can then build a query. &nbsp; <br />
<br />
1. Export a subset of data including column names to excel, use one sheet for each SQL table that we need to pull data from.<br />
<br />
I can then build you a query.<br />
<br />

</div>


Please post a sample output of the tables that the current report uses.  We can then build a query.  

1. Export a subset of data including column names to excel, use one sheet for each SQL table that we need to pull data from.

I can then build you a query.



<div>
Hi, this is the SQL Query:<br />
<br />
select refnbr,custid,* from ardoc where doctype='in' and duedate &gt;= 01/01/2008 <br />
<br />
You must change the end date, in this sample this query will print all invoices that has a due date greater or equal than 01 january 2008.<br />
<br />

</div>


Hi, this is the SQL Query:

select refnbr,custid,* from ardoc where doctype='in' and duedate >= 01/01/2008

You must change the end date, in this sample this query will print all invoices that has a due date greater or equal than 01 january 2008.



This is a sql script to create a sql function for the PS Aged AR.

fn08611.sql.txt

<div>
<div class="content wysiwyg-content">
I need to develop a sql query that returns invoices that are more than 90 days overdue. I looked at the aged ar report but the query that it uses is a little confusing. &nbsp;I also need to be able to export this data to excel so just exporting the aged AR report doesnt work well. &nbsp;Can someone give me a query to return these invoice that can be used in SQL Server?<br />
<br />
thanks
</div>
</div>


I need to develop a sql query that returns invoices that are more than 90 days overdue. I looked at the aged ar report but the query that it uses is a little confusing.  I also need to be able to export this data to excel so just exporting the aged AR report doesnt work well.  Can someone give me a query to return these invoice that can be used in SQL Server?

thanks

Dynamics SL aged AR query

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.