Share
Report
1,295Hi,
I would like to ask regarding the select statement syntax.
I have this parameter to pass on to the select statement but I think it is not working.
here is my query:
while select custtrans where
custtrans.TransDate >= fromdate &&
custtrans.TransDate <= toDate &&
custtrans.TransType == LedgerTransType::Payment &&
custtrans.PaymMode != "CWT"
join subLedgerVoucherGeneralJournalEntry where
subLedgerVoucherGeneralJournalEntry.Voucher == custtrans.Voucher
join generalJournalentry where
generalJournalEntry.RecId == subLedgerVoucherGeneralJournalEntry.GeneralJournalEntry
join generalJournalAccountEntry where
generalJournalAccountEntry.LedgerAccount like costCenter &&
generalJournalAccountEntry.GeneralJournalEntry == generalJournalEntry.RecId &&
generalJournalAccountEntry.IsCredit == NoYes::Yes &&
generalJournalAccountEntry.PostingType == LedgerPostingType::CustBalance
the costCenter is my parameter for filter but it is not getting the correct output. my parameter costCenter has only 3letter for me to run the report. how I can use select statement with like starting with 3 letters from costcenter?
I tried this:
join generalJournalentry where
generalJournalEntry.RecId == subLedgerVoucherGeneralJournalEntry.GeneralJournalEntry
join generalJournalAccountEntry where
generalJournalAccountEntry.LedgerAccount like *costCenter &&
generalJournalAccountEntry.GeneralJournalEntry == generalJournalEntry.RecId &&
generalJournalAccountEntry.IsCredit == NoYes::Yes &&
generalJournalAccountEntry.PostingType == LedgerPostingType::CustBalance
it should start with the letter but not working..
I hope someone can help me with this problem. thank you.
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
