IN Advanced Pricing Customer Code & Stock Item
URL | Verbs | Function | Version |
---|---|---|---|
/INAPCustCodeStockCode/<customerCode>/<stockItem>/<unitOfMeasure>?<currency>&<location>&<isActive> | POST | Update and existing IN Advanced Prices for Customer Code & Stock Item | 2021.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 |
/INAPCustCodeStockCode | POST | Create a new IN Advanced Prices for Customer Code & Stock Item | 2021.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 |
---|---|---|---|
currency | Look for an Advanced Price for a particular Currency | currency=USD | 2021.2 |
location | Look for an Advanced Price for a particular IN Location | location=Warehouse | 2021.2 |
isActive | Look for an Advanced Price that is Active or not | isActive=true | 2021.2 |
Supported modifiers
Query String | Definition | Sample | Version |
---|---|---|---|
group | Return a list of Advanced Prices for a Pricing Group | group=Black Friday | 2021.2 |
customer | Return a list of Advanced Prices for a Customer | customer=10000 | 2021.2 |
stockItem | Return a list of Advanced Prices for a Stock Item | stockItem=02 | 2021.2 |
Security Linked Menu
Menu Item | Located |
---|---|
Advanced Pricing Maintenance | Data 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>