Expense Line Mapping Group
Use the Expense Line mapping group to export information on the expense charges created automatically from approved billable expense receipts and included on the invoice in SuiteProjects Pro to the corresponding expense line items listed on the NetSuite invoice Billable Expenses subtab.
This mapping group is used to export each expense charge as a billable expense line item on the invoice transaction record in NetSuite when the following conditions are met:
-
The expense report containing the billable receipt was exported from SuiteProjects Pro to NetSuite as an expense reports or vendor bill using the Expenses Reports (Expenses Reports) export workflow. See Expense Reports (Expense Reports) Export Workflow.
-
The line item references the NetSuite expense report or vendor bill. Expense charges export as line items listed on the Items subtab on the NetSuite invoice and the Invoice Line mapping group is used otherwise.
The field mappings on the Expense Line mapping group tab are not used for expense charges created manually in SuiteProjects Pro also export. The Invoice Line mapping group is used instead if a Service is selected on the expense charge. See Invoice Line Mapping Group.
Expense charges created manually in SuiteProjects Pro are not exported to NetSuite otherwise.
For reference information and best practice guidelines, review the following topics:
-
References — Overview of record types in SuiteProjects Pro and NetSuite with links to the relevant reference material for information about fields available for mapping.
-
Default Field Mappings — Overview of default field mapping definitions including notes and best practice guidelines where relevant. Information exported by default includes the internal ID of the NetSuite expense report corresponding to the expense report containing the receipt associated with the expense charge in SuiteProjects Pro, the NetSuite expense line ID, and the amount.
-
Additional Field Mappings — There are no specific guidelines for custom field mapping definitions in this mapping group.
References
The following table gives reference information about the records and fields available for custom field mapping definition with links to the relevant reference material. See also Schema Reference Documentation.
|
NetSuite Record type [ |
SuiteProjects Pro Record Type [ |
Mapping Group [ |
|---|---|---|
|
Expense Line Item [ |
Charge [ Data Dictionary: slip |
Expense Line [ |
Default Field Mappings
The following table describes the default field mapping definitions for the Expense Line mapping group tab.
|
NetSuite Field |
D |
SuiteProjects Pro Field |
Notes |
|---|---|---|---|
|
|
|
Looked up SuiteProjects Pro field value —
|
— |
|
|
|
|
— |
|
|
|
Looked up NetSuite field value — The NetSuite expense line item ID corresponding to the SuiteProjects Pro receipt associated with the charge. |
— |
|
|
|
|
The integration respects the currency precision settings for your SuiteProjects Pro account. |
Additional Field Mappings
Review the following guidelines
-
You should contact your SuiteProjects Pro Professional Services representative if you need to make changes to your integration configuration and field mapping definitions.
-
For advanced mapping usage and best practice guidelines, see Advanced Field Mapping Definition.
-
Familiarize yourself with the NetSuite and SuiteProjects Pro technical documentation before attempting to set field mapping definitions using the advanced notation — See Schema Reference Documentation.
No specific guidelines