PostingTransactionSummary
Presents a detailed summary of posting transactions, essential for financial reporting and reconciliation tasks in NetSuite. Supports filtering by record references with '=' or 'IN' operators. NetSuite OneWorld users can convert results to a specified subsidiary using ConvertToSubsidiary.
Columns
| Name | Type | Description |
| Period_InternalId | String | The internal identifier for the accounting period during which the transaction occurred. This ID is crucial for filtering and organizing data by financial periods, enabling accurate period-based reporting and analysis. |
| Account_InternalId | String | The internal identifier for the general ledger account associated with the transaction. This helps link the transaction to a specific account within the chart of accounts, which is vital for financial reporting, reconciliation, and audit trails. |
| ParentItem_InternalId | String | The internal identifier for the parent item in a hierarchical item structure. Useful for grouping related items and analyzing transactions involving grouped products or services, allowing for detailed item-level tracking. |
| Item_InternalId | String | The internal identifier for the item involved in the transaction. This ID enables detailed analysis and reporting at the item level, helping businesses track sales, purchases, or inventory changes by specific products or services. |
| Entity_InternalId | String | The internal identifier for the entity associated with the transaction, such as a customer, vendor, or partner. Essential for analyzing financial data by entity, this ID helps track transactions and balances for each party involved. |
| Department_InternalId | String | The internal identifier for the department that initiated or is responsible for the transaction. This is critical for departmental reporting, cost center analysis, and allocating expenses or revenues to specific business units. |
| Class_InternalId | String | The internal identifier for the class or category under which the transaction falls, such as business divisions or operational lines. This helps in tracking transactions by classification, like sales regions or product types. |
| Location_InternalId | String | The internal identifier for the location where the transaction took place. This is important for location-based reporting, enabling businesses to analyze performance, revenue, and expenses by physical or organizational location. |
| Subsidiary_InternalId | String | The internal identifier for the subsidiary associated with the transaction. This is vital for multi-subsidiary financial reporting and consolidation, allowing businesses to report on financial data across different entities. |
| Book_InternalId | String | The internal identifier for the accounting book used to record the transaction. Multi-book accounting enables the use of different sets of accounting rules or currencies, and this ID helps in reporting across those books. |
| OriginalAmount | Double | The original transaction amount in the subsidiary’s native currency before any conversion. This is important for tracking the original value of transactions in the currency of the subsidiary, providing a basis for currency conversion calculations. |
| OriginalCurrency | String | The name of the original currency used for the transaction. This is populated only when currency conversion is required. It’s essential for multi-currency analysis and reporting, especially in global financial environments. |
| ConvertedAmount | Double | The transaction amount converted into the subsidiary's functional currency as per the conversion settings. This is used for consolidated financial reporting, allowing comparisons and reconciliations across different currencies. |
| ConvertedCurrency | String | The name of the currency after the conversion has been applied. This is populated only when currency conversion is specified, indicating the currency used in the subsidiary's financial reporting. |
| ConvertToSubsidiary | String | The identifier for the subsidiary that the transaction’s amount will be converted to. This is a key field for multi-subsidiary organizations that need to report and consolidate financial data in a consistent currency. |
| ConvertToRateType | String | Specifies the type of exchange rate to use for converting the transaction amount. This typically defaults to 'Current' but can be adjusted based on the rate type (for example, 'Historical' or 'Average'). Refer to the ConsolidatedExchangeRate table for applicable rates, ensuring the correct exchange rate is applied for reporting purposes.
The allowed values are Average, Current, Historical. |