Purchase item

Name	Data Type	Export	Import
acct_date	DATE
allow_vendor_substitution	NOT_SET
approved_cost	NOT_SET
attachmentid	ID
cost	NOT_SET
created	DATE
currency	NOT_SET
customer_id (Export) customerid (Import)	ID
customer_<field_name>	See Customer		—
date	DATE
date_fulfilled	DATE
id	ID
manufacturer_part	NOT_SET
manufacturerid	ID
name	NOT_SET
non_po	NOT_SET
notes	NOT_SET
order_reference_number	NOT_SET
productid	ID
product_<field_name>	See Product		—
projectid	ID
project_<field_name>	See Project		—
purchaseorder_id (Export) purchaseorderid (Import)	ID
purchaseorder_<field_name>	See Purchase order		—
purchaserequestid	ID
purchaserequest_<field_name>	See Purchase request		—
purchaserid	ID
purchaser_<field_name>	See Purchaser		—
quantity	NOT_SET
quantity_fulfilled	NOT_SET
quantity_payable	NOT_SET
request_itemid	ID
request_item_<field_name>	See Request Item		—
tax_location_name	NOT_SET
total	NOT_SET
um	NOT_SET
updated	DATE
userid	ID
user_<field_name>	See User		—
vendor_quote_number	NOT_SET
vendor_sku	NOT_SET
vendorid	ID
vendor_<field_name>	See Vendor		—

Guidelines

There are several limitations impacting the import of purchase item information into OpenAir:

• Imports can create or modify a purchase item record only if it is not associated with a PO record. These purchase items are also referred to as "Quick POs" or "non-po purchase items".

  • The Quick PO functionality must be enabled for your OpenAir account. Otherwise, the Integration Manager log shows "Error code 846: Cannot create non-po purchase items".

    To enable the Quick PO functionality, go to Administration > Application Settings > Purchases > Other Settings. Scroll down and check the Enable the ability to create quick POs. These are purchase items for purchases made without an OpenAir PO box.

  • non_po must be set to 1. Otherwise, the Integration Manager log shows "Error code 848: Only non_po purchase items can be added/modified".

  • purchaseorderid must be empty. Otherwise, the Integration Manager log shows "Error code 847: purchaseorderid must be blank".

• An optional feature lets you update the project association (Customer: Project) for purchase item records associated with a PO on import. This is the only information you can modify. To enable project association update for purchase items associated with a PO, contact OpenAir Customer Support.