Skip to main content
Microsoft Dynamics GP forum
Answered

Dynamics GP - Sales Module

editSubscribe (0) ShareShare
ReportReport
Posted on by UG Leader

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!

  • Community Member Profile Picture
    Community Member UG Leader 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

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans