Discrepancy between Crystal and Great Plains

[Guy991]

Hi
I use Crystal to get an excel output of Aged Accounts Receivable.
For some reason, some payments which have been fully applied on Great Plains (and paid transaction removal done) are still showing up on Crystal.
e.g. client had invoice of $2,000 which they paid. Payment is made and applied on Great Plains and paid trx removal done.
But Crystal still shows an outstanding invoice of $2,000 and an outstanding payment of $2,000 for that client. How can I get rid of this?

 

[VictoriaYudin]

Does your Crystal report have any kind of logic that would look at the apply dates?

Why does the fact that paid trx removal was done matter? Are you taking that into account in the Crystal report logic?

Do the invoice and payment show in GP with a HISTORY status or OPEN?

It is very difficult to answer more specifically without know what tables, logic and filters you're using on your Crystal report.

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

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

blog:

http://victoriayudin.com