Solved

Dynamics GP - SQL view, Receivables Open and posted

Posted on 2011-03-09
1
441 Views
Last Modified: 2012-08-14
I am looking for a SQL view that will show me details on invoices that have been paid and invoices that are still open.  I would need the date the invoice was paid off if it has been completely paid.
0
Comment
Question by:jnikodym
1 Comment
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 35093207
You can use this to get the information you need: http://victoriayudin.com/2009/04/24/sql-view-with-all-posted-receivables-transactions/.  It will return all receivables transactions, but you can easily restrict it to just invoices.  DateInvPaidOff will be the date that GP considers the invoice completely paid.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now