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
I have the same question (0)
