Buckets:

Jamesbrendamour
/

sage-dev-docs

Files

xet

Jamesbrendamour/sage-dev-docs / api /purchasing /price-lists.md

Jamesbrendamour

13 days ago

preview code

download

raw

7.41 kB

metadata

title: Purchasing Price Lists | Sage Intacct Developer
url: https://developer.intacct.com/api/purchasing/price-lists/

Purchasing Price Lists | Sage Intacct Developer

Get Purchasing Price List Object Definition
Query and List Purchasing Price Lists
Query and List Purchasing Price Lists (Legacy)
Get Purchasing Price List
Get Purchasing Price List by ID
Create Purchasing Price List (Legacy)
Update Purchasing Price List (Legacy)
Delete Purchasing Price List (Legacy)

A Purchasing price list contains the names of price lists in Purchasing.

Get Purchasing Price List Object Definition

`lookup`

List all the fields and relationships for the purchasing price list object:

<lookup>
    <object>POPRICELIST</object>
</lookup>

Parameters

Name	Required	Type	Description
object	Required	string	Use `POPRICELIST`

Query and List Purchasing Price Lists

`query`

List the record number and name for each purchasing price list:

<query>
    <object>POPRICELIST</object>
    <select>
        <field>RECORDNO</field>
        <field>NAME</field>
    </select>
</query>

Parameters

Name	Required	Type	Description
object	Required	string	Use `POPRICELIST`
filter	Optional	object	Filter expression to limit the response to only objects that match the expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, `VENDOR.CREDITLIMIT` on APBILL).
select	Required	sequence	The names of the fields that you want included in the response, and an optional aggregate function such as `count` or `sum`. Returning all fields is not supported.
orderby	Optional	object	Provide an `order` element with a field name and choose an ascending or descending sort order, for example: `<order> <field>RECORDNO</field> <descending/> </order>`
options	Optional	object	Query options: * Set the `caseinsensitive` element to `true` for a case-insensitive query `<caseinsensitive>true</caseinsensitive>` * In a multi-entity company, set the `showprivate` element to `true` to query data in private entities: `<showprivate>true</showprivate>` * Specify the `returnformat` for the response: `xml` (default), `json`, or `csv` `<returnformat>json</returnformat>`
pagesize	Optional	integer	Maximum number of matching objects to return in the response, between `1` and `2000` items (Default: `100`)
offset	Optional	integer	Point at which to start indexing into records (Default: `0`)

Query and List Purchasing Price Lists (Legacy)

`readByQuery`

<readByQuery>
    <object>POPRICELIST</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name	Required	Type	Description
object	Required	string	Use `POPRICELIST`
fields	Optional	string	Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide `*` for the value.
query	Required	string	SQL-like query based on fields on the object. The following operators are supported: `<`, `>`, `>=`, `<=`, `=`, `like`, `not like`, `in`, `not in`, `IS NOT NULL`, `IS NULL`, `AND`, `OR`. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes (`'Jane\'s Deli'`). Joins are not supported.
pagesize	Optional	integer	Custom page size between `1` and `1000` items (Default: `100`)

Get Purchasing Price List

`read`

<read>
    <object>POPRICELIST</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name	Required	Type	Description
object	Required	string	Use `POPRICELIST`
keys	Required	string	Comma-separated list of object `RECORDNO` to get
fields	Optional	string	Comma-separated list of fields on the object to get. To return all fields, omit the element or provide `*` for the value. For best performance and predictability, limit the number of fields.
returnFormat	Optional	string	Data format for the response body: * `xml` (default) * `json` * `csv`

Get Purchasing Price List by ID

`readByName`

<readByName>
    <object>POPRICELIST</object>
    <keys>Full Time</keys>
    <fields>*</fields>
</readByName>

Parameters

Name	Required	Type	Description
object	Required	string	Use `POPRICELIST`
keys	Required	string	Comma-separated list of object `NAME` to get
fields	Optional	string	Comma-separated list of fields on the object to get. To return all fields, omit the element or provide `*` for the value. For best performance and predictability, limit the number of fields.
returnFormat	Optional	string	Data format for the response body: * `xml` (default) * `json` * `csv`

Create Purchasing Price List (Legacy)

`create_popricelist`

<create_popricelist>
    <name>Special Purchasing price list</name>
</create_popricelist>

Parameters

Name	Required	Type	Description
name	Required	string	Price list name to create
datefrom	Optional	object	Date from
dateto	Optional	object	Date to
status	Optional	string	Status. Use `active` for Active otherwise use `inactive` for Inactive. (Default: `active`)

datefrom

Name	Required	Type	Description
year	Required	string	Year `yyyy`
month	Required	string	Month `mm`
day	Required	string	Day `dd`

dateto

Name	Required	Type	Description
year	Required	string	Year `yyyy`
month	Required	string	Month `mm`
day	Required	string	Day `dd`

Update Purchasing Price List (Legacy)

`update_popricelist`

<update_popricelist name="Special Purchasing price list">
    <status>active</status>
</update_popricelist>

Parameters

Name	Required	Type	Description
name	Required	string	Price list name to update
datefrom	Optional	object	Date from
dateto	Optional	object	Date to
status	Optional	string	Status. Use `active` for Active otherwise use `inactive` for Inactive

datefrom

Name	Required	Type	Description
year	Required	string	Year `yyyy`
month	Required	string	Month `mm`
day	Required	string	Day `dd`

dateto

Name	Required	Type	Description
year	Required	string	Year `yyyy`
month	Required	string	Month `mm`
day	Required	string	Day `dd`

Delete Purchasing Price List (Legacy)

`delete_popricelist`

<delete_popricelist name="Special Purchasing price list"></delete_popricelist>

Parameters

Name	Required	Type	Description
name	Required	string	Price list name to delete

Provide feedback

Xet Storage Details

Size:: 7.41 kB
Xet hash:: 9e80b6ad9f418d821988bc33d10997cee805a0c8eaece99d1a942fa6789efa2d

Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.