I am making a report, where 2 tables are joined. I need to print a
report containing all lines of a specific Invoice Journal
(ledgerJournalTrans) and also the bank account information for each
selected vendor account (VendBankAccount) The problem is that my
report, which I make with the Report Wizard gives me an empty
report. I tried to select the rows through a simple job:
static void Job108(Args _args)
{
LedgerJournalTrans lt;
VendBankAccount vba;
while select JournalNum,
AccountType,AccountNum,Txt,TransTxtLocal,
CurrencyCode,AmountCurDebit, AmountCurCredit, Due from lt
join * from vba
where(lt.journalNum=="XXX" && vba.Vend==lt.AccountNum)
{
print lt.Voucher," ",lt.AccountNum;
print vba.Vend," ",vba.RegistrationNum," ",vba.AccountNum;
}
print "END";
pause;
}
When I run this job I also get an empty result. If I run a select on
the lt table and only select where lt.journalNum=="XXX" then I get
the lines of the entered journal.
If I select * from vba table where vba.vend="YY" then I get the bank
account information for the specific vendor.
But as soon as I make the join I do not get any result. Why does
this happen. I suspect that the problem could be that the vba info
is registered in one company and the Invoice Journal is created in
another parameter company. Is this the case?
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
