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>