Skip to main content
Skip table of contents

IN Advanced Pricing Customer Code & Stock Item

URL

Verbs

Function

Version
/INAPCustCodeStockCode/<customerCode>/<stockItem>/<unitOfMeasure>?<currency>&<location>&<isActive>POSTUpdate and existing IN Advanced Prices for Customer Code & Stock Item2021.2*

/INAPCustCodeStockCode/<customerCode>/<stockItem>/<unitOfMeasure>

GET

Query a list of IN Advanced Prices by Customer Code & Stock Item for a particular Customer Code and Stock Item and Unit of Measure

2021.2

/INAPCustCodeStockCode

GET

Query a list of IN Advanced Prices by Customer Code & Stock Item

2021.2
/INAPCustCodeStockCodePOSTCreate a new IN Advanced Prices for Customer Code & Stock Item2021.2*

* Does not yet support update/create of Quantity Breaks - as at 2021.2

Advanced Prices support a composite primary key based on a list of properties used in conjunction with each types specific "properties".  When performing a GET to try and lookup a particular Advanced Price, or POST to update an existing Advanced Price you can use a combination of the Lookup modifiers defined below.

Lookup modifiers

Query String

Definition

Sample

Version
currencyLook for an Advanced Price for a particular Currencycurrency=USD2021.2
locationLook for an Advanced Price for a particular IN Locationlocation=Warehouse2021.2
isActiveLook for an Advanced Price that is Active or notisActive=true2021.2

Supported modifiers

Query String

Definition

Sample

Version
groupReturn a list of Advanced Prices for a Pricing Groupgroup=Black Friday2021.2
customerReturn a list of Advanced Prices for a Customercustomer=100002021.2
stockItemReturn a list of Advanced Prices for a Stock ItemstockItem=022021.2

Security Linked Menu

Menu Item

Located

Advanced Pricing MaintenanceData Entry / Inventory

Sample XML Response

<?xml version="1.0" encoding="UTF-8"?>
<INAPCustCodeStockCodes collection='true' count='2'>
    <INAPCustCodeStockCode>
        <Edition>1</Edition>
        <OidString>4564.18</OidString>
        <IsActive>true</IsActive>
        <IsDiscountUsed>false</IsDiscountUsed>
        <IsIgnoreMaxDisc>false</IsIgnoreMaxDisc>
        <IsIgnoreMinGP>false</IsIgnoreMinGP>
        <IsMarkupUsed>false</IsMarkupUsed>
        <IsPriceUsed>true</IsPriceUsed>
        <IsUseDateRange>false</IsUseDateRange>
        <MarginPercentage>-125.23</MarginPercentage>
        <MarginValue>0.0000</MarginValue>
        <MarkupPercentage>-55.60</MarkupPercentage>
        <DiscountPercentage>0.00</DiscountPercentage>
        <NetPrice>123.0000</NetPrice>
        <Currency>AUD</Currency>
        <Group>Customer/Item specific pricing</Group>
        <TaxCode>GST 10%</TaxCode>
        <UnitOfMeasure>EA</UnitOfMeasure>
        <StockItem>ACER17LCD</StockItem>
        <Customer>1002</Customer>
    </INAPCustCodeStockCode>
    <INAPCustCodeStockCode>
        <Edition>2</Edition>
        <OidString>4564.2</OidString>
        <IsActive>true</IsActive>
        <IsDiscountUsed>true</IsDiscountUsed>
        <IsIgnoreMaxDisc>false</IsIgnoreMaxDisc>
        <IsIgnoreMinGP>false</IsIgnoreMinGP>
        <IsMarkupUsed>true</IsMarkupUsed>
        <IsPriceUsed>false</IsPriceUsed>
        <IsUseDateRange>false</IsUseDateRange>
        <MarginPercentage>9.09</MarginPercentage>
        <MarginValue>0.0000</MarginValue>
        <MarkupPercentage>10.00</MarkupPercentage>
        <DiscountPercentage>2.50</DiscountPercentage>
        <NetPrice>60.5100</NetPrice>
        <Currency>AUD</Currency>
        <Group>Customer/Item specific pricing</Group>
        <TaxCode>GST 10%</TaxCode>
        <UnitOfMeasure>EA</UnitOfMeasure>
        <StockItem>01AOPENAX4B533</StockItem>
        <Customer>1001</Customer>
    </INAPCustCodeStockCode>
</INAPCustCodeStockCodes>
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.