source code from form : BudgetControlStatistics
example code :
static void TIDF_getBudgetAvailable(Args _args) { //class and table BudgetControlStatisticsManager budgetControlStatsManager = new BudgetControlStatisticsManager(); //table BudgetTmpControlStatistics currentBudgetTmpControlStatistics; BudgetCycle budgetCycle; BudgetCycleTimeSpan budgetCycleTimeSpan; FiscalCalendar fiscalCalendar; DimensionAttributeValueCombination dimensionAttributeValueCombination; DimensionHierarchy dimensionHierarchy; //variable DimensionValue dim1; container conDimValue; MainAccountNum mainAccountNum; RecId ledgerDimension; //financial dimension mainAccountNum = "6100-1001"; dim1 = "5102"; select firstonly dimensionAttributeValueCombination where dimensionAttributeValueCombination.DisplayValue == strFmt("%1-%2",mainAccountNum,dim1) && dimensionAttributeValueCombination.LedgerDimensionType == LedgerDimensionType::BudgetControl; //budget cycle fiscalCalendar = fiscalCalendar::findByCalendarId("2016"); BudgetCycleTimeSpan = budgetCycleTimeSpan::findByNameAndCalendar("SEM",fiscalCalendar.RecId); BudgetCycle = budgetCycle::findBudgetCycleByDate(BudgetCycleTimeSpan.RecId,today()); currentBudgetTmpControlStatistics = budgetControlStatsManager.fillBudgetTmpControlStatistics(Ledger::current(), 'ALL', BudgetControlStatisticsPeriodOption::FiscalPeriod, BudgetBalanceType::Accumulated, BudgetCycle.RecId, dimensionAttributeValueCombination.RecId, 0, 0, true, NoYes::No, true); while select currentBudgetTmpControlStatistics { info(strFmt("%1 -- %2 ",currentBudgetTmpControlStatistics.PeriodStartDate,currentBudgetTmpControlStatistics.TotalFundsAvailableAmountMST)); } }
result :