AX2012 调用试算平衡表获取指定日期期间内科目余额

 

    TransDate           startDate,endDate;    

    LedgerTrialBalanceListPageTmp       LedgerTrialBalanceListPageTmp;
    Name            primaryFocus="Account";
    boolean         includeOpening;
    boolean         includeClosing;
    OperationsTax   postingLayer = OperationsTax::Current;
    
    DimensionAttributeValueCombination  DimensionAttributeValueCombination;
    
    Amount			balance;
    ;
    startDate = mkdate(1,1,2019);
    endDate = mkdate(31,12,2019);
    
    select firstOnly RecId from LedgerTrialBalanceListPageTmp;

    LedgerTrialBalanceListPageTmp::constructBalances( LedgerTrialBalanceListPageTmp,primaryFocus,startDate,endDate, includeOpening,includeClosing,postingLayer);

    select sum(EndingBalance) from LedgerTrialBalanceListPageTmp            
    join  DimensionAttributeValueCombination
            where DimensionAttributeValueCombination.RecId ==  LedgerTrialBalanceListPageTmp.LedgerDimension
            &&DimensionAttributeValueCombination.DisplayValue == "21120";
            
    balance = LedgerTrialBalanceListPageTmp.EndingBalance;
            

  

上一篇:MySQL slave_exec_mode 参数说明


下一篇:使用swagger2-2.9.2版本的问题