Old paid off invoice not moving to historical

(0) Share

Report

Posted on by katrice02

115

There is an invoice from 2000 that was paid in full in 2000 by a return that is still showing open in the account. The return has since been marked as historical. We run the paid transaction removal routinely once a month. How can we get this to historical so it stops showing on the customer's monthly statement?

All responses (2)

Answers (0)

katrice02 115 on at

Like (0)

Report

RE: Old paid off invoice not moving to historical

That worked! Thank you!
Gavin 2,480 on at

Like (0)

Report

RE: Old paid off invoice not moving to historical

Hi,

I've had a similar issue in the past and I'm sure it was related to the POSTED value in the RM20201 (apply table) being set to 0. I changed this to 1 and re-ran the paid transaction removal routine and the transaction went to history. In your example you can check this by running the following SELECT statement in SQL. (the POSTED column will show at the beginning of the results set)

SELECT POSTED, * FROM RM20201 WHERE APTODCNM='INV016292'

If it is 0 you could try changing this by running the following:

UPDATE RM20201 SET POSTED=1 WHERE APTODCNM='INV016292'

**Always ensure you have a full backup of your data before running an SQL update.

Once this has been done try running paid transaction removal again.

I hope this helps.

Thanks

Gavin