web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP - Sales Mo...
Microsoft Dynamics GP (Archived)

Dynamics GP - Sales Module

(0) ShareShare
ReportReport
Posted on by Community Member

I'm using Dynamics GP, and I want to clear the entire aging in the sales module including all the data like invoices, payments, credits, etc. I want to clear it so I can start all over with a blank aging. The sales module does not interface with the General Ledger in the Financial module so clearing all the data in the sales module will not affect the general ledger. Can this be confirmed?

Right now, I am voiding each invoice/payment/etc. one by one using the "Posted Transactions" in the Sales -> Transactions -> Posted Transactions. Please let me know how I can speed up the process or best of all - clear everything all at once. Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at

    Hi Jwoo

    First thing is to make a backup of your database before you do anything or even better, try it out first in a test environment.

    If I understand you correctly, you want to clear your receivables subledger of all transactional data.  If this is the case, you will need to clear the following tables in SQL:

    Work tables

    RM10101

    RM10201

    RM10301

    RM10501

    RM10504

    RM10601

    RM10901

    Open Tables

    RM20101

    RM20102

    RM20201

    RM20400

    RM20401

    History Files

    RM30101

    RM30201

    RM30202

    RM30301

    RM30401

    RM30501

    RM30502

    RM30601

    The above will remove all sales transactional history and leave your Receivables setup and Customer master as is.  Not all tables will contain data depending on the functionality you are using.

    If you are using SOP (Sales Order Processing) let me know as you will have some additional tables to clear that contain the invoice transaction data.

  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at

    I left out one table that you should also clear and that is the RM Keys file  RM00401

    While you are at it you should also clear the inquiry tables

    RM00103

    RM00104

  • Community Member Profile Picture
    Community Member on at

    Thanks a lot Jeffrey, much appreciated!

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans