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

This question is answered

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

Verified Answer
  • 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/

All Replies
  • 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/

  • 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.