projStatement Class [AX 2012]
The projStatement class is the base class that is used to handle any kind of project statement report.
| Method | Description | |
|---|---|---|
| a100_Total_Revenue | Calculates and returns the total revenue for a particular project or for all projects that is used on project statement reports. This method can be used to determine either the actual amount or budgeted amount. It also caches this value so that it is not recalculated when the method is called again. |
| a105_Invoiced_Revenue | Calculates and returns the total invoiced revenue for all the transaction types, such as hour, item, expense, revenue, and on-account, for a particular project or for all projects that are used on any kind of project statement report. |
| a110_Invoiced_Revenue_Hour | Calculates and returns the total revenue for all the invoiced hour transactions for a particular project or for all projects. |
| a110_Invoiced_Revenue_Hour_Qty | Calculates and retrieves the total quantity for all invoiced hour transactions for a particular project or for all projects. |
| a115_Invoiced_Revenue_Item | Calculates and returns the total revenue for all the invoiced item transactions for a particular project or for all projects. |
| a120_Invoiced_Revenue_Expenses | Calculates and returns the total revenue for all of the invoiced expense transactions for a particular project or for all projects. |
| a125_Invoiced_Revenue_Revenue | Calculates and returns the total revenue for all the invoiced revenue transactions for a particular project or for all projects. |
| a135_Invoiced_Revenue_OnAccount | Calculates and returns the total revenue for all the invoiced on-account transactions for a particular project or for all projects. |
| a200_Accrued_Revenue | Calculates and returns the total accrued revenue for a particular project or for all projects that are used on any kind of project statement report. |
| a210_Accrued_Salesvalue | Calculates and returns the total accrued revenue in sales for a particular project or for all projects that are used on any kind of project statement report. |
| a215_Accrued_Revenue_Salesvalue_Hour | Calculates and returns the total accrued revenue in sales for all of the hour transactions for a particular project or for all projects. |
| a220_Accrued_Revenue_Salesvalue_Item | Calculates and returns the total accrued revenue in sales for all of the item transactions for a particular project or for all projects. |
| a225_Accrued_Revenue_Salesvalue_Expenses | Calculates and returns the total accrued revenue in sales for all the expense transactions for a particular project or for all projects. |
| a230_Accrued_Revenue_Salesvalue_Revenue | Calculates and returns the total accrued revenue in sales for all the revenue type transactions for a particular project or for all projects. |
| a235_Accrued_Revenue_Salesvalue_Subscrip | Calculates and returns the total accrued revenue from service subscriptions on a particular project or on all projects. |
| a240_Accrued_Revenue_Production | Calls the a260_Accrued_Revenue_Production_Revenue method, which is used to calculate and return the total accrued revenue from production on a particular project or on all projects. |
| a260_Accrued_Revenue_Production_Expenses | Calculates and returns the total accrued revenue in production on a particular project or on all projects. |
| a260_Accrued_Revenue_Production_Hour | Calculates and returns the total accrued revenue in production on a particular project or on all projects. |
| a260_Accrued_Revenue_Production_Item | Calculates and returns the total accrued revenue in production on a particular project or on all projects. |
| a260_Accrued_Revenue_Production_Revenue | Calculates and returns the total accrued revenue in production on a particular project or on all projects. |
| a265_Accrued_Revenue_Profit | Calculates and returns the total accrued revenue from profits on a particular project or on all projects. |
| a270_Accrued_Revenue_OnAccount | Calculates and returns the total accrued revenue for all on-account transactions for a particular project or for all projects. |
| a285_Accrued_Revenue_Profit_Expenses | Calculates and returns the total accrued revenue from profits on a particular project or on all projects. |
| a285_Accrued_Revenue_Profit_Hour | Calculates and returns the total accrued revenue from profits on a particular project or on all projects. |
| a285_Accrued_Revenue_Profit_Item | Calculates and returns the total accrued revenue from profits on a particular project or on all projects. |
| a285_Accrued_Revenue_Profit_Revenue | Calculates and returns the total accrued revenue from profits on a particular project or on all projects. |
| a300_Total_Cost | Calculates and returns the total amount that is posted as cost for a particular project or for all projects that is used on any kind of project statement report. |
| a305_Cost | Calculates the total amount that is posted as cost for the transaction types (hour, item, and expense) for a particular project or for all projects that are used on any kind of project statement report. |
| a310_Cost_Hour | Calculates the total amount that is posted as cost for hour transaction types for a particular project or for all projects that are used on any kind of project statement report. |
| a310_Cost_Hour_Qty | Calculates the total number of hours that are posted as cost for hour transaction types for a particular project or for all projects that can be used on any kind of project statement report. |
| a315_Item_Total | |
| a320_Cost_Item | Calculates the total amount that is posted by using the ProjCost ledger posting type for item transaction types for a particular project or for all projects that are used on any kind of project statement report. |
| a325_Cost_Item_Activated | Calculates the total amount that is posted by using the ProjOffsetAccountItem ledger posting type for item transactions for a particular project or for all projects that are used on any kind of project statement report. |
| a330_Cost_Expenses | Calculates the total amount that is posted by using the ProjCost ledger posting type for expense transaction types for a particular project or for all projects that are used on any kind of project statement report. |
| a335_Accrued_Cost | Calculates the total amount that is posted by using the ProjAccruedCost ledger posting type for expense transaction types for a particular project or for all projects that are used on any type of project statement report. |
| a400_Value_Added | Calculates the total value amount in revenue and cost for a particular project or for all projects that can be used on any Profit and Loss project statement report. |
| a500_Gross_Margin | Calculates the gross margin between revenue and cost for a particular project or for all projects that can be used on any type of project statement report. |
| b100_Salesvalue | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for a particular project or for all projects. |
| b100_Salesvalue_qty | Calls the b105_Salesvalue_qty, which is used to calculate the total number of hours that are posted by using the ProjSalesvalueOffset ledger posting type for a particular project or for all projects. |
| b105_Salesvalue | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for item, hour, expense, and revenue transactions for a particular project or for all projects. |
| b105_Salesvalue_qty | Calls the b110_Salesvalue_Hour_qty, which is used to calculate the total number of hours that are posted by using the ProjSalesvalueOffset ledger posting type for hour transactions on a particular project or on all projects. |
| b110_Salesvalue_Hour | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for hour transactions on a particular project or on all projects. |
| b110_Salesvalue_Hour_qty | Calculates the total number of hours that are posted by using the ProjSalesvalueOffset ledger posting type for hour transactions on a particular project or on all projects. |
| b115_Salesvalue_Item | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for item transactions on a particular project or on all projects. |
| b120_Salesvalue_Expenses | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for expense transactions on a particular project or on all projects. |
| b125_Salesvalue_Revenue | Calculates the total amount that is posted by using the ProjSalesvalueOffset ledger posting type for revenue transactions on a particular project or on all projects. |
| b128_Salesvalue_Subscription | Calculates the total amount that is posted by using the ProjWIPSubscription ledger posting type for revenue transactions on a particular project or on all projects. |
| b130_wip_Production | Calls the b150_Production_Revenue method, which is used to calculate the total amount that is posted by using the ProjWIPProduction ledger posting type for revenue transactions on a particular project or on all projects. |
| b150_Production_Expenses | Calculates the total amount that is posted by using the ProjWIPProduction ledger posting type for revenue transactions on a particular project or on all projects. |
| b150_Production_Hour | Calculates the total amount that is posted by using the ProjWIPProduction ledger posting type for revenue transactions on a particular project or on all projects. |
| b150_Production_Item | Calculates the total amount that is posted by using the ProjWIPProduction ledger posting type for revenue transactions on a particular project or on all projects. |
| b150_Production_Revenue | Calculates the total amount that is posted by using the ProjWIPProduction ledger posting type for revenue transactions on a particular project or on all projects. |
| b155_wip_Profit | Calculates the total amount that is posted by using the ProjWIPProfit ledger posting type for revenue transactions on a particular project or on all projects. |
| b175_wip_Profit_Expenses | Calculates the total amount that is posted by using the ProjWIPProfit ledger posting type for revenue transactions on a particular project or on all projects. |
| b175_wip_Profit_Hour | Calculates the total amount that is posted by using the ProjWIPProfit ledger posting type for revenue transactions on a particular project or on all projects. |
| b175_wip_Profit_Item | Calculates the total amount that is posted by using the ProjWIPProfit ledger posting type for revenue transactions on a particular project or on all projects. |
| b175_wip_Profit_Revenue | Calculates the total amount that is posted by using the ProjWIPProfit ledger posting type for revenue transactions on a particular project or on all projects. |
| b200_TotalCostPrice | Calculates the total amount that is posted as cost for a particular project or for all projects that are used in any work in progress (WIP) project statement report. |
| b200_TotalCostPrice_qty | Calls the b205_Salesvalue_qty to calculate the total number of hours that are posted as cost by using the ProjWIPCostvalue ledger posting type for a particular project or for all projects in any work in progress (WIP) project statement report. |
| b205_Salesvalue | Calculates the total amount that is posted as cost for hour, item, and expense transactions for a particular project or for all projects that are used in any work in progress (WIP) project statement report. |
| b205_Salesvalue_qty | Calls the B210_WIP_CostValue_Hour_qty method to calculate the total number of hours posted as cost. |
| b210_wip_CostValue_Hour | Calculates the total amount that is posted by using the ProjWIPCostvalue ledger posting type for hour transactions on a particular project or all projects that are used toward cost in any work in progress (WIP) project statement report. |
| b210_wip_CostValue_Hour_qty | Calculates the total number of hours posted by using the ProjWIPCostvalue ledger posting type for hour transactions on a particular project or all projects used in any WIP project statement report. |
| b215_wip_CostValue_Item | Calculates the total amount that is posted by using the ProjStatusAccountItem ledger posting type for item transactions on a particular project or on all projects that are used toward cost in any work in progress (WIP) project statement report. |
| b220_wip_CostValue_Expenses | Calculates the total amount that is posted by using the ProjWIPCostvalue ledger posting type for expense transactions on a particular project or all projects that are used toward cost in any work in progress (WIP) project statement report. |
| b225_wip_CostAccruals_Expenses | Calculates the total amount that is posted by using the ProjWIPCost ledger posting type for expense transactions on a particular project or all projects, used towards cost in any WIP project statement report. |
| b300_Gross | Calculates the gross amount for a particular project or all projects used in any WIP project statement report. |
| b300_Gross_qty | Calculates the overall total number of hours for a particular project or all projects that are used in any work in progress (WIP) project statement report. |
| b400_wip_Invoiced_OnAccount | Calculates the total amount that is posted by using the ProjWIPInvoicedOnAccount ledger posting type for on-account transactions on a particular project or all projects in any work in progress (WIP) project statement report. |
| b500_Net | Calculates the total net amount that is due on a particular project or on all projects that are used in any work in progress (WIP) project statement report. |
| budgetNoElimination | Adds a range to the query to exclude eliminations in the calculations. |
| c100_Total_Consumption | Calculates the total amount posted for hour, item, and expense transactions on a particular project or on all projects that are used in any project consumption statement report. |
| c105_Consumption_Hour | Calculates the total amount that is posted by using the ProjWIPCostvalue and ProjCost ledger posting types for hour transactions on a particular project or all projects that are used in any project consumption statement report. |
| c105_Consumption_Hour_qty | Calculates the total number of hours that are posted by using the ProjWIPCostvalue and ProjCost ledger posting types for hour transactions on a particular project or on all projects that are used in any project consumption statement report. |
| c110_Consumption_NeverLedger | Calculates the total amount that is posted by using the ProjNeverLedger ledger posting type for hour transactions on a particular project or all projects used in any project consumption statement report. |
| c110_Consumption_NeverLedger_qty | Calculates the total number of hours that are posted by using the ProjNeverLedger ledger posting type for hour transactions on a particular project or on all projects that are used in any project consumption statement report. |
| c115_Consumption_NoLedger | Calculates the total amount that is posted by using the ProjNoLedger ledger posting type for hour transactions on a particular project or all projects that are used in any project consumption statement report. |
| c115_Consumption_NoLedger_qty | Calculates the total number of hours that are posted by using the ProjNoLedger ledger posting type for hour transactions on a particular project or all projects that are used in any project consumption statement report. |
| c120_Consumption_Item | Calculates the total amount that is posted by using the ProjStatusAccountItem and ProjCost ledger posting types for item transactions on a particular project or on all projects that are used in any project consumption statement report. |
| c122_Consumption_Item | |
| c125_Consumption_Cost | Calculates the total amount that is posted by using the ProjWIPCostvalue and ProjCost ledger posting types for expense transactions on a particular project or on all projects that are used in any project consumption statement report. |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| canCreateControlTrans | |
| checkCache | Determines whether the cache requires clearing. If the cache requires clearing, this method calls the clearCache method. |
| checkCalculateNoNeverLedger | Checks whether the ProjNoLedger posting type should be included in the calculations for a particular type of project statement report. |
| checkHourAmount | Determines if hour transactions are calculated as an amount. |
| checkHourQty | Determines whether hour transactions are calculated as quantity. |
| clearCache | Clears the cache used by each type of project statement report if the cache is not empty. |
| clearCacheA | Clears the cache that is used by the P&L and Hour Rate project statement reports. |
| clearCacheB | Clears the cache that is used by the WIP project statement reports. |
| clearCacheC | Clears the cache that is used by the consumption project statement reports. |
| clearCacheD | Clears the cache that is used by the payroll project statement reports. |
| clearCacheE | Clears the cache that is used by the on-account project statement reports. |
| consumptionExpenseCost | |
| consumptionHourQtyAndCost | |
| consumptionItemCost | |
| costAmount | Returns a zero cost amount. This method can be overridden by sub classes that derive from this class. |
| d100_PayrollAllocation | Calculates the total amount that is posted by using the ProjPayrollAllocation ledger posting type for hour transactions on a particular project or all projects used in any payroll project statement report. |
| d100_PayrollAllocation_Qty | Calculates the total number of hours that are posted by using the ProjPayrollAllocation ledger posting type for hour transactions on a particular project or all projects used in any payroll project statement report. |
| e100_Total_Revenue | Calculates the total revenue posted for on-account transactions on a particular project or on all projects that are used in any on-account project statement report. |
| e200_Invoice_Total | Calculates the total invoiced revenue for all transaction types. |
| e300_Invoice_OnAcc | Calculates the total on account invoiced revenue. |
| e310_Invoice_OnAcc_Prepayment | Calculates the total on account invoiced revenue for the prepayment type on the account transaction. |
| e320_Invoice_OnAcc_Deduction | Calculates the total on account invoiced revenue for the deduction type on the account transaction. |
| e330_Invoice_OnAcc_Milestone | Calculates the total on account invoiced revenue for the milestone type on the account transaction. |
| e350_Invoice_OnAcc_BeginningBalance | Calculates the total on account invoiced revenue for beginning balance type on account transaction |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| getQueryValues | Gets the total amount and total quantity for all the records in the ProjTransPosting table or ProjTransBudget table returned by the query built for a project statement report. The two values are returned in a container. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| invoiceOnAccount | |
| ledgerAccruedCost | Indicates whether ProjAccruedCost ledger postings are included in the calculations. |
| ledgerAccruedRevenueOnAccount | Returns false so that ProjAccruedRevenueOnAccount ledger postings are not included in the calculations. |
| ledgerAccruedRevenueSubscription | Returns false so that subscription ledger postings are not included in the calculations. |
| ledgerAccruedTurnoverProd | |
| ledgerAccruedTurnoverProfit | |
| ledgerCost | Returns false so that ProjCost ledger postings are not included in the calculations. |
| ledgerOffsetAccountItem | Returns false so that ProjOffsetAccountItem ledger postings are not included in the calculations. |
| ledgerOnAccount | Returns false so that ProjOnAccount ledger postings are not included in the calculations. |
| ledgerPayrollAllocation | |
| ledgerSalesvalue | |
| ledgerSalesvalueOffset | Returns false so that ProjSalesvalueOffset and ProjWIPSubscription ledger postings are not included in the calculations. |
| ledgerStatusAccountItem | Returns false so that ProjStatusAccountItem ledger postings are not included in the calculations. |
| ledgerTurnover | |
| ledgerWIPCostvalue | Returns false so that ProjWIPCostvalue ledger postings are not included in the calculations. |
| ledgerWIPInvoicedOnAccount | Returns false so that ProjWIPInvoicedOnAccount ledger postings are not included in the calculations. |
| ledgerWIPProduction | Returns false so that ProjWIPProduction ledger postings are not included in the calculations. |
| ledgerWIPProfit | Returns false so that ProjWIPProfit ledger postings are not included in the calculations. |
| ledgerWIPSubscription | Returns false so that subscription ledger postings are not included in the calculations. |
| new | Initializes a new instance of the projStatement class. |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| parmActivityNumber | Gets or sets the ActivityNumber parameter. |
| parmActual | Gets or sets the Actual parameter. |
| parmAmountQty | Gets or sets the AmountQty parameter. |
| parmBudget | Gets or sets the Budget parameter. |
| parmCategoryGroupId | Gets or sets the CategoryGroupId parameter. |
| parmCategoryId | Gets or sets the CategoryId parameter. |
| parmCost | Gets or sets the Cost parameter. |
| parmCustAccount | Gets or sets the CustAccount parameter. |
| parmDepartment | Gets or sets the Department parameter. |
| parmDeviation | Gets or sets the Deviation parameter. |
| parmEmplItemId | Gets or sets the EmplItemId parameter. |
| parmExpenses | Gets or sets the Expenses parameter. |
| parmFixedPrice | Gets or sets the FixedPrice parameter. |
| parmforecastModelId | Gets or sets the forecastModelId parameter. |
| parmFundingSource | Gets or sets the FundingSource parameter. |
| parmHour | Gets or sets the Hour parameter. |
| parmInternal | Gets or sets the Internal parameter. |
| parmInvestment | Gets or sets the Investment parameter. |
| parmItem | Gets or sets the Item parameter. |
| parmLedgerTransDateFrom | Gets or sets the LedgerTransDateFrom parameter. |
| parmLedgerTransDateTo | Gets or sets the LedgerTransDateTo parameter. |
| parmListId | Gets or sets the ListId parameter. |
| parmOnAccount | Gets or sets the OnAccount parameter. |
| parmProjGroupId | Gets or sets the ProjGroupId parameter. |
| parmProjId | Gets or sets the ProjId parameter. |
| parmProjInvoiceProjId | Gets or sets the ProjInvoiceProjId parameter. |
| parmProjTransDateFrom | Gets or sets the ProjTransDateFrom parameter. |
| parmProjTransDateTo | Gets or sets the ProjTransDateTo parameter. |
| parmProjType | Gets or sets the ProjType parameter. |
| parmProjWIPId | Gets or sets the ProjWIPId parameter. |
| parmResponsibleFinancialWorker | Gets or sets the ResponsibleFinancialWorker parameter. |
| parmResponsibleSalesWorker | Gets or sets the ResponsibleSalesWorker parameter. |
| parmResponsibleWorker | Gets or sets the ResponsibleWorker parameter. |
| parmRevenue | Gets or sets the Revenue parameter. |
| parmSorting1 | Gets or sets the Sorting1 parameter. |
| parmSorting2 | Gets or sets the Sorting2 parameter. |
| parmSorting3 | Gets or sets the Sorting3 parameter. |
| parmStateProjType | Gets or sets the StateProjType parameter. |
| parmSubscriptionId | Gets or sets the value of the subscriptionId parameter that holds the subscription ID that is associated with a project. |
| parmSum | Gets or sets the Sum parameter. |
| parmTime | Gets or sets the Time parameter. |
| parmTimeMaterial | Gets or sets the TimeMaterial parameter. |
| parmTransId | Gets or sets the TransId parameter. |
| parmWorker | Gets or sets the value of the projWorkerRecId parameter that holds the record ID of a worker that is associated to a project. |
| payrollAllocation | |
| profitLossHourQty | |
| profitLossTotalCost | |
| profitLossTotalRevenue | |
| psaParmForecastModelIds | |
| psaParmProjAmountUnit | |
| queryActualExcelPivot | |
| queryBudget | Builds the query that is used in running the statement report that shows budget amounts using the ProjTransBudget table as the data source. |
| queryBudgetExcelPivot | |
| queryBudgetExecuted | |
| queryBuild | Determines whether the statement report should contain actual or budget information and builds the appropriate query used in the report by calling the queryRealized method or the queryBudget method. |
| queryBuildExcelPivot | |
| queryExecuted | Builds the query used in running the statement report that shows actual amounts using the ProjTransPosting table as the data source. |
| queryRealized | Builds the query used in running the statement report that shows actual amounts using the ProjTransPosting table as the data source. |
| salesAmount | Returns a zero sales amount. This method can be overridden by sub classes that derive from this class. |
| setAmountProjStatisticExcelPivot | |
| setClearCache | Sets or gets the variable clearCache that determines whether all the cache used for the statement report should be cleared or not. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| setTmpProjStatisticExcelPivot | |
| tmpProjStatisticExcelPivot | |
| toString | Returns a string that represents the current object. (Inherited from Object.) |
| transListQty | Returns zero quantity. This method can be overidden by sub classes that derive from this class. |
| transNoEliminationOrigin | |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| wait | Pauses a process. (Inherited from Object.) |
| wipGrossWIP | |
| wipHourQty | |
| wipInvoiceOnAccount | |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::construct | Creates an instance of the appropriate class that inherits from this class based on the type of project statement report passed in as a parameter. |
| ::insertToExcelExportFile | |
| ::newListProjConsumption | Creates an instance of the projStatementConsumption class and initializes it with values from the input parameters passed in. |
| ::newListProjConsumptionActivity | |
| ::newListProjOnAccount | Creates an instance of the projStatementOnAccount class and initializes it with appropriate values from the input parameters passed in. |
| ::newProjCostTrans | |
| ::newProjEmplTrans | |
| ::newProjItemTrans | |
| ::newProjListHourRate | Creates an instance of the projStatementHourRate class and initializes it with appropriate values from the input parameters passed in. |
| ::newProjListPayroll | |
| ::newProjListProfitLoss | Creates an instance of the projStatementProfitLoss class and initializes it with appropriate values from the input parameters passed in. |
| ::newProjListProfitLossActivity | |
| ::newProjListWIP | Creates an instance of the projStatementWIP class and initializes it with appropriate values from the input parameters passed in. |
| ::newProjListWIPActivity | |
| ::newProjOnAccTrans | |
| ::newProjRevenueTrans | |
| ::newProjStatistic | |
| ::newProjTable | |
| ::statementType2StateType |
Community Additions
ADD
Show: