- 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