AR Table/Field Crystal Report question 2

[VE]

Hi,

I am trying to find a field that will tell me if an AR invoice has been paid in order to build a custom report.

I have been looking in RM20101, but I suspect that it's only giving me paid invoices, rather than both.

I saw another post that mentioned SOP30200 and SOP30300, but those tables are empty in this database, we must not be using them (is that possible?).

So what I'm hoping for is a table or tables that will give me all AR invoices and distiguish the paid from the not paid.

I hope that this is making sense.

Thank you for your help

VE

 

[jymm]

the sop tables are from using sales invoicing

you might consied a few things
1) check out

http://msdynamicsgp.blogspot.com/

if you root around a bit you will get to

http://www.box.net/shared/hht58tdas1

which contains all of the GP tables
2) check out

http://victoriayudin.com/2009/04/24/sql-view-with-all-posted-receivables-transactions/

- seems that Victoria had a really good view on here - this might help you get what you want faster

 

[VictoriaYudin]

VE,

In general for this type of report, I would use the RM20101 table, which will hold any posted Receivables transaction that is not paid. It may also have paid transactions, so you'll want to filter them out. For that I would use the CURTRXAM (Current Transaction Amount) in the RM20101 table. This field will be 0 for any fully paid invoice and > 0 for anything still open.

Jymm, thanks for the shout out!

Victoria Yudin
Dynamics GP MVP 2005 - 2009
Flexible Solutions - home of GP Reports

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com

 

[VE]

Yay!! that's it (CURTRXAM). Thank you both!!!