[Help] - DI Server (Base price list not found)

[Former Member]

Hi experts, I'm trying to add item with price using DI SERVER. But I received this error:

Base price list not found

Here's my XML:

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
    <env:Header>
        <SessionID>68915E5D-E2F3-45C3-81A8-B0C7011E6C6D</SessionID>
    </env:Header>
    <env:Body>
        <dis:Add xmlns:dis="http://www.sap.com/SBO/DIS">
            <Service>ItemsService</Service>
            <Item>
                <ItemCode>xxDG010020-BLK-XL</ItemCode>
                <ItemName>NEGRO MALENA</ItemName>
                <ForeignName>NEGRO-MALENA-DG010020-BLK</ForeignName>
                <User_Text>SAMPLE</User_Text>
                <ItemsGroupCode>227</ItemsGroupCode>
                <VatLiable>tYES</VatLiable>
                <PurchaseItem>tYES</PurchaseItem>
                <SalesItem>tYES</SalesItem>
                <InventoryItem>tYES</InventoryItem>
                <Mainsupplier>0001</Mainsupplier>
                <Manufacturer>1</Manufacturer>
                <PlanningSystem>bop_MRP</PlanningSystem>
                <ProcurementMethod>bom_Buy</ProcurementMethod>
                <OrderIntervals>1</OrderIntervals>
                <LeadTime>15</LeadTime>
                <ManageStockByWarehouse>tYES</ManageStockByWarehouse>
                <ItemPrices>
                    <ItemPrice>
                        <PriceList>5</PriceList>
                        <Currency>€</Currency>
                        <Price>50.99</Price>
                    </ItemPrice>
                </ItemPrices>
            </Item>
        </dis:Add>
    </env:Body>
</env:Envelope>

[Former Member]

I've already solved the issue, however; when trying to update the pricelist I received this error:

This entry already exists in the following tables (ODBC -2035)

Here's my XML:

<?xml version="1.0" encoding="UTF-16"?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
    <env:Header>
        <SessionID>EBFC0097-9980-4E8B-AD28-93360291C633</SessionID>
    </env:Header>
    <env:Body>
        <dis:UpdateObject xmlns:dis="http://www.sap.com/SBO/DIS" CommandID="Update Item">
            <BOM>
                <BO>
                    <AdmInfo>
                        <Object>oItems</Object>
                    </AdmInfo>
                    <QueryParams>
                        <ItemCode>xxDG010020-BLK-XL</ItemCode>
                    </QueryParams>
                    <Items>
                        <row>
                            <ItemCode>xxDG010020-BLK-XL</ItemCode>
                        </row>
                    </Items>
                    <Items_Prices>
                        <row>
                            <PriceList>1</PriceList>
                            <Price>5</Price>
                            <Currency>$</Currency>
                        </row>
                        <row>
                            <PriceList>7</PriceList>
                            <Price>50.99</Price>
                            <Currency>$</Currency>
                        </row>
                    </Items_Prices>
                </BO>
            </BOM>
        </dis:UpdateObject>
    </env:Body>
</env:Envelope>

[Former Member]

Anyone who encountered this?

[ANKIT_CHAUHAN]

Hi Bryan,

I have encountered this in DTW:

While updating existing data in Business One through DTW, "LineNum" in import file is necessary and important. In item price template, DTW uses the field "LineNum" to index the sequence of the price list. For every item, the "LineNum" starts from '0' which indexes the first Price List in the database. Please kindly check SAP note 903392 for the "LineNum" example.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support