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 to Open.

• 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 use lineItems.discountAmount and lineItems.discountPercentage to apply discounts.

• NetSuite makes a distinction between Expense and Item line records in vendor bills. Codat validates whether a line item is an Expense or Item type based on the value of lineItems.itemRef.id. If this isn't populated, Codat treats the line item as an Expense type.

• In NetSuite, when pulling Bills line items, the taxAmount and taxRateRef 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.

1. You apply $5 of x to y, which leaves $15 of y outstanding.
2. Pull the bill payment; the lines.links.amount of x is equal to $5.
3. You apply a further $3 of x to y, which leaves $12 of y outstanding.
4. 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 or itemRef fields can only be pushed for a single line item. Pushing the itemRef will override the accountRef. If the accountRef 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

Unavailable Codat fields