Error when adding deposits

[lucas_fischer]

Hello,

I have a customer that is receiving an error whenever they try to deposit some checks.

They are receiving this error:

No Matching records found "(JDT1)(ODBC -2028)(Message 131 - 183)

They have also just upgraded from 2005a to 2007a PL 41

I've searched this forum and have checked the SAP notes, in doing so I have found a few other issues that resemble this one but they are not identical

Any suggestions?

thanks, and regards

Lucas

[Former Member · Accepted solution]

Hi Lucas,

The error you are getting is may be the result of corruption in the database. Please contact the SAP support from the channel partner portal.

Also you can run the following query and check if you are getting any results.

Select * from JDT1 where shortname <> account and transtype in (13, 14)

and SourceLine is null

Regards

Vikas

[lucas_fischer · Accepted solution]

VIkas,

First of all thank you for your response.

I am however, having some difficulties with the syntax of your query.

I am receiving an error:

Msg 4145, Level 15, State 1, Line 1

An expression of non-boolean type specified in a context where a condition is expected, near 'account'.

Does there need to be a '=' in between shortname and account?

Would it be possible, that you could explain it in a little more detail so that I can understand what it is looking for and the expected result?

thanks and regards,

Lucas

Edited by: Lucas Fischer on Sep 24, 2008 1:51 PM

[former_member583013 · Accepted solution]

I believe the intended query was

Select * from JDT1 where shortname != account and transtype in (13, 14)

[lucas_fischer · Accepted solution]

Hello,

is the "and sourceline is null" portion needed?

Rgds,

Lucas

[Former Member · Accepted solution]

Yes. You are right. It is a part of the query.

[Former Member · Accepted solution]

i has been run that query and no result found. What the mean from that query? I have same problem with Lucas. This problem i found when upgrade SAP 2005a to SAP 2007a.

what the solution for this problem?

[jitin_chawla]

Hi Lucas,

In addition to above, please check the last Journal Entry entered. Does it have the row data??

Also, in the add mode of the Journal Entry you getting the next number or the same number as in the last Journal Entry posted.

Regards,

Jitin