Oracle NetSuite: Receivables Invoices

From Oracle NetSuite to Cashflow360

  • If an invoice is partially or fully paid in Oracle NetSuite, it will not sync from Oracle NetSuite to Cashflow360
  • If the currency for an invoice is not USD (US dollars,) it will not sync from Oracle NetSuite to Cashflow360
  • $0 invoices in Oracle NetSuite will sync to Cashflow360 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 Cashflow360. Edit will need to be managed in Oracle NetSuite.
  • Sales tax will sync into Cashflow360 as a line item from Oracle NetSuite. It will not be editable in Cashflow360.
  • Discount Items:
    • Best practice when using Discount items is to create and manage the invoice in Netsuite and let that sync into BILL.
    • Discount items at the header level of an invoice in Oracle NetSuite will not sync to BILL
    • Discount Items at the line item level will sync into BILL as a line item from Oracle NetSuite. It will not be editable in BILL.
    • Discount line items will apply to the line item directly above it only
    • Discounts in Oracle NetSuite can be a percentage, but only the amount of that discount line item will sync to BILL. The percentage will not show in BILL.
    • If you create an invoice in BILL and select a discount line item, when it syncs to NetSuite the discount will be applied to the entire amount of the invoice, i.e. at the header level.
    • Best Practice:
      • If you would the discount applied at the header level, create the invoice in BILL
      • If you would like the discount applied at the line item level, create the invoice 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 Cashflow360
    • The Sales Order # in the PO # field will not be editable in Cashflow360

From Cashflow360 to Oracle NetSuite

  • Once an invoice has synced with NetSuite, it is not editable in Cashflow360
  • Cashflow360 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 Cashflow360 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.