cancel
Showing results for 
Search instead for 
Did you mean: 

DI-API Quotations via SAP B1If = (-5002) Invalid value [OQUT.ShipToCode]

rafael_ogeda
Participant
0 Kudos

Hi friends, we hope all you are fine!

We made a process to include Quotations (ObjType=23) on SAP Business One, using SAP B1If and DI-API, but we are having problem with DI-API call: Exception : DI Error: (-5002) Invalid value [OQUT.ShipToCode]-The di call #1 did fail. ShipToCode

Using the exactlly same DI-API payload in Orders (ObjType=17) we have success in processing! No error...

Anybody can help us? Why the same DI-API payload works for Orders but doen't work for Quotations?

Thanks in advance!

=============================

Study Case:

  • SAP B1If: Version Info 1.22.24 => Framework Version = 1.22.15.1 (2018/01/29)
  • SAP B1: 9.3 (9.30.210) PL: 11

B1If - Call DI-API Object:

B1If - DI-API Payload:

<BOM
    xmlns="">
    <BO>
        <AdmInfo>
            <Object>23</Object>
            <Version>2</Version>
        </AdmInfo>
        <Documents>
            <row>
                <CardCode>C006819</CardCode>
                <CardName>Anderson Paixao de morais</CardName>
                <DocDate>20210923</DocDate>
                <DocDueDate>20210917</DocDueDate>
                <NumAtCard>1741-REME</NumAtCard>
                <BPL_IDAssignedToInvoice>7</BPL_IDAssignedToInvoice>
                <Comments>Nr. Pedido DSlite:1741 Etiqueta de frete disponível para download em
https://api.dslite.com.br/v1/dropshipping/1741/etiqueta Dande disponível para download em
https://app.dslite.com.br/dropshipping/1741/pdf/danfe</Comments>;
                <SalesPersonCode>4708</SalesPersonCode>
                <Confirmed>tYES</Confirmed>
                <FederalTaxID/>
                <ShipToCode>FATURAMENTO</ShipToCode>
                <PayToCode>COBRANÇA</PayToCode>
                <PaymentGroupCode>-1</PaymentGroupCode>
                <U_UPP_TipoVendaLogistica>099</U_UPP_TipoVendaLogistica>
                <U_operacao>1</U_operacao>
                <U_indFinal>1</U_indFinal>
                <U_indPres>9</U_indPres>
                <TransportationCode>2</TransportationCode>
                <U_EcommValue>271.44</U_EcommValue>
                <U_Observacoes>MENSAGEM PARA NOTA 1741-REME</U_Observacoes>
            </row>
        </Documents>
        <Document_Lines>
            <row>
                <ItemCode>10400</ItemCode>
                <Quantity>1</Quantity>
                <UnitPrice>271.44</UnitPrice>
                <Usage>4693</Usage>
                <WarehouseCode>S_01</WarehouseCode>
                <CostingCode/>
                <COGSCostingCode/>
                <FreeText/>
            </row>
        </Document_Lines>
        <AddressExtension>
            <row>
                <ShipToStreet>Das Virgens</ShipToStreet>
                <ShipToStreetNo>24</ShipToStreetNo>
                <ShipToBlock>PERIPERI</ShipToBlock>
                <ShipToBuilding/>
                <ShipToCity>Salvador</ShipToCity>
                <ShipToZipCode>40720040</ShipToZipCode>
                <ShipToCounty>5192</ShipToCounty>
                <ShipToState>BA</ShipToState>
                <ShipToCountry>BR</ShipToCountry>
                <ShipToAddressType>Das</ShipToAddressType>
                <ShipToAddress2/>
                <ShipToAddress3/>
                <BillToStreet>Das Virgens</BillToStreet>
                <BillToStreetNo>24</BillToStreetNo>
                <BillToBlock>PERIPERI</BillToBlock>
                <BillToBuilding/>
                <BillToCity>Salvador</BillToCity>
                <BillToZipCode>40720040</BillToZipCode>
                <BillToCounty>5192</BillToCounty>
                <BillToState>BA</BillToState>
                <BillToCountry>BR</BillToCountry>
                <BillToAddress2/>
                <BillToAddress3/>
                <BillToAddressType>Das</BillToAddressType>
            </row>
        </AddressExtension>
        <TaxExtension>
            <row>
                <Incoterms>0</Incoterms>
                <State>BA</State>
                <County>5192</County>
                <TaxId4>xxx.xxx.xxx-xx</TaxId4>
                <MainUsage>4693</MainUsage>
                <Carrier>F000013</Carrier>
            </row>
        </TaxExtension>
    </BO>
</BOM>

Response for Quotations:

<Payload Role="C" id="atom12" system="0010000100" status="success" b1login="Technical User" method="Synchronous Insert" objectid="23" payload="atom10" keyname="DocEntry" keyvalue="" DIresult="failure" DImsg=" Exception : DI Error: (-5002) Invalid value [OQUT.ShipToCode]-The di call #1 did fail. ShipToCode "/>

Response for Orders:

<Payload Role="C" id="atom12" system="0010000100" status="success" b1login="Technical User" method="Synchronous Insert" objectid="17" payload="atom10" keyname="DocEntry" keyvalue="" DIresult="success" DImsg="74975"/>

Accepted Solutions (0)

Answers (0)