wrong posting date in Financials

(0) Share

Report

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

All responses (27)

Answers (2)

Suggested answer

soma 24,410 on at

Like (0)

Report

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 45 on at

Like (0)

Report

RE: wrong posting date in Financials

Thank you!
Fahad Humayun 1,359 on at

Like (1)

Report

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 45 on at

Like (0)

Report

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 1,359 on at

Like (0)

Report

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 45 on at

Like (1)

Report

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 24,410 on at

Like (1)

Report

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 1,359 on at

Like (1)

Report

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 1,359 on at

Like (0)

Report

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?
Suggested answer

soma 24,410 on at

Like (1)

Report

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!!!