Question Status

Verified
Larry Carrethers asked a question on 21 Mar 2011 9:17 AM

If a payment file is in table rm20101 or rm30101 should it also be in rm10101, if not why

Reply
Verified Answer
Ian Stewart responded on 21 Mar 2011 10:04 AM

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.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Verified Answer
Ian Stewart responded on 21 Mar 2011 10:04 AM

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.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Larry Carrethers responded on 21 Mar 2011 12:21 PM

Are the distributions supposed to be in SOP10102 AND RM10101 or RM30301?

Reply
John McCarthy responded on 11 Jul 2011 12:58 PM

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.

Reply