@tstrop: "On a few customers payments and returns have been applied to invoices and 
paid in full but are not purging off their statements. Acctg personnel state 
that there was a computer issue at the time ??? Anyway, I need to get these 
items purged from these customers to give them accurate information. Please 
advise."
    @robertsmartlist: "If the document remains in the OPEN status on the Customer account even 
after the Paid Transaction Removal (PTR) process has been performed, then 
the Date Invoice Paid Off field has not been set.
The PTR looks at both the Current Transaction Amount and the Date Invoice 
Paid Off to consider whether to move the document into History.
Use the following script
( or use the Smartlist : Sales > Receivables Transactions object,
add three criteria
1. Current Trx Amount equals zero
2. Date Invoice Paid Off equals 00000000
3.  Document Status equals Posted.
)
select DINVPDOF, CURTRXAM, DOCDATE, *
from RM20101
where CURTRXAM = 0 and DINVPDOF = '1900.01.01'
None of the options in the Tools > Utilities > Sales > Reconcile will 
fix this situation.
Here is a script that will change the Date Invoice Paid Off field to the 
most recent date found in the RM Apply OPEN table. This should then let you 
move those payments (and credit notes) into history when the next PTR is 
performed.
update RMOPEN
set DINVPDOF = lastapply
 select lastapply, AppliedAmt, ORTRXAMT, DINVPDOF, CURTRXAM, DOCDATE, 
RMOPEN.*
from RM20101 RMOPEN
join (
select max(DATE1) as lastapply, sum ( APPTOAMT ) AppliedAmt
, CUSTNMBR, APFRDCNM, APFRDCTY
from RM20201
group by CUSTNMBR, APFRDCNM, APFRDCTY
) APPLD
on RMOPEN.CUSTNMBR = APPLD.CUSTNMBR
and RMOPEN.DOCNUMBR = APPLD.APFRDCNM
and RMOPEN.RMDTYPAL = APPLD.APFRDCTY
where CURTRXAM = 0 and DINVPDOF = '1900.01.01'
and ORTRXAMT = AppliedAmt
This script is supplied as -is. Ensure you have a backup and try it in your 
test company first.
Robert
"Frank Hamelly, MCP-GP, MCT, MVP" <email_address> wrote in 
message 
news:<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.greatplains.20140619.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}