sapb1 - SAP Business One - Add BP (DI Error: (-5002)

Question

I am trying to add new addresses into a BP. If there is an address registered in the BP everything works, but now if it is new addresses return the error -5002 - Error updating BP: [OCRD.State2], 'the linked value' SP 'does not exist'

I test with SAP Business 10 (10.00.140) FP 2011

if (oBP.GetByKey(CardCode))
{
    oBP.Addresses.SetCurrentLine(oBP.Addresses.Count - 1);
    if (!string.IsNullOrEmpty(oBP.Addresses.AddressName))
    {
        oBP.Addresses.Add();
    }
    UF = json.data.endereco_uf;
    if (UF.Length > 2)
    {
        UF = "";
    }
    oBP.Addresses.SetCurrentLine(oBP.Addresses.Count - 1);
    oBP.Addresses.AddressName = "Novo 1";
    oBP.Addresses.AddressType = BoAddressType.bo_ShipTo;
    oBP.Addresses.Street = json.data.endereco_logradouro;
    oBP.Addresses.Block = json.data.endereco_bairro;
    oBP.Addresses.ZipCode = json.data.endereco_cep;
    oBP.Addresses.City = json.data.endereco_municipio;
    oBP.Addresses.State = UF;
    oBP.Addresses.County = county;
    oBP.Addresses.StreetNo = json.data.endereco_numero;
    oBP.Addresses.BuildingFloorRoom = json.data.endereco_complemento;
    oBP.Addresses.Add();


    oBP.Addresses.SetCurrentLine(oBP.Addresses.Count - 1);
    oBP.Addresses.AddressName = "Novo 2";
    oBP.Addresses.AddressType = BoAddressType.bo_BillTo;
    oBP.Addresses.Street = json.data.endereco_logradouro;
    oBP.Addresses.Block = json.data.endereco_bairro;
    oBP.Addresses.ZipCode = json.data.endereco_cep;
    oBP.Addresses.City = json.data.endereco_municipio;
    oBP.Addresses.State = UF;
    oBP.Addresses.County = county;
    oBP.Addresses.StreetNo = json.data.endereco_numero;
    oBP.Addresses.BuildingFloorRoom = json.data.endereco_complemento;
    oBP.Addresses.Add();
 
    int iRetVal = oBP.Update();
    if (iRetVal != 0)
    {
    Program.oApplication.StatusBar.SetText("Error updating BP: " + Program.oCompany.GetLastErrorDescription(), BoMessageTime.bmt_Short, BoStatusBarMessageType.smt_Error);
    return false;
}

question from:https://stackoverflow.com/questions/65852728/sap-business-one-add-bp-di-error-5002

Answer 1

SAP helped me to solve this issue. The answer follows.

I tried to reproduce this issue in the DemoUK (GB Localization) database and was able to reproduce as well.

After the investigation, it was found that you cannot link a state which does not exist for the specific country.

In your case, the system throws the error because the data is validated based on the following query:

SELECT* FROM OCST WHERE  "Code" = 'SP' and "Country" = ''

Similarly, if I will try to set the State as 'Arizona' and Country as 'United Kingdom', it will give me the same error because the correct 'Country' value should be 'USA'.

Therefore, in order to resolve this issue, you need to opt out one of the following:

1. Set the Country property also in the DI Code (State should belong to the Country which you are trying to set):

oBP.Addresses.Country = "GB"

2. Remove the State property from the DI Code:

oBP.Addresses.State = "SP"