web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Posted a Payables Tran...
Microsoft Dynamics GP (Archived)

Posted a Payables Transaction with the Wrong Date

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I am working with our business office to try to fix a problem.  I am with IT so forgive my ignorance about many things.    We have created a payables transaction with the wrong document date.  We accidentally put in the date of 7/17/2017.  Is there a way we can get in and change that date?  Our business office people are not able to and were wondering if I could change it in the "back end" somehow.

Any help is appreciated.

Jim

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    you could void the transaction and reenter it

  • Community Member Profile Picture
    Community Member on at

    My people tell me they do not want to void this transaction.  They say it is posted through the GL and the check has been issued.

  • Community Member Profile Picture
    Community Member on at

    Is it just the doc date that is wrong?  How about the transaction date/gl posting date?  

  • Community Member Profile Picture
    Community Member on at

    The transaction date and posting date are correct.  The main problem for us is that it shows up different than we want in the Outstanding Payables List, I am told.

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,150 on at

    Hi Jim

    Yes, you probably could change it in the back end, but I would be very reluctant to.  The problem is that the date does drive so many different factors and there are a huge number of date fields.  It can impact tax reports etc.

    I work both the front end and back end of Dynamics GP.  If it was one of my clients, I would get them to either void it or if they didn't want to void it, to just note it on their reports as an exception.

    Messing with the data in SQL, and especially if you don't know all the implications is definitely not recommended.

    Cheers

    Heather

  • Community Member Profile Picture
    Community Member on at

    Thanks for the response Heather.  I think I will take your advice and not plan on trying to update the date behind the scenes.

    Take care.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans