This article provides more information about how the sync works with Oracle NetSuite, and outlines our best practices for syncing between Bill.com and Oracle NetSuite.
Table of Contents
Record types and known limitations
| Record Type | Oracle NetSuite to Bill.com | Bill.com to Oracle NetSuite | Known Limitations |
|---|---|---|---|
| Vendors | Yes | Yes | - Vendors with Access enabled in Oracle NetSuite need to be updated in Oracle NetSuite - Vendors shared across subsidiaries need to be updated in Oracle Netsuite |
| Customers | Yes | Yes | - Bill.com supports only one subsidiary per customer - Customers with Access enabled in Oracle NetSuite need to be updated in Oracle NetSuite |
| Chart of Accounts | Yes | Yes | - Summary accounts are not supported |
| Departments | Yes | Yes | - No known limitations |
| Locations | Yes | Yes | - No known limitations |
| Classes | Yes | Yes | - No known limitations |
| Items | Yes | Yes | - Items created in Bill.com and synced to Oracle NetSuite use the subtype: For Resale |
| Jobs/Projects | Yes | No | - Requires Bundle 3.1 or later |
| Custom Fields | No | No | - When creating custom fields in Oracle NetSuite, assign a default value to avoid any conflicts - Custom fields are ignored by the sync. They will not prevent the bills from syncing to Bill.com. Custom fields will be preserved in Oracle NetSuite but will not be visible in Bill.com |
| Multi-Currency | Yes - for AP only | Yes - for AP only | |
| Payment Terms | No | No | - Payment Terms do not sync to/from Oracle NetSuite |
| Attachments | Yes | No | - Attachments sync from Oracle NetSuite to Bill.com - Attachments will not sync from Bill.com to Oracle NetSuite |
| Partners | No | No | - Partners do not sync to/from Oracle NetSuite |
| Bills | Unpaid bills only | Yes | - Partially and fully paid bills do not sync from Oracle NetSuite to Bill.com - $0 bills in Oracle NetSuite will sync to Bill.com as unpaid bills if they do not have payments on them in Oracle NetSuite - $0 bills jn Bill.com will sync to NetSuite as Paid. - Syncing bills from Oracle NetSuite to Bill.com can be disabled in Bill.com Preferences within Oracle NetSuite - Oracle NetSuite does not support the use of Cost Of Goods accounts as a bill expense |
| Invoices | Unpaid Invoices only (if AR sync is enabled) | Invoice creates only (if AR sync is enabled) | If AR sync is enabled: - Partially and fully paid invoices do not sync from Oracle NetSuite to Bill.com - $0 invoices in Oracle NetSuite will not sync to Bill.com - Invoices created in non-USD currencies will not sync to Bill.com - Once an invoice has synced with Oracle NetSuite, it can't be edited in Bill.com |
| Sales Orders | Yes | No | - The sales order field will sync in at the header level of an invoice from Oracle NetSuite. - The sales order # will display in the PO # field on an invoice in Bill.com and will not be editable in Bill.com |
| Vendor Credits | Unapplied vendor credits only | Yes | - Partially and fully applied vendor credits only sync from Bill.com to Oracle NetSuite - Vendor Credit applications (applying, un-applying, and reapplying) only sync from Bill.com to Oracle NetSuite - To configure the sync to apply vendor credits in Oracle NetSuite when a period is closed, enable Non-GL Changes - Syncing vendor credits from Oracle NetSuite to Bill.com can be disabled in Bill.com Preferences within Oracle NetSuite |
| Credit Memos | No | No | Credit memos have to be created and applied manually in both Bill.com and Oracle NetSuite |
| Approval Status on bills | No | Limited | - The option to only sync bills/vendor credits that have been approved is available in Bill.com Preferences within Oracle NetSuite |
| Bill Payments | No | Yes | - Payments synced from Bill.com to Oracle NetSuite will always use the same Department, Class, and/or Location per subsidiary, based on selection in Bill.com sync preferences |
| Invoice payments | No | Yes (if AR sync is enabled) | If AR sync is enabled: - Payments synced from Bill.com to Oracle NetSuite will always use the same Department, Class, and/or Location per subsidiary, based on selection in Bill.com sync preferences |
| Purchase Orders | Once converted to unpaid Bill | N/A | - The purchase order can not be viewed in Bill.com - The Purchase Order number will appear on bills and vendor credits that originated from POs in Oracle NetSuite - Bills created from POs from Oracle NetSuite should not be edited in Bill.com or the corresponding Oracle NetSuite bill will be unlinked from the PO |
| AP Funds Transfers | No | Yes | - Funds Transfers synced from Bill.com to Oracle NetSuite will always use the same Department, Class, and/or Location per subsidiary, based on selection in Bill.com sync preferences |
| AR Funds Transfers | No | Yes | If AR sync is enabled: - Funds Transfers synced from Bill.com to Oracle NetSuite will always use the same Department, Class, and/or Location per subsidiary, based on selection in Bill.com sync preferences |
| Commissions | No | No | - Commissions do not sync to/from Oracle NetSuite |
General best practices
Keeping the sync Bundle Up-to-Date
- The Oracle NetSuite bundle updates automatically. Oracle NetSuite will alert users each time the bundle is updated.
Preferred Forms and Required Fields
- When syncing records from Bill.com to Oracle NetSuite, the sync will use the preferred form for that record type
- Fields that do not sync with Bill.com cannot be set as required fields on the preferred form for a given record type
Locked and Closed Periods
- If Books Closed date setting is enabled, we will match Books Closed functionality in the accounting software
- If Books Closed date setting is not enabled, the sync cannot use periods that are closed. If a period is closed, the sync will use the most recent open period.
- The sync will be able to write to periods that have been locked. If this is an issue, we recommend completely closing periods to prevent the sync from making changes.
Amortization Schedules
- When an amortization schedule is in use, the Bill.com sync will not change line items for bills and vendor credits covering sublists, expenses, and items
- Any changes to line items for bills/vendor credits should be made in Oracle NetSuite
Best practice by record type
Vendors
General
- Bill.com supports vendors shared across subsidiaries (with bundle 3.2.0 or later). If a single vendor spans across multiple subsidiaries, that vendor record will sync over to each Bill.com account linked to a subsidiary the vendor is shared with
- Vendors shared accross subsidies in Oracle NetSuite need to be updated in Oracle NetSuite. Updating the vendor in Bill.com will cause sync errors
- Vendors with Access enabled in Oracle NetSuite need to be updated in Oracle NetSuite. Updating the vendor in Bill.com will cause sync errors
From Oracle NetSuite to Bill.com
- The Oracle NetSuite character limit for Vendor ID is 83 characters. The sync with Bill.com recognizes the full Vendor ID length.
- When Vendor Auto-Numbering is enabled in both Oracle NetSuite and Bill.com, the vendor ID generated in Oracle NetSuite will sync to Bill.com
- Vendor as a Tax Agency will sync to Bill.com when it is first created. Any subsequent changes will not sync
From Bill.com to Oracle NetSuite
- For vendors of type: Company, Company Name is required to sync to Oracle NetSuite
- For vendors of type: Individual, First Name and Last Name are required to sync to Oracle NetSuite
- If the first and last name fields are left blank, then we will split vendor name with " " and use the first part of the name as first Name in Oracle NetSuite and the remaining part as the last Name in Oracle NetSuite
- If we cannot split the name, we will repeat the vendor name for first name and last name
Customers
General
- Child customer will sync even if subsidiary does not have access to the parent
- Customers with Access enabled in Oracle NetSuite need to be updated in Oracle NetSuite. Updating the customer in Bill.com will cause sync errors
From Oracle NetSuite to Bill.com
- The Oracle NetSuite character limit for Character ID is 83 characters. The sync with Bill.com recognizes the full Character ID length
- For OneWorld users:
- The Bill.com sync has no limit on Customer hierarchy
- For non-OneWorld users:
- The Bill.com sync limits Customer hierarchy to 3 levels deep
- When Customer Auto-Numbering is enabled in both Oracle NetSuite and Bill.com, the customer ID generated in Oracle NetSuite will sync to Bill.com
From Bill.com to Oracle NetSuite
- For customers of type: Company, Company Name is required to sync to Oracle NetSuite
- For customers of type: Individual, First Name and Last Name are required to sync to Oracle NetSuite
- If the first and last name fields are left blank, then we will split customer name with " " and use the first part of the name as the first Name in Oracle NetSuite and the remaining part as the last Name in Oracle NetSuite
- If we can’t split the name, we will repeat the customer name for first name and last name
Chart of Accounts
From Oracle NetSuite to Bill.com
- Bill.com does not support Summary accounts
From Bill.com to Oracle NetSuite
- Account Numbers are required for syncing an account from Bill.com to Oracle NetSuite
Departments
- Child department will sync even if subsidiary does not have access to the parent
Locations
- Child location will sync even if subsidiary does not have access to the parent
Classes
- Child classes will sync even if subsidiary does not have access to the parent
Items
- Sales Tax Items and Shipping Items are 1-way to Bill.com (if AR sync is enabled)
- Child items will sync even if subsidiary does not have access to the parent
From Bill.com to Oracle NetSuite
- Items created in Bill.com will sync to Oracle NetSuite with the subtype: For Resale
- If an item needs to have a different subtype, it must be created in Oracle NetSuite
Jobs/Projects
- The Oracle NetSuite character limit for Jobs/Projects is 100 characters.
Custom Fields
- Custom fields do not sync from Oracle NetSuite to Bill.com
- Custom fields are ignored by the sync. They will not prevent the bills from syncing to Bill.com
- Custom fields will be preserved in Oracle NetSuite but will not be visible in Bill.com
- When creating custom fields in Oracle NetSuite, assign a default value to avoid any conflicts
Multi-Currency
Multi-Currency is only available for AP. If you don’t see this feature in your Bill.com account, contact Customer Support to have it enabled.
From Oracle NetSuite to Bill.com
- With Multi-Currency enabled in Bill.com, transactions in Oracle NetSuite that are in a foreign currency will sync to Bill.com in that currency
- If Multi-Currency is not enabled in Bill.com, transactions in Oracle NetSuite that are in a foreign currency will be ignored by the sync
From Bill.com to Oracle NetSuite
- Foreign currency transactions in Bill.com will sync to Oracle NetSuite in the same foreign currency
Attachments
From Oracle NetSuite to Bill.com
- Upload and handle documents in Oracle NetSuite. Attachments will sync from Oracle NetSuite to Bill.com
From Bill.com to Oracle NetSuite
- Attachments will not sync from Bill.com to Oracle NetSuite
Bills
General
- All users, regardless of their assigned role, have access to the View in Bill.com button in Oracle NetSuite
- Customers coded in the bill line items can be prevented from syncing to/from Oracle NetSuite
From Oracle NetSuite to Bill.com
- If a bill is created from a PO, it will sync to Bill.com
- Edit line items for these bills in Oracle NetSuite, editing in Bill.com will unlink the bill from the PO in Oracle NetSuite. The Description field for the line item in Bill.com will indicate the bill is connected to a PO in Oracle NetSuite
- If a bill is partially or fully paid in Oracle NetSuite, it will not sync from Oracle NetSuite to Bill.com
- If the currency for a bill is not US dollars, it will not sync from Oracle NetSuite to Bill.com, unless Multi-Currency is enabled in both Bill.com and Oracle NetSuite
- Documents/files attached to bills in Oracle NetSuite will sync to Bill.com
From Bill.com to Oracle NetSuite
- Bill.com only supports classifications in the line items of a bill. Bills in Oracle NetSuite can be classified both in the general section of the bill, as well as the line items of the bill
- When bills sync from Bill.com to Oracle NetSuite, the general section of the bill will use the selections that are set as the Default Payables classification in the Bill.com Preferences
- To make it easier to reclassify these records (as needed), create a department, location, and/or class called Unclassified, Uncoded or something similar, and set that as the Default Payables classification. This will allow a report to be run in order to isolate the bills that need to be reclassified
- If Oracle NetSuite’s “Only Sync Approved Bills/Credits” is enabled, bills will not sync to Oracle NetSuite unless their Approval Status is Approved
- When bills sync to Oracle NetSuite, their status will automatically be set as:
- Approved in Oracle NetSuite, if Oracle NetSuite approvals are turned off
- Pending Approval if Oracle NetSuite approvals are turned on
- Once a bill is approved in Bill.com and syncs to Oracle NetSuite, changes to the approval status will not sync
- When bills sync to Oracle NetSuite, their status will automatically be set as:
- If Bill.com’s “Sync only approved Bills/ Vendor Credits” preference is selected, bills will not sync to Oracle NetSuite unless their Approval Status is Approved in Bill.com
- When bills sync to Oracle NetSuite with this enabled, their Oracle NetSuite approval status will not be changed
- Once a bill is approved in Bill.com and syncs to Oracle NetSuite, changes to the approval status will not sync
Invoices
General
- All users, regardless of their assigned role, have access to the View in Bill.com button in Oracle NetSuite
From Oracle NetSuite to Bill.com
- If an invoice is partially or fully paid in Oracle NetSuite, it will not sync from Oracle NetSuite to Bill.com
- If the currency for an invoice is not USD (US dollars,) it will not sync from Oracle NetSuite to Bill.com
- $0 invoices in Oracle NetSuite will sync to Bill.com as unpaid invoices if they do not have payments on them in Oracle NetSuite
- Once invoice has synced with Oracle Netsuite, it can't be edited in Bill.com. Edit will need to be managed in Oracle NetSuite.
- Sales tax will sync into Bill.com as a line item from Oracle NetSuite. It will not be editable in Bill.com.
- Discount Items:
- Discount items at the header level of an invoice in Oracle NetSuite will not sync to Bill.com
- Discount Items at the line item level will sync into Bill.com as a line item from Oracle NetSuite. It will not be editable in Bill.com.
- Discount line items will apply to the line item directly above it only
- Discounts in Oracle NetSuite are a percentage, when synced to Bill.com it will be a total amount based on the calculation in Oracle NetSuite. The percentage will not show in Bill.com.
- Edits to discount line item in Bill.com will not sync back to Oracle NetSuite, they must be managed in Oracle NetSuite.
- Invoices created in non-USD currencies will not sync to Bill.com
- If an invoice was created from a Sales order in Oracle NetSuite, the Sales Order # from Oracle NetSuite will sync and display in the PO # field on the invoice in Bill.com
- The Sales Order # in the PO # field will not be editable in Bill.com
From Bill.com to Oracle NetSuite
- Once an invoice has synced with NetSuite, it is not editable in Bill.com
- Bill.com only supports classifications in the line items of an invoice. Invoices in Oracle NetSuite can be classified both in the general section of the invoice, as well as the line items of the invoice.
- When invoices sync from Bill.com to Oracle NetSuite, the general section of the invoice will use the classification that is set as the Default Receivables classification in the Bill.com Preferences
- To make it easier to reclassify these records (as needed), create a department, location, and/or class called Unclassified, Uncoded or something similar, and set that as the Default Receivables classification. This will allow a report to be run in order to isolate the invoices that need to be reclassified.
Sales Orders
- If an invoice was created from a Sales order in Oracle NetSuite, the Sales Order # from Oracle NetSuite will sync and display in the PO # field on the invoice in Bill.com
- The Sales Order # in the PO # field will not be editable in Bill.com
Vendor Credits
General
- Customers coded in Vendor Credit line items can be prevented from syncing to/from Oracle NetSuite
From Oracle NetSuite to Bill.com
- If a vendor credit is partially applied or fully applied in Oracle NetSuite, it will not sync from Oracle NetSuite to Bill.com
- If the currency for a vendor credit is not US dollars, it will not sync from Oracle NetSuite to Bill.com, unless Multi-Currency is enabled in both Bill.com and Oracle NetSuite
From Bill.com to Oracle NetSuite
- Bill.com only supports classifications in the line items of a vendor credit. Vendor credits in Oracle NetSuite can be classified both in the general section of the bill, as well as the line items of the bill
- When vendor credits sync from Bill.com to Oracle NetSuite, the general section of the vendor credit will use the classification that is set as the Default Payables classification in the Bill.com Preferences
- To make it easier to reclassify these records (as needed), create a department, location, and/or class called Unclassified, Uncoded or something similar, and set that as the Default Payables classification. This will allow a report to be run in order to isolate the vendor credits that need to be reclassified.
- Vendor credit application syncs along with the bill to which it has been applied
- If Oracle NetSuite's “Only Sync Approved Bills/Credits from Bill.com" is selected, vendor credits will not sync from Bill.com to Oracle NetSuite unless their Approval Status is Approved
- When vendor credits sync to Oracle NetSuite their status will automatically be set as:
- Approved in Oracle NetSuite, if Oracle NetSuite approvals are turned off
- Pending Approval if Oracle NetSuite approvals are turned on
- Once a vendor credit is approved in Bill.com and syncs to Oracle NetSuite, changes to the approval status will not sync
- When vendor credits sync to Oracle NetSuite their status will automatically be set as:
- If Bill.com’s “Sync only approved Bills/ Vendor Credits” preference is selected, vendor credits will not sync to Oracle NetSuite unless their Approval Status is Approved in Bill.com
- When vendor credits sync to Oracle NetSuite with this enabled, their Oracle NetSuite approval status will not be changed
- Once a vendor credit is approved in Bill.com and syncs to Oracle NetSuite, changes to the approval status will not sync
- To configure the sync to apply vendor credits in Oracle NetSuite when a period is closed, enable Non-GL Changes to the Accounting Period in Oracle NetSuite:
- Hover over Setup > Accounting, select Manage Accounting Periods
- Select the period in which the vendor credit is dated in order to edit the base period
- Check Allow Non-G/L Changes
Credit Memos
Credit memos do not sync in either direction.
- Credit memos have to be created and applied manually in both Bill.com and Oracle NetSuite
Bill Payments
General
- If a bill is paid outside of Bill.com, mark it as paid in Bill.com and allow that payment record to sync into Oracle NetSuite
- Recording the payment in Oracle NetSuite first will cause sync errors
- Payments made in Bill.com can be edited in Oracle NetSuite
- All users, regardless of their assigned role, have access to the View in Bill.com button in Oracle NetSuite
- The memo field for Offline Payments in Bill.com doesn't sync to Oracle NetSuite
From Oracle NetSuite to Bill.com
- Bill Payments do not sync from Oracle NetSuite into Bill.com
From Bill.com to Oracle NetSuite
- Bill.com does not support departments, locations, and/or classes on bill payments
- When a payment is voided in Bill.com, the void will sync to Oracle NetSuite
- When bill payments sync from Bill.com to Oracle NetSuite, they will use the classification that is set as the Default Payables classification in the Bill.com Preferences
- To make it easier to reclassify these records (as needed), you can create a department, location, and/or class called Unclassified, or Uncoded, or something similar, and set that as the Default Payables classification. This will allow a report to be run in order to isolate the bill payments that need to be reclassified.
- A payment made in Bill.com can ONLY be voided in Bill.com
Invoice Payments
From Oracle NetSuite to Bill.com
Invoice Payments do not sync to Bill.com from Oracle NetSuite. It is best practice to always enter payments in Bill.com and allow them to sync to Oracle NetSuite, even if you made the payment outside of Bill.com.
- If your customer pays an invoice outside of Bill.com, mark the invoice as paid in Bill.com and allow that payment to sync into Oracle NetSuite. Recording the payment in Oracle NetSuite first will cause sync errors.
_From Bill.com to Oracle NetSuite
Bill.com does not support departments, locations, and/or classes on invoice payments.
- When invoice payments sync from Bill.com to Oracle NetSuite, the payment record uses the classification that is set as the Default Receivables classification in Bill.com Preferences within Oracle NetSuite
- To make it easier to reclassify these records as needed, create a department, location, and/or class called Unclassified, Uncoded or something similar, and set that as the Default Receivables classification. This will allow you to run a report in Oracle NetSuite in order to isolate the invoice payments that need to be reclassified.
Purchase Orders
- The purchase order record only exists in Oracle NetSuite, therefore it cannot be viewed in Bill.com
- When a bill is created from a purchase order in Oracle NetSuite, that bill will sync into Bill.com. The bill can then be paid in Bill.com.
- Edit line items for these bills in Oracle NetSuite, editing in Bill.com will unlink the bill from the PO in Oracle NetSuite. The Description field for the line item in Bill.com will indicate the bill is connected to a PO in Oracle NetSuite
- Ex: Description: Linked to Oracle NetSuite Record - do not change account, item, or classifications
- The PO Number field on bills in Bill.com will populate with the Oracle NetSuite Purchase Order number
AP Funds Transfers
From Bill.com to Oracle NetSuite
- AP funds transfers sync to Oracle NetSuite as journal entries
- {P does not support departments, locations, and/or classes on AP funds transfers
- When AP funds transfers sync from Bill.com to Oracle NetSuite, they will use the classification that is set as the Default Payables classification in the Bill.com Preferences
- To make it easier to reclassify these records (as needed), you can create a department, location, and/or class called Unclassified, or Uncoded, or something similar, and set that as the Default Payables classification. This will allow a report to be run in order to isolate the funds transfers that need to be reclassified
AR Funds Transfers
- AR funds transfers sync to Oracle NetSuite as journal entries
- Bill.com does not support departments, locations, and/or classes on AR funds transfers
- When AR funds transfers sync to Oracle NetSuite, the entry will use the classification that is set as the Default Receivables classification in Bill.com Preferences within Oracle NetSuite
- To make it easier to reclassify these records (as needed), create a department, location, and/or class called Unclassified, Uncoded or something similar, and set that as the Default Receivables classification. This will allow a report to be run in order to isolate the AR funds transfers that need to be reclassified.
