Invoices (Invoices) Export Workflow
The Invoices (Invoices) export workflow lets you create new invoices and follow the approval in OpenAir, and then export approved invoices to NetSuite.
You can export both invoice and project header information to the invoice transaction record. This allows you to export project-specific information stored in standard or custom OpenAir fields, and then to display this information on the invoice header in NetSuite and use this information in reports.
All charges in the OpenAir invoice export to NetSuite as line items on the Items, Billable Items, or Billable Expenses subtabs.
You can import the tax amounts calculated for the exported invoice in NetSuite back into the OpenAir invoice, including GST and PST taxes. Set up the Advanced Taxes accounting feature in NetSuite and enable Tax Options in OpenAir. Set up nexuses in NetSuite for the countries or locations from which taxes will be paid and create or identify the tax codes or tax groups for each nexus. When you export an invoice to NetSuite, taxes on the total amount are calculated in NetSuite and import back to the invoice in OpenAir. See Import taxes applied to exported invoices.
If the SuiteTax is enabled for your NetSuite account, NetSuite OpenAir SRP Integration bundle 369637 (previously 2851) to version 2.11 or later is required in order for the tax amount calculated in NetSuite to be imported into OpenAir. With earlier versions, the tax amount calculated in NetSuite with SuiteTax cannot be imported back into OpenAir.
Note that SuiteTax compatibility testing is currently in progress. You should test the NetSuite <> OpenAir integration with the SuiteTax feature on sandbox accounts before you enable the feature in your NetSuite production account. See Known Limitations of SuiteTax (external link to NetSuite SuiteAnswers). See also Legacy Tax or SuiteTax.
If you use the Customer POs (Sales Orders) import workflow to import sales order from NetSuite into OpenAir as Customer POs, you can use a workflow setting to retrieve invoice information sourced from the sales orders in NetSuite and include this information when exporting invoices from OpenAir to NetSuite. See Initialize invoices from corresponding sales orders when exporting invoices to NetSuite.
For information about workflow specific settings, see Invoices (Invoices) Export Workflow Settings.
For information about field mapping definitions for this workflow, see Invoices (Invoices) Export Field Mapping Definition.
Changes made to invoices and charges in OpenAir after the initial export are not exported to NetSuite. The Invoices (Invoices) export workflow can be used to create new invoices in NetSuite but not to update already integrated invoices.
Requirements and Downstream Dependencies
The Expense Reports (Expense Reports) export workflow must be active — You must export expense reports to export invoices. See Expense Reports (Expense Reports) Export Workflow.
Matching NetSuite service item and OpenAir service records must exist before you can export invoices and credit memos from OpenAir to NetSuite.
Invoice approvals must be enabled to export invoices from OpenAir to NetSuite. The Invoices (Invoices) export workflow is not available otherwise.
After you export an invoice from OpenAir to NetSuite, you can apply credit memos, customer deposits and customer payments against the invoice, and import the information back into OpenAir.
-
Credit memos applied in NetSuite are imported into OpenAir as negative invoices. The original OpenAir invoice also shows the credited amount. See Credits (Applied Credit Memos) Import Workflow.
Note:You can also create negative invoices in OpenAir and export them to NetSuite as credit memos. See Send OpenAir Credits (Negative Invoices) as NetSuite Credit Memos Export Workflow.
-
Deposits applied in NetSuite are imported into OpenAir as retainers. See Retainers (Applied Customer Deposits) Import Workflow.
-
Payments applied in NetSuite are imported into OpenAir as payments. See Payments (Invoice Payments) Import Workflow.
Supported Features
Workflow Settings |
Filters |
Advanced Mapping |
Real-Time |
SuiteSignOn |
Monitored Fields |
---|---|---|---|---|---|
|
(Invoice mapping group) |
|
(On Approval) |
|
|
-
Run the integration manually, use a scheduled integration run to create the NetSuite invoice transaction record after the invoice is approved in OpenAir. See Running the Bulk Import and Export Integration on Demand and Scheduling the Integration to Run Automatically.
-
Setup the real-time integration to create the invoice transaction record when the invoice is approved in NetSuite. See Configuring Real-Time Record Export from OpenAir to NetSuite.
-
View and edit the OpenAir invoice record from the NetSuite UI using the SuiteSignOn integration. See Enabling Access to OpenAir From Within NetSuite.
Setting up the Invoices (Invoices) Export Workflow
The Invoices (Invoices) workflow is available as standard.
To set up the Invoices (Invoices) export workflow in NetSuite
-
(Optional) If you want to export OpenAir project header information to the NetSuite invoice, do the following:
-
In NetSuite, go to Setup > Accounting > Accounting Preferences.
-
Clear the Consolidate Projects on Sales Transactions box on the Items/Transactions subtab, under Sales & Pricing.
-
Click Save.
-
-
(Optional) Configure NetSuite to use the OpenAir Invoice number instead of the auto-generated record number for invoices in NetSuite. To do so:
-
In NetSuite, go to Setup > Company >Auto-Generated Numbers, and click the Document Numbers subtab.
-
Check the box under the Allow Override column for Invoice. When checked, exported invoices have the same number in both NetSuite and OpenAir.
-
Click Save.
-
To set up the Invoices (Invoices) export workflow in OpenAir
-
Enable invoice approvals in OpenAir. To do so:
-
In OpenAir, go to Administration > Global settings > Organization > Approval Options.
-
Check the Enable approvals for invoices box.
-
Click Save.
-
-
Set up the Expense Reports (Expense Reports) export workflow. See Expense Reports (Expense Reports) Export Workflow.
-
(Optional) If you want to export OpenAir project header information to the NetSuite invoice, do the following:
-
In OpenAir, go to Administration > Application Settings > Invoices > Other Settings.
-
Check the One project per invoice box.
-
Click Save.
-
-
(Optional) Set up related workflows and integration features:
-
To import Credit memos applied in NetSuite into OpenAir as negative invoices, see Credits (Applied Credit Memos) Import Workflow.
-
To create negative invoices in OpenAir and export them to NetSuite as credit memos, see Send OpenAir Credits (Negative Invoices) as NetSuite Credit Memos Export Workflow.
-
To import deposits applied in NetSuite into OpenAir as retainers, see Retainers (Applied Customer Deposits) Import Workflow.
-
To import payments applied in NetSuite into OpenAir as payments, see Payments (Invoice Payments) Import Workflow.
-
To export expense reports from OpenAir to NetSuite as vendor bills and include billable items from vendor bills when exporting invoices from OpenAir to NetSuite, see Expense Reports (Expense Reports) Export Workflow and Employees (Vendors) Import Workflow.
-
To bill activities of all types, make sure you import both service items and other types of items from NetSuite into OpenAir as services records using the Services (Services Items) import workflow. See Disable NetSuite service type filtering for services in NetSuite integration.
-
-
In OpenAir, go to Administration > NetSuite Connector > Mapping.
-
Click New workflow then Invoices (Invoices).
-
Click Invoices (Invoices) in the list of integration workflows.
-
Click Workflow settings to view and modify the settings specific to this workflow. For more information about the workflow settings, see Invoices (Invoices) Export Workflow Settings.
-
Modify the field mapping definition tables for the Invoices (Invoices) export workflow as required. See Mapping OpenAir Fields and NetSuite Fields and Invoices (Invoices) Export Field Mapping Definition.
-
Click the switch next to the workflow name to activate
or to deactivate
the workflow.
-
Click Save.
-
(Optional) Add the Invoices (Invoices) export workflow to a workflow group and schedule it to run automatically. See Scheduling the Integration to Run Automatically.