No matching records found " (CRD1) (ODBC -20080 [Message 131-183]

[Former Member]

Can anyone please explaing the reason of the following error ??? --

No matching records found " (CRD1) (ODBC -20080 [Message 131-183]

This comes at the time of Purchase Order or any purchasing documents addition.... when we select the vendor from the existing vendor list. It appears just after choosing a vendor (the vendor data has contact person, address bill to / ship to etc... and the master data has been imported from a lagecy system by useing the import and DTW functionality of SAP B1 2007 B SP0 PL7)

[vijay_kumar1 · Accepted solution]

Hi Narottam Das ,

Try to create a new Bill to and ship to address manually for the Business Partner and set the new address as default and see if the error happens.

Regards,

Vijay Kumar

SAP Business One Forums Team

[Former Member · Accepted solution]

Just by setting default address ... solves the problem... thanks a lot to all....

[mohamedelshafei]

There is another Reason For it
Case
The main BP is Consolidated with another BP

then Do a Sales order and Delivery

Then Delete the Consolidated Bp

then try to Copy the Delivery For AR invoice you will face the Error

Solution :

Create new BP with same code

[former_member197621]

Try this

Give, set as default for payment method,then give House Bank,Control account for one dtw vendor then try to add

[former_member197621]

Hai Narottam Das

Please check this thinks in BP Master,Default payment method,Control account for BP if its ok,

then Create new BP Through B1 not trhough DTW ,then try to add PO this will help u to found the error

[Former Member]

manually entry of a BP and then using in the purchase documents has not any problem...but the BP already entered by DTW / import is giving this error...