Trial Balance Sheet in X++

(0) Share

Report

Posted on by Community Member

Hi Experts,

I am working on a report to calculate closing with specific main accounts and Cost Center dimensions.I have seen LedgerTrialBalanceDP class, it is calculating fiscal year and financial dimension set wise, but i want any date range with dimension parameter value like cost center 009.

public void processReport()
{
    LedgerTrialBalanceTmp cfzLedgerTrialBalanceTmp;
    LedgerTrialBalanceDP trialBalanceDP = new LedgerTrialBalanceDP();
    
    List selected = new List(Types::Enum);
    selected.addEnd(CurrentOperationsTax::Current);
    
    LedgerTrialBalanceTmp::calculateBalances(
                LedgerTrialBalanceTmp,
                "MA CC",
                mkDate(1,1,2015),
                mkDate(5,1,2015),
                false,
                false,
                false,
                selected,
                true,
                true,
                Ledger::current());

    cfzLedgerTrialBalanceTmp = trialBalanceDP.getLedgerTrialBalanceTmp();
}

written below code for testing purpose in my custom dp class, but it returns no records to table buffer at the end. Some one please guide me how to achieve this.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Rahul Mohta 21,032 on at

Like (0)

Report

what is the requirement here?

have you considered using financial reports when reporting out of COA, FD and dates

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rahul,

Below is default inquiry. Data with empty cost center also displays.

But i want report with date range out of fiscal period and selected cost center like below.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Faran Beyg,

Rather than trying to modify this standard form and functionality, I would recommend using a financial report for that purpose.

In the financial report designer you can easily create a trial balance report that also includes $0 lines.

This standard financial report functionality works out of the box and does not require a costly code modification.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Hi Ludwig,

My functional team tried to achieve this through MR but faced filter issue. Any how i got it using default Dp class access in my custom Dp class. I am attaching code for reference. Report is working fine now.

[ SRSReportParameterAttribute(classstr(CFZLandedCostSheetContract)) ] class CFZLandedCostSheetDP extends SrsReportDataProviderPreProcessTempDB { LedgerTrialBalanceTmp trialBalanceTmp; CFZLandedCostTmp cfzLandedCostTmp; CFZLCDimensionFilter cfzLCDimensionFilter; CFZMainAccountFilter cfzMainAccountFilter; CFZLandedCostSheetContract contract; TransDate fFromdate, tTodate; List dimensionLClist,mainAccountlist; ListEnumerator dimensionLCEnum,mainAccountEnum; [SRSReportDataSetAttribute(tablestr('CFZLandedCostTmp'))] public CFZLandedCostTmp getCFZLandedCostTmp() { //select data from table buffer select * from cfzLandedCostTmp; //return the buffer return cfzLandedCostTmp; } public void processReport() { LedgerTrialBalanceDP trialBalanceDP = new LedgerTrialBalanceDP(); LedgerTrialBalanceContract trialBalanceContract = new LedgerTrialBalanceContract(); contract = this.parmDataContract() as CFZLandedCostSheetContract; fFromdate = contract.parmFromDate(); tTodate = contract.parmToDate(); mainAccountlist = contract.parmMainAccount(); dimensionLClist = contract.parmDimensionLC(); List selected = new List(Types::Enum); selected.addEnd(CurrentOperationsTax::Current); DimensionHierarchy dimHier; UserConnection userConn; ; dimHier = DimensionHierarchy::getMainAccountFocus(); userConn = new UserConnection(); trialBalanceTmp.setConnection(userConn); trialBalanceContract.parmFromDate(fFromdate); trialBalanceContract.parmToDate(tTodate); trialBalanceContract.parmIncludeOpening(False); trialBalanceContract.parmIncludeClosing(False); trialBalanceContract.parmPostingLayers(selected); trialBalanceContract.parmPrimaryDimensionFocus("MA CC"); trialBalanceDP.parmDataContract(trialBalanceContract); trialBalanceDP.processReport(); trialBalanceTmp = trialBalanceDP.getLedgerTrialBalanceTmp(); //MainAccount filter if (mainAccountlist && !mainAccountlist.empty()) { mainAccountEnum = mainAccountlist.getEnumerator(); while (mainAccountEnum.moveNext()) { cfzMainAccountFilter.clear(); cfzMainAccountFilter.MainAccountId = mainAccountEnum.current(); cfzMainAccountFilter.insert(); } } //Dimension filter if (dimensionLClist && !dimensionLClist.empty()) { dimensionLCEnum = dimensionLClist.getEnumerator(); while (dimensionLCEnum.moveNext()) { cfzLCDimensionFilter.clear(); cfzLCDimensionFilter.DimensionValues[2] = dimensionLCEnum.current(); cfzLCDimensionFilter.insert(); } } while select trialBalanceTmp join cfzLCDimensionFilter where trialBalanceTmp.DimensionValues[2] == cfzLCDimensionFilter.DimensionValues[2] join cfzMainAccountFilter where trialBalanceTmp.DimensionValues[1] == cfzMainAccountFilter.MainAccountId { cfzLandedCostTmp.DisplayValue = DimensionAttributeValueCombination::find(trialBalanceTmp.LedgerDimension).DisplayValue; cfzLandedCostTmp.OpeningBalance = trialBalanceTmp.OpeningBalance; cfzLandedCostTmp.EndingBalance = trialBalanceTmp.EndingBalance; cfzLandedCostTmp.PrimaryFocus = trialBalanceTmp.PrimaryFocus; cfzLandedCostTmp.PrimaryFocusDescription = trialBalanceTmp.PrimaryFocusDescription; cfzLandedCostTmp.DimensionValues[2] = trialBalanceTmp.DimensionValues[2]; cfzLandedCostTmp.DimensionValues[1] = trialBalanceTmp.DimensionValues[1]; cfzLandedCostTmp.insert(); } } }

Was this reply helpful? Yes No