Oracle NetSuite: Receivables Invoices

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 toBill.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?
  • 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.