Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Edit transaction info

(0) ShareShare
ReportReport
Posted on by

is it possible to edit transaction information on vouchers that have already been paid?

*This post is locked for comments

  • Suggested answer
    Victoria Yudin Profile Picture
    22,768 on at
    RE: Edit transaction info

    One thing to note - the description is usually propagated to the General Ledger and used from there on reports. If your company is not doing that, you don't have to worry about it. However, if you are using that, you will also need to update the REFRENCE field in GL20000 (or GL30000 for historical year transactions)

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Edit transaction info

    You would have to make that change directly in the SQL table.  If you're talking paid transactions, then the update the PM30200.TRXDSCRN field.  If it's an open (unpaid) transaction, update the PM20000.TRXDSCRN.

    Always make a backup of the database before making any changes directly in tables.  Test it first in a test environment or test company first to make sure you get the desired results.

    You could also void the original transactions and re-enter them with the correct descriptions, which of course, is the safest method.

  • Community Member Profile Picture
    on at
    RE: Edit transaction info

    i want to change the description on a few monthly bills. i just need to change the month in the description. it has been written on our copy of the check, but if you're just looking in to the system, the wrong months are still indicated in the description field.  

  • Suggested answer
    Tim Foster Profile Picture
    8,515 on at
    RE: Edit transaction info

    Like many things in Dynamics GP the answer begins with "It depends..."  From the user interface, after transactions are posted, changes are very limited.  With SQL you have much more freedom, but it requires knowledge of the database and Dynamics GP. You can change some things without care or worry (I *always* worry, though).  If you try to change other things you may cause an inconsistency or corrupt the data.  Could you be specific about what you want to "fix?"

    Tim

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Edit transaction info

    GP 2010 and prior, you can edit

    1. PO Number

    2. Description

    3. Discount Date

    4. Due Date

    Starting with GP 2013, you can also change the Remit-To.

    Purchasing>>Transactions>>Edit Transaction Information.

    Hope this helps,

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans