Microsoft Dynamics GP (Archived)

Edit transaction info

(0) Share

Report

Posted on by Community Member

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

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

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)

Was this reply helpful? Yes No