Outgoing Payments - No matching records found (ODBC-2028 ) Error

[Former Member]

Hi

I am trying to upload outgoing payments (checks) through DTW. I used the templates OVPM, VPM1 and VPM4 for uploading header, check details and account details. but always I am getting the error message "No Matching Record found (ODBC - 2028) Application-defined or object-defined error65171".

I have successfully uploaded the outgoing payments for cash, error is coming when i try to include the checks file. I have filled in all the mandatory details that are required. But still the same problem

I am using the SAP version 8.8 PL 10, SQL 20008

Regards

Vinoth

[Former Member]

Hi

Please post a record here...so that we can get clear picture on that

[Former Member]

The following are the details about the record

Outgoing Payments header

DocNum DocType HandWritten DocDate CardCode CheckAccount

DocNum DocType Handwrtten DocDate CardCode CheckAcct

2110001 A tYES 20110405 Salaries Payabl 106115

2110002 A tYES 20110405 Salaries Payabl 106115

2110003 A tYES 20110405 Salaries Payabl 106115

Check Rows

ParentKey DueDate CheckNumber BankCode CheckSum CountryCode CheckAccount ManualCheck

DocNum LineID DueDate CheckNum Trnsfrable Currency CountryCod CheckAct

2110001 20110405 225 PNB 15000.00 IN 106115 tYES

2110002 20110405 226 PNB 681458.00 IN 106115 tYES

Account Details

ParentKey AccountCode SumPaid Decription

DocNum AcctCode SumApplied Descrip

2110001 207155 15000.00 SARAVANAN B - MAR SAL

2110002 207155 681458.00 RTGS TO CORP BANK

2110003 207155 23302.00 MAR SAL TO RAFHAVAIAH S

Vinoth

[Former Member]

HI

You have given 'Document Type" as "Account" then there is no need of giving the card code for that template...

I think the error was arised because it is searching the Invoice details relating to the 'Salary Payable'....

[Former Member]

Hi Kambadasn

Tried removing the salary payable from card code and still the same error, I would like to provide some other information also

1. I am currently using PL10 DTW

2. Before this I tried uploading incoming payments and I faced the same problem. So I have taken the incoming payment templates from the earlier version of DTW, ie PL5 and It worked

3. The only difference between these two PL's is, record key is replaced with docnum in the templates

4. So I believed that the PL 10 templates are wrong, So I have taken templates from PL 5 for outgoing payments and tried uploading. But I got the same error

5. Accidentally while doing the above mentioned process, instead of selecting outgoing payments I selected incoming payments (with outgoing payment CSV files, PL5 templates) , surprisingly I did'nt get any error message. But the error is coming only in outgoing payments. If I have done some mistake in the templates, it would have not uploaded in the incoming payments.

I hope the above information will help you

Regards

Vinoth

[Former Member]

HI

Please check the account code whther it has given correct as per the system....

[Former Member]

Hi

Yes I cross verified account code also, yes 207155 is salaries payable only.

Vinoth

[Former Member]

HI vinoth,

Where is the check payment for third record....please check it...

[Former Member]

Hi

It's there in the CSV file, I haven't copied in the message. I checked the number of records too