Validating AR total payments

(0) Share

Report

Posted on by Lou@ACE

445

We went live on Dynamics GP 2013 in July. I am using a SmartList based on Victoria Yudin's SQL view with AR apply detail and I am looking for a way to validate the data that is reported from the SmartList.
It seems like when I run a different payment reports for a period I get different totals. Of course they are different reports. But I am trying to answer these questions.....
What was my payment total for the period?
How much was applied to invoices and how much was not applied?
In theory if I take my total payments - RM Doc Type all = 9 - from RM Open (We have not removed to history yet) and subtract the voided payments, that total should equal my total applied amounts from the RM Apply Open Table plus the total unapplied amounts (Current Transaction Amount) from payment transactions in RM Open.
But it doesn't by a material amount. So what am I missing?
What is the best approach to validate the totals from the AR Apply Detail SmartList based on Victoria's view?

Thanks.

*This post is locked for comments

All responses (1)

Answers (0)

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: Validating AR total payments

What reports you are printing and what differences you are getting?