I have a client who is trying to remove a balance from their historical aged trial balance in Sales. The invoice is in history, but has no payment applied. When checking the SQL tables, the RM30101 tables shows a payoff date for the invoice. However, there is no applied record in the RM30201 table. This is causing the invoice to show up on the trial balance as an open invoice.
How can we get rid of this invoice from the trial balance report?
Thanks!
*This post is locked for comments
Hi,
First a fact question, is this a good invoice? What is the current transaction amount (CURTRXAM)? Do you want to just get it off of the HATB? Have you looked in the RM20201 table for the apply record? We can fix this, we just need to know which way you need to go. Has the invoice been paid, but the records are just not reflecting it? Was the invoice written off or voided? Write offs and Voids do not generate Apply to records. If the HATB is before the void or write off, it would still show up on the report.
Leslie
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
