1,534
hi expert, i have very basic question, i wan to add new field batch number which comes from ledgerJournaltable on ledgerTransAccountlist Report, when i go to LedgerTransListAccountDP, there is queryStr legerTranslist, i just added my table ledgerjournalTable to that Query,also added my new field to report design, and in LedgerTransactionListTmp, but data in report for new field are not populated, where is the problem, please guide me.
Regards.
*This post is locked for comments
my customizations are under
1. Adding new field (Journal num) which is required to display on report added to LedgerTranscatoinlistStaging Tmp.
2. The same field (Journal num) added to another table LedgerTransListTmp.
3. Adding a new Table (LegerEntryJournal) to LegerTranslist Query with outer join General Journal Entry table.
4. added code to Class method LedgerTranslistHelper(create Reportdata)
ledgerentryjournal=queryRun.get(tableNum( ledgerentryjournal))as ledgerentryjournal;
processingStagingTable.JournalNum=ledgerEntryJournal.JournalNumber;
join JournalNumber from ledgerEntryJournal
where LedgerEntryJournal.recId==generalJournalEntry.LedgerEntryJournal;
the code work fine....but the actual report data disturbed.
i.e suppose with out customization the report data show me data on 1786 pages, and when i import the customization the same report show only record for 786 page.
please help me where i making mistake.
Regards.
Hi expert last time i had asked a question regarding a new field in ledgerTransList Report. the new field added to new design successfully and also show on the report, but data are disturbed in original report(Design). please guide me where i have make mistake in code.
There is method processReport() in LedgerTransListAccountDP class. This method calls helper.createReportData();
In createReportData() you can find while loop that process query. You need to assign value to you new field inside of the loop.
Also there is insert_recordset statement that will insert data, you need to modify it as well.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
