Best Way to Get Rid of Invalid SAP PartnerAugust 23, 2020 by Leslie Edison
You may notice an error stating that the account number of the SAP business partner type is not valid. There are several ways to solve this problem, and we will talk about this a little later. A business partner profile is the definition of parameters for electronic data interchange with a business partner via the IDoc interface. To communicate with a partner through the IDoc interface, you must create a partner profile. In the SAP user interface, select Tools, Sales Information, IDoc Database, and Partner Profile.
You are working with an SAP Business One database that has been updated from a version earlier than 2007.
You open the "Business Partner Master Data" window and try to update all details of a specific third party. You receive the following error message: Invalid XXX account.
BP could not be updated.
The reason for this issue is that the wrong account was assigned to the third party. This means: a customer who has been assigned accounts payable or a vendor who has accounts receivable.
In previous versions, any account code could be defined for various receivables / payables fields via DI / DTW. Since 2007, there is a validation for these fields. For this reason, it is not possible to update a third party. In addition, it is no longer possible to define an account code for the various receivables / payables fields.
DI / DTW may not be the only source for updating these fields.
- Select clients and / or prospects
crd3 c3 internal connection ocrd o1 to c3.cardcode = o1.cardcode
internalold link oact o2 to c3.acctcode = o2. acctcode
where (c3.accttype in ('A', 'P', 'Y') or (C3.accttype in ('D', 'O') and o2.groupmask = 2))
and (o1.cardtype = 'C' or o1.cardtype = 'L')
suppliers, select c3. *
crd3 c3 inner link ocrd o1 to c3.cardcode = o1.cardcode
inner link oact o2 to c3.acctcode = o2.acctcode
where (c3.accttype = 'R' or (C3. accttype in ('D', 'O') and o2.groupmask = 1))
and o1.cardtype = 'S'