We ran Paid transaction removal, the payment went to history but the invoice remained in open. How can I get this moved to History, I assume this will need to be fixed in sql, but not sure what to fix.
*This post is locked for comments
Correcting things from the user interface is always the best plan, but here's something else.
Query your database using something like this:
SELECT CUSTNMBR, DOCNUMBR, CURTRXAM, DINVPDOF
FROM RM20101
where docnumbr = 'your doc number'
I'm betting the CURTRXAM isn't zero.
Also look in the RM20201 and see if you have any records where the WHERE APTODCNM = 'your doc number'
If you change the CURTRXAM to zero & DINVPDOF to the right date, I bet it will slide right over to history.
To prevent this kind of thing from happening, be sure to run the Reconcile Utility against Outstanding Document Amounts. The system will compare the numbers in the RM20201 and RM20101 tables to make sure the outstanding balances are correct.
Of course, always backup your company and test it first if you plan to go this route.
Kind regards,
Leslie
You may consider one of the following options
In all cases, it would be nice to take a backup and check on a test environment which option suits your case the most.
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,356
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
