Sales (Invoiced) Analytical Record Type
The sales (invoiced) analytical record type was designed specifically for the analytics data source. It combines fields from the transaction, transaction line, and transaction accounting line record types and includes data that meets the following criteria:
Transaction type is not one of Check, Deposit, InvAdjst, InvReval, InvDistr, InvWksht,
Build, Unbuild, WOIssue, WOCompl, WOClose, VendPymt, BinTrnfr, BinWksht, Commissn,
FxReval, CustDep, CustRfnd, DepAppl, InvTrnfr, ItemShip, ItemRcpt, CustPymt, YtdAdjst,
PurchOrd, TaxPymt, TaxLiab, Transfer, TrnfrOrd, VendAuth, WorkOrd, Payroll, Paycheck,
LiaAdjst, LiabPymt, Sync, RevComm, RevComRv, Custom, Opprtnty, Estimate, SalesOrd, RtnAuth
AND
Transaction posting is 'T'
AND
Account accttype is one of Income, OthIncome, DeferRevenue, UnbilledRec
This record type is the root record type on the Sales (Invoiced) Dataset. Some fields in the record type are also feature dependent, or display values based on custom formula definitions.
For more information about the fields included in the sales (invoiced) analytical record type, see the following table:
Field |
Source Record Type |
Source Field |
Custom formula or feature dependency |
---|---|---|---|
Account |
Transaction Accounting Line |
Account |
N/A |
Amount |
Transaction Line |
Amount (Transaction Currency) |
|
Amount(Net) |
Transaction Line |
Amount(Net) |
|
Class |
Transaction Line |
Class |
Displayed only with Classes feature enabled |
Customer |
Transaction Transaction Line |
Entity |
|
Date |
Transaction |
Date |
N/A |
Department |
Transaction Line |
Department |
Displayed only with Departments feature enabled |
Est. Cost |
Transaction Line |
Est. Cost |
Displayed only with Gross Profit feature enabled |
Est. Gross Profit |
Transaction Line |
Est. Gross Profit |
Displayed only with Gross Profit feature enabled |
Est. Gross Profit Percent |
Transaction Line |
Est. Gross Profit Percent |
Displayed only with Gross Profit feature enabled |
Item |
Transaction Line |
Item |
N/A |
Location |
Transaction Line |
Location |
Displayed only with Locations feature enabled |
Memo |
Transaction Line |
Memo |
N/A |
Partner |
Transaction |
Partner |
N/A |
Posting Period |
Transaction |
Posting Period |
Displayed only with Accounting Periods feature enabled |
Promotion Combinations |
Promotions |
Promotion Code |
Displayed only with SuitePromotions feature enabled |
Quantity |
Transaction Line |
Quantity |
|
Sales Rep |
Transaction |
Employee |
N/A |
Subsidiary |
Transaction Line |
Subsidiary |
Displayed only with Subsidiaries feature enabled |
Quantity |
Transaction Line |
Quantity |
|
Transaction |
Transaction |
Internal Id |
Displays Transaction Display Name instead of Internal Id |
Transaction Line |
Transaction Line |
Internal Id |
N/A |
Transaction Type |
Transaction |
TYpe |
N/A |