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) / wrong posting date in ...
Microsoft Dynamics GP (Archived)

wrong posting date in Financials

(0) ShareShare
ReportReport
Posted on by Fahad Humayun 1,359

Please if anyone can help in this as my financials user has posted a wrong document date in Financials module (please see the attachment).


The document date had to be 09/18/2013 but by mistake user input 2913 as wrong year in the date.

 

The posting date was proper which was 09/18/2013 (18-Sept-2013) and reflected properly in the financials.

 

The Value is also applied with available invoice. The system was not allow to void this transactions.


Could anyone help in this problem as what should be done to rectify this error?

 

*This post is locked for comments

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,359 on at

  • soma Profile Picture
    soma 24,416 on at

    Have you tried to void this document in opening year (2013)? or any other dates?

    Did you got any error messages while you voiding the same?

    How did you corrected the document?

  • L Vail Profile Picture
    L Vail 65,271 on at

    Fahad,

    What happens when you try to void the historical transaction?

    It doesn't help for the past, but you can prevent this from happening again by using an option in the Professional Services Tools Library.

    Kind regards,

    Leslie

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,359 on at

    Hi Soma,

    My apologies for the delay response. I couldn't solve this document. This document is still in pending position and Finance need to void this document so they can reconcile.

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,359 on at



    Hi Ms Vail,

    My apologies for the delay response. I have attached the error that comes when I try to void the transaction.

    Could you also guide/help me into preventing this in the future?

    Is there any way or what should be done in this matter?

  • Suggested answer
    soma Profile Picture
    soma 24,416 on at

    Please change the void date to 9/18/2013 or any other valid opening year date then void the document.

    Hope this helps!!!

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,359 on at

    Hi Soma,

    When I try to change the void date to 9/18/2013 or 9/19/2013 I receive error "The Void Date cannot be before the Document Date". The Document date was by mistake entered 9/18/2913.

    Please advise.

  • Verified answer
    soma Profile Picture
    soma 24,416 on at

    I think, you need to correct the document date from SQL(backend) then void the document.

    If you have SQL knowledge, run the below query against company database and correct the document date for the historical payment.

    SELECT * FROM PM30200 WHERE DOCNUMBR = '50626230' AND DOCTYPE = 6

    SELECT * FROM CM20200 WHERE SRCDOCNUM = '50626230' AND SRCDOCTYP = 6

    Make sure if the above query return the one line of records with incorrect payment date and run the below query to update the document date.

    UPDATE PM30200 SET DOCDATE = '2013-09-18 00:00:00.000' WHERE DOCNUMBR = '50626230' AND DOCTYPE = 6

    UPDATE CM20200 SET TRXDATE  = '2013-09-18 00:00:00.000' WHERE SRCDOCNUM = '50626230' AND SRCDOCTYP = 6

    Hope this helps!!!

  • Suggested answer
    soma Profile Picture
    soma 24,416 on at

    To avoid this on future, follow below link.

    community.dynamics.com/.../prevent-users-from-keying-incorrect-document-dates-in-microsoft-dynamics-gp-2010.aspx

    Hope this helps!!!

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,359 on at

    Hi Soma,

    Many thanks for the solution. I ran the queries and found the record in PM30200 where as CM20200 had no such record. I updated the date in PM30200 and void the document it worked fine. I hope it updates all the tables of GP which contain information for this record. Thanks for the help.

    I have to verify one more query with you. The same problem exist in VOID OPEN TRANSACTION where one record has a VOID DATE "09/16/2913". Should I choose PM20000 this time and update the date in SQL to have this transaction void also?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans