$(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
0

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

May 06, 2017 at 04:18 PM

82

avatar image

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

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>

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bryan Gomez May 15, 2017 at 02:43 PM
0

Anyone who encountered this?

Show 1 Share
10 |10000 characters needed characters left 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

0