Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Dynamics GP - Sales Mo...
Microsoft Dynamics GP forum
Answered

Dynamics GP - Sales Module

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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!

Categories:
Addresses
Other
Sales Literature
Sales Territories
Quotes / Orders / Invoices
Voice of the Customer
Activity Feeds
Application
Sales Goal Management
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP - Sales Module

    Thanks a lot Jeffrey, much appreciated!

  • twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Dynamics GP - Sales Module

    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

  • Verified answer
    twelvestrikes Profile Picture
    twelvestrikes 3,657 on at
    RE: Dynamics GP - Sales Module

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans