You’re offline. This is a read only version of the page.
610
I was just curious if anyone knew how the receivables apply tables worked. There is the table RM20201 which is the Apply Open table and then the RM30201 which is the Apply History table. I thought that if someone moved Sales Documents to history, it would clear out of the Open table and be put in the History Table. But I am finding that the same record exists in both. This applies to my Historical Aged Trial Balance Stored Procedure that some of you might have. I developed it and tested with companies that had never moved Sales Items to History.
My example is that there is an invoice for 350.00 from 2008. It was paid exactly with a check for 350.00 in 2008. The Apply Record for this Check (Payment, doc type 9) exists in both the RM20201 and the RM30201. Everything is exactly the same except the DEX_ROW_ID.
Is this normal? Because conceptually, I was unioning transaction and apply open and history tables and matching the two of them up, but not I am double applying payments and obviously that doesn't work.
*This post is locked for comments
Hi Kevin,
This might help, at least as a starting point: http://victoriayudin.com/2010/02/15/sql-view-with-ar-apply-detail/.
Hi Kevin--
I think, in the past, I have done a subquery to group the apply records. I am not the most savvy, though, so you might come up with a more efficient approach :)
Take care,
Christina
No, the payment was actually open and the voucher was in history. I ran paid transaction removal for that one customer and now is says that the Payment is in History, the Tansaction is in History and the Apply record only appears in only the history Apply table.
Now I just need to wrap my head around how to handle these cases, because I want to have my Stored Proc determine when and how much was applied to an invoice at a point in time, regardless of whether paid transaction removel was run or not. At this point, I guess I need to get a distinct set when I union the Open and History Apply tables.
Thanks for your help.
Yes, Kevin, I believe it is normal most of the time. It happens when only one of the transactions moved to history. Consider the following example...
Invoice of $300
Payment of $500
This would result in an open credit of $200. The payment is still open with open apply records, while the invoice (with its apply records) would be moved to history.
Now, in your example, can you confirm that both the payment and invoice are in history?
Take care,
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (