Wednesday, 11 February 2015

Adding Account Category field in summary trial balance Report RDP

  1. In the DP class of the summary trial balance report paste the following code to show insert the records in record-set to display account category.


  update_recordSet _ledgerTrialBalanceStagingTmp setting accountcategory=MainAccountCategory.AccountCategory
    where MainAccount.MainAccountId ==ledgerTrialBalanceStagingTmpReference.PrimaryFocus
    join MainAccountCategory where MainAccountCategory.AccountCategoryRef == MainAccount.AccountCategoryRef;
*********************************************************************************    2. Adding The fields in standard Ledger reports.

 update_recordSet _ledgerTransStatementTmp setting JournalNum =ledgerjournaltrans.JournalNum,Invoice =ledgerjournaltrans.Invoice join ledgerjournaltrans where ledgerjournaltrans.Voucher == _ledgerTransStatementTmp.Voucher;//to Print tjhe journal number of ledger report
    update_recordSet _ledgerTransStatementTmp setting JournalName =ledgerjournaltable.Name join ledgerjournaltable where ledgerjournaltable.JournalNum == _ledgerTransStatementTmp.JournalNum;//to Print tjhe journal name of ledger report }
*********************************************************************************
  3. To stop the checklist msg which is appearing every time when user log into ax

static void SysCheckList_Update(Args _args)
{
 SysCheckList_Update::finalizeMinorUpgrade();
}
*********************************************************************************
 4.To retrieve the query range from the dynamic Query in SSRS Report

CustProvisonBalanceTemp.DynamicParameter1= SysQuery::findOrCreateRange(query.dataSourceTable(tableNum(CustTable)), fieldNum(CustTable, AccountNum)).value();

*********************************************************************************

No comments:

Post a Comment