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?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
