Excel Add-In for NetSuite

Build 25.0.9434

salesOrdered

Tracks items that have been ordered but not yet invoiced or fulfilled.

Columns

Name Type References Description
account String The general ledger account associated with the transaction line, used for financial posting and categorization.
amount Decimal The total amount on the transaction line, including tax and discounts where applicable.
amountnet Decimal The net amount on the line item, excluding taxes or additional charges.
class String The class segmentation value applied to the transaction, often used for departmental or regional reporting.
costestimate Decimal The estimated cost of fulfilling the line item, used for profit margin and forecast analysis.
department String The department associated with the sale, typically used for internal reporting and financial structuring.
employee String The sales representative responsible for the transaction, used in sales tracking and commission calculations.
entity String The customer or entity placing the order, linked to the transaction for billing and reporting.
estgrossprofit Decimal The estimated gross profit on the transaction line, calculated as revenue minus estimated cost.
estgrossprofitpercent Double The estimated gross profit as a percentage of revenue, used to assess margin performance.
item String The item or Stock Keeping Unit (SKU) being sold on this transaction line.
itemcount Double The quantity of the item ordered on this transaction line.
location String The physical location or warehouse associated with the transaction, affecting inventory allocation and tax.
memo String An optional internal note attached to the transaction line, visible only to users with access.
partner String The partner associated with the transaction, used for tracking partner sales and calculating partner commissions.
subsidiary String The subsidiary under which the transaction is recorded, relevant in multi-entity NetSuite environments.
trandate Date The date of the transaction, used for accounting, period close, and reporting.
tranline String The identifier for the specific transaction line, used to reference line-level data within the broader transaction.
transaction String The overarching transaction record (such as a sales order or invoice) that this line belongs to.
type String The type of transaction this line is part of, such as Sales Order, Invoice, or Credit Memo.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434