Hi to all,
Please help me, i want to generate a ledger reports that will show every transaction lines per journal entry. My desired output is below:
Journal number Voucher Number
JN00000001 >>>>>>> Journal Entry
00000001 >>>>>> transaction lines
00000002 >>>>>> transaction lines
JN00000002 >>>>>>> Journal Entry
00000003 >>>>>>> transaction lines
00000004 >>>>>>> transaction lines
In my Report Design, I have 2 programmableSection, for JournalNumber and Voucher Number;
My code is:
LedgerJournalTable tblLedgerJournalTable;
LedgerJournalTrans tblLedgerJournalTrans;
str strJournalNum, strVoucherNum;
while select * from tblLedgerJournalTable{
strJournalNum = tblLedgerJournalTable.JournalNum
element.execute(1);
while select * from tblLedgerJournalTrans where tblLedgerJournalTrans.JournalNum == strJournalNum{
strVoucherNum = tblLedgerJournalTrans .Voucher;
element.execute(2);
}
}
My code above result is 1 voucher lines per journal only, but in my records i have 2 voucher lines per journal entry’