Notifications
Announcements
No record found.
If a payment file is in table rm20101 or rm30101 should it also be in rm10101, if not why
*This post is locked for comments
RM20101 is the Receivables Open Transaction Table. This stores posted RM transactions that have not been ransferred to history. The related GL distributions for these transactions are stored in RM10101.
RM30101 isthe Receivables Histort Transaction table. This stores RM transactions that have been transferred to history. The related GL distributions are storedin RM30301.
So:
If a transaction is in RM20101, then its distributions should only be in RM10101.
If a transaction is in RM30101, then its distributions should only be in RM30301.
Transactions get transferred from RM20101 to RM30101 when you run a Paid Transaction Removal process in RM. At the same time their GL distributions get moved from RM10101 to RM30301.
Hope this explains.
Ian.
Are the distributions supposed to be in SOP10102 AND RM10101 or RM30301?
If the status of the transaction is 'Open' - should the status in the RM10101 also reflect this?
I am finding 'Open' transactions in the RM10101 with the dcstatus of '1' or Work - and I am getting a duplicate error message with this on the GL reconcile.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
