$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

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

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>
Add comment
10|10000 characters needed characters exceeded

  • 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>
    
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 15, 2017 at 02:43 PM

    Anyone who encountered this?

    Add comment
    10|10000 characters needed characters exceeded

    • 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