Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

wrong posting date in Financials

Posted on by 1,340

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?

 

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: wrong posting date in Financials

    This is bank reconciliation table CM20200. You can not find the invoices from this table.

    Invoices are available in tables PM20000 (Open) and PM30200 (History). Please update the date in these tables and check your statement.

    Hope this helps!!!

  • Dae Profile Picture
    Dae 45 on at
    RE: wrong posting date in Financials

    Thank you!

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,340 on at
    RE: wrong posting date in Financials

    Hi Danae,

    I have asked Soma if he can give his expert thoughts on this. Please wait while he gives answer.

  • Dae Profile Picture
    Dae 45 on at
    RE: wrong posting date in Financials

    Good morning,  

    We are having the same issue with a few invoices.  They were posted using a wrong document date.  I am able to find all of them under the PM20000, and we will update the DocDate using the above SQL statement (only changing that the doctype = 1 because these are invoices). However; I did not find these invoices under the CM20200.  Please can you let me know if I need to review any other table to update the wrong doc date.  Thank you in advance!

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,340 on at
    RE: wrong posting date in Financials

    Greetings,

    I see that you seem to have a same problem. Did you read all that we discussed? Please try to run the query which is mentioned in my last reply and you will get the results.

    Let me know if it works or not.

  • Dae Profile Picture
    Dae 45 on at
    RE: wrong posting date in Financials

    Good afternoon Fahad,

    We are having the same issue with a few invoices.  They were posted using the correct date, but the document date used was 2028-01-18.  Can I use the same SQL statements to solve this issue?  These are invoices, so I need to use the doc type = 1.  

    Notes: I read all the comments above, and I tried to void the transactions, and we are getting the same errors messages.

    Please advise, 

    Thank you!

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: wrong posting date in Financials

    Yes. I missed this. Now run the below query to update the date.

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

    Note: Before running the update query double check the select query return a single row.

    Hope this helps!!!

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,340 on at
    RE: wrong posting date in Financials

    Hi Soma,

    I guess I was making a mistake while running the query of table CM20200. The Document number field I checked is CMTrxNum in CM20200 now when I run your query like this:

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

    I get the result.

    Am I correct to change the date values like this?

    Once again many thanks for your help

  • Fahad Humayun Profile Picture
    Fahad Humayun 1,340 on at
    RE: wrong posting date in Financials

    Thanks for the reply Soma. I again checked the CM20200 but I am not able to find any record. However, please check the two snapshots 1 of Bank Transactions Window and 2nd is Cashbook register window.

    If we give the date of 2913 year and pull the records. We can see that both the transactions which dates were changed are showing up.

    Could you help finding on which table I should go and correct the dates?

    date_5F00_error_5F00_checkbook_5F00_register_5F00_window.png

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: wrong posting date in Financials

    As earlier said, you also need to update the date to bank transaction as well.

    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 CM20200 SET TRXDATE  = '2013-09-18 00:00:00.000' WHERE SRCDOCNUM = '50626230' AND SRCDOCTYP = 6

    But, you said no records found for the above select statement.

    You need to double check the payment transaction in CM20200 and CM20100 tables. Then update the date value.

    Hope this helps!!!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans