Hi,
I want to filter the ledger report records based on the financial dimensions(main account and cost center) criteria i given on report user request form.
For ex, i have given main account 1001 and cost center ABC but all accounts and cost centers data is displaying on my report.
Can any one help me with some sample code to filter the records based on data i provided.
insert_recordset _ledgerTrialBalanceStagingTmp
(GeneralJournalAccountEntry, GeneralJournalEntry, LedgerDimension, Text, AccountingDate, PostingLayer, TransactionType)
select RecId, GeneralJournalEntry, LedgerDimension, Text from generalJournalAccountEntry
order by generalJournalEntry.AccountingDate, generalJournalAccountEntry.IsCredit
join AccountingDate, PostingLayer from generalJournalEntry where
generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry &&
generalJournalEntry.AccountingDate >= _startDate &&
generalJournalEntry.AccountingDate <= _endDate &&
generalJournalEntry.Ledger == Ledger::current()
join Type from fiscalCalendarPeriod where
fiscalCalendarPeriod.RecId == generalJournalEntry.FiscalCalendarPeriod &&
fiscalCalendarPeriod.Type != FiscalPeriodType::Closing;
I want to apply the financial dimension range on the above filtered records.
Please help me.
Thanks
Satish
