Oracle NetSuite integration reference
Be aware of the following information when building your application using Codat's Oracle NetSuite integration.
Bills
When pushing bills to Oracle NetSuite:
-
The
status
property must be set toOpen
. -
A bill can't be created from a purchase order.
-
To apply a discount to a bill, specify an existing discount item record (
itemType = "Discount"
) from NetSuite in the request body. Codat pushes discounts to NetSuite as separate line items; only the item type and the discount amount are sent. Do not uselineItems.discountAmount
andlineItems.discountPercentage
to apply discounts. -
NetSuite makes a distinction between
Expense
andItem
line records in vendor bills. Codat validates whether a line item is anExpense
orItem
type based on the value oflineItems.itemRef.id
. If this isn't populated, Codat treats the line item as anExpense
type. -
In NetSuite, when pulling Bills line items, the
taxAmount
andtaxRateRef
fields are not available because NetSuite does not provide information about which line item the tax relates to.
Bill Payments
When pulling bill payments from Oracle NetSuite:
-
Codat treats a NetSuite Vendor Prepayment as either a bill payment or a direct cost. This depends on the state of the vendor prepayment—for example, if the vendor prepayment has been allocated, then it is treated as a bill payment.
-
If a transaction is voided in NetSuite, a reversing journal is posted to offset the original transaction, and is linked to the original transaction. Codat treats these reversing journals as refunds.
-
In NetSuite, portions of a bill credit note can be allocated to a particular bill. In this case, the bill payment amount shown in Codat is the sum total of the allocated bill credit note portions. The individual allocations are not shown.
Example of bill credit note payments in NetSuite
Say you have a $10 bill credit note (x) and an outstanding $20 bill (y) in NetSuite.
- You apply $5 of x to y, which leaves $15 of y outstanding.
- Pull the bill payment; the
lines.links.amount
of x is equal to $5.- You apply a further $3 of x to y, which leaves $12 of y outstanding.
- Pull the bill payment; the
lines.links.amount
of x is equal to $8.The individual bill credit note allocations are not shown in the bill payment.
When pushing bill payments to Oracle NetSuite:
- The supported use cases are paying off a bill with cash and applying a bill credit note to a bill.
- Applying NetSuite Vendor Prepayments to open bills from vendors is not supported.
Direct costs
Direct costs are pushed to the Check and Credit Card Refund objects in NetSuite.
When pushing direct costs to Oracle Netsuite:
- Vendor Prepayments are not supported.
- The type of direct cost can't be specified; our data model does not make this distinction.
Invoices
When pulling Invoices line items, the taxAmount
and taxRateRef
fields are not available because NetSuite does not provide information about which line item the tax relates to.
Purchase orders
When pushing purchase orders to Oracle NetSuite:
-
The
shipto
field can't be pushed. -
The
accountRef
oritemRef
fields can only be pushed for a single line item. Pushing theitemRef
will override theaccountRef
. If theaccountRef
is pushed, you can view the reference in the Expense sub-list in the NetSuite user interface.
Suppliers
When pushing suppliers to Oracle NetSuite:
- A supplier can only be pushed to the company from which the data was pulled. Pushing data to subsidiary companies is not supported.
Field coverage for supported data types
Codat's data model supports a wide range of fields within each data type.
Sometimes a provider's API does not grant access to a field that exists in a Codat data type. Conversely, our data model sometimes does not support all the relevant fields on an object in a provider's API.
The following tables highlight selected fields that are not available in data pulled and pushed from Oracle NetSuite.
Unavailable provider fields
Codat data type and field | Status |
---|---|
| Not available in the provider's API. |
| Not available in the provider's API. |
| Not available in the provider's API. |
| Not available in the provider's API. |
Unavailable Codat fields
Oracle NetSuite record and field | Codat data type | Status |
---|---|---|
| Not represented in Codat's accounting data model. | |
| Not represented in Codat's accounting data model. | |
| The Suppliers data type does not show whether or not a supplier company is a subsidiary. | |
| Not represented in Codat's accounting data model. |
Updated 6 days ago