Using Gross Profit Values in CSV Import, SOAP Web Services, and SuiteScript
After the Gross Profit feature has been enabled, gross profit fields are available for CSV Import, SOAP web services, and SuiteScript. For details, see:
Gross Profit Fields in CSV Import
CSV Import supports the following transaction types that may include gross profit fields: Cash Sale, Estimate, Invoice, Opportunity, and Sales Order. For each type of transaction, the Import Assistant's Field Mapping page lists the NetSuite fields that can be mapped to columns in your CSV file. You can import data for any field listed on this page.
By default, the Field Mapping page includes the NetSuite fields available on your preferred form for the record type. Fields can be mapped for the import job if they are displayed (not hidden) and not disabled on your preferred form. So if gross profit fields are shown on your preferred form for a transaction type, their data can be imported.
The default form for your role may not include all the fields you need to import, so you have the option of specifying another form to provide mappable fields. For record types that allow custom forms, you can specify an existing custom form available to your role, or you can create a custom form specifically for this purpose.
For more information, see:
Gross Profit Fields in SOAP Web Services
SOAP web services integration is supported for gross profit fields on all of the transaction types that may include these fields.
The SOAP Schema Browser details available fields for each supported record type.
-
See transactions sales.xsd for the Cash Sale, Estimate, Invoice, Opportunity, and Sales Order transaction types.
-
See transactions customers.xsd for the Cash Refund, Credit Memo, and Return Authorization transaction types.
For more information about SOAP web services, see SuiteTalk SOAP Web Services Platform Overview.
Gross Profit Fields in SuiteScript
SuiteScript is supported for a subset of gross profit fields on the following transaction types: Cash Refund, Cash Sale, Estimate, Invoice, Opportunity, and Sales Order.
Fields are supported as follows:
|
Field |
Internal ID |
SuiteScript Support |
|---|---|---|
|
Est. Gross Profit |
estgrossprofit |
When this field is on the body of the form in edit mode, this field is scriptable and can be returned in a transaction search. When this field appears on the sublist line level, this field is not scriptable. |
|
Est. Gross Profit Percent |
estgrossprofitpercent |
When this field is on the body of the form in edit mode, this field is scriptable and can be returned in a transaction search. When this field appears on the sublist line level, this field is not scriptable. |
|
Est. Extended Cost |
totalcostestimate |
When this field is on the body of the form in edit mode, this field is scriptable and can be returned in a transaction search. |
For more information, see: