Dynamics GP Receivables SQL Views
- All Posted Transactions Shows all posted AR transactions with friendly column names.
- All Posted Transactions Same as above, but without the friendly column names…in a PDF file.
- AR Apply Detail Lists all AR Payments, Credit Memos and Returns and their apply detail.
- Commissions Details SOP and RM commissions (for posted and unposted transactions).
- Current Receivables Aging Detail Shows one row per unpaid transaction with hard-coded aging buckets aged by due date.
- Current Receivables Aging Summary Shows one row per customer with a balance with hard-coded aging buckets aged by due date.
- Customer Shipping Addresses All details of the address selected as the Ship To address for each customer
- Customer Yearly Totals Shows calendar year totals for all receivables transactions – results are one row per customer with the years in columns.
- GL Distributions for AR Transactions Shows GL distribution details for all posted Receivables transactions.
- Unapplied Transactions Unapplied AR transactions with a calculation of how old they are.
Dynamics GP Receivables SQL Stored Procedures
- Unapplied AR Transactions by Customer Name Unapplied/open AR transactions with a calculation of how old they are; parameter is ‘Customer name contains’.