NetSuite — Netting Settlement
These metrics will be used in the Analytics Currency (AC) fact folder, Base Currency (BC) fact folder and Transaction Currency (TC) fact folder in Subject Areas. Analytics currency and exchange rate type will be configured during product implementation. Exchange rate date basis will be work order date to convert to analytics currency. Metrics in these folders will show amounts in their respective currencies.
Metrics
| Metric | Metric Definition |
|---|---|
| Accounting Book Amount | Describes a transaction under NetSuite - Check. This attribute describes the Debit Amount in Analytics Currency. |
| Accounting Book Credit Amount | Describes a transaction under NetSuite - Check. This attribute describes the Line Amount in Analytics Currency. |
| Accounting Book Debit Amount | Describes a transaction under NetSuite - Check. This attribute describes the Credit Amount in Analytics Currency. |
| Accounting Book Net Amount | Describes a transaction under NetSuite - Check. This attribute describes the Line Estimated Gross Profit in Analytics Currency. |
| Accounting Line Credit Amount in Transaction Currency | Describes a transaction under NetSuite - Customer Payment. This attribute describes the Total Number of Customer Payments. |
| Accounting Line Debit Amount in Transaction Currency | Describes a transaction under NetSuite - Deposit Application. This attribute describes the Total Number of Deposit Applications. |
| Credit Amount in Analytics Currency | Describes a transaction under NetSuite - Check. This attribute describes the Credit Amount in Transaction Currency. |
| Credit Amount in Base Currency | Describes a transaction under NetSuite - Item Fulfillment. This attribute describes the Total Number of Item Fulfillments. |
| Credit Amount in Transaction Currency | Describes a transaction under NetSuite - Customer Deposit. This attribute describes the Total Number of Customer Deposits. |
| Debit Amount in Analytics Currency | Describes a transaction under NetSuite - Check. This attribute describes the Line Amount in Base Currency. |
| Debit Amount in Base Currency | Describes a transaction under NetSuite - Item Receipt. This attribute describes the Total Number of Item Receipts. |
| Debit Amount in Transaction Currency | Describes a transaction under NetSuite - Customer Invoice. This attribute describes the Total Number of Customer Invoices. |
| Line Amount in Analytics Currency | Describes a transaction under NetSuite - Revenue Arrangement. This attribute describes the Total Number of Revenue Arrangements. |
| Line Amount in Base Currency | Describes a transaction under NetSuite - GL Impact Adjustment. This attribute describes the Total Number of GL Impact Adjustments. |
| Line Amount in Transaction Currency | Describes a transaction under NetSuite - Cash Refund. This attribute describes the Total Number of Cash Refunds. |
| Linked Amount in Analytics Currency | Describes a transaction under NetSuite - Vendor Return Authorization. This attribute describes the Total Number of Vendor Return Authorizations. |
| Linked Amount in Base Currency | Describes a transaction under NetSuite - Inventory Adjustment. This attribute describes the Total Number of Inventory Adjustments. |
| Linked Amount in Transaction Currency | Describes a transaction under NetSuite - Cash Sale. This attribute describes the Total Number of Cash Sales. |
| Net Amount in Analytics Currency | Describes a transaction under NetSuite - Journal. This attribute describes the Total Number of Journals. |
| Net Amount in Base Currency | Describes a transaction under NetSuite - Estimate. This attribute describes the Total Number of Estimates. |
| Net Amount in Transaction Currency | Describes a transaction under NetSuite - Assembly Unbuild. This attribute describes the Total Number of Assembly Unbuilds. |
| Total Number of Netting Settlement Lines | Describes a transaction under NetSuite - Assembly Build. This attribute describes the Total Number of Assembly Builds. |
| Total Number of Netting Settlements | Describes a transaction under NetSuite - Netting Settlement. This attribute describes the Total Number of Netting Settlements. |
| Unused Payment Line Amount in Analytics Currency | Describes a transaction under NetSuite - Check. This attribute describes the Estimated Gross Profit in Base Currency. |
| Unused Payment Line Amount in Base Currency | Describes a transaction under NetSuite - Inventory Transfer. This attribute describes the Total Number of Inventory Transfers. |
| Unused Payment Line Amount in Transaction Currency | Describes a transaction under NetSuite - Currency Revaluation. This attribute describes the Total Number of Currency Revaluations. |
| Used Payment Line Amount in Analytics Currency | Describes a transaction under NetSuite - Customer Invoice Snapshot. This attribute describes the Estimated Gross Profit in Transaction Currency. |
| Used Payment Line Amount in Base Currency | Describes a transaction under NetSuite - Inventory Count. This attribute describes the Total Number of Inventory Counts. |
| Used Payment Line Amount in Transaction Currency | Describes a transaction under NetSuite - Credit Memo. This attribute describes the Total Number of Credit Memos. |