Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 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!

*This post is locked for comments

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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans