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.

Did their 'Print For' settings in the Print Receivables Statements
window change when they had the 'computer issue'?  They should be
selecting 'Exclude Fully Applied Payments' to exclude those documents
from the statement.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com

get your GPtip42today at www.gp2themax.blogspot.com

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" <fhamelly@eastcoast-dynamics.com> wrote in 
message 
news:9836e728-41b1-448c-96a9-a90be344563c@r27g2000yqb.googlegroups.com...
> Did their 'Print For' settings in the Print Receivables Statements
> window change when they had the 'computer issue'?  They should be
> selecting 'Exclude Fully Applied Payments' to exclude those documents
> from the statement.
>
> Frank Hamelly
> MCP-GP, MCT, MVP
> East Coast Dynamics
> www.eastcoast-dynamics.com
>
> get your GPtip42today at www.gp2themax.blogspot.com
>
>