where I fetch only the records in the LedgerJournalTrans regarding a
specific JournalNum.
After that I could override the fetch method of the report so that
it looks up the bank account in the VendorBankAccount table and adds
the account information to the report.
I never tried overloading the fetch metod before. Any help are
welcome :)
--- In [email protected], "Thomas"
<[EMAIL PROTECTED]> wrote:
>
> Hello Thomas,
>
> I am pretty new to Axapta and X++. Could you give me a hint about
> how I should restructure the code?
>
> Regards
> Thomas (Lund)
>
> --- In [email protected], "Askeryd Thomas"
> <[EMAIL PROTECTED]> wrote:
> >
> > If the table is not part of a shared virtual company the data is
> not shared between companies.
> > Due to the join u cant just change the company in the middle of
> it. I think you might have to reconstruct your code.
> > Thomas.
> >
> > ________________________________
> >
> > Från: [email protected] genom Thomas
> > Skickat: on 2006-01-25 08:46
> > Till: [email protected]
> > Ämne: [development-axapta] Joining 2 tables gives no result
> >
> >
> > Hello,
> >
> > 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;
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 <http://groups.yahoo.com/gads?
>
t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Mic
>
rosoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11
> w> Programming languages <http://groups.yahoo.com/gads?
>
t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+language
>
s&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wa
> pXFmKisbQ> Microsoft axapta <http://groups.yahoo.com/gads?
>
t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=
>
Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud
> 02Fg>
> > Support exchange <http://groups.yahoo.com/gads?
>
t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=
>
Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITT
> UeqA>
> >
> > ________________________________
> >
> > YAHOO! GROUPS LINKS
> >
> >
> >
> > * Visit your group "development-axapta
> <http://groups.yahoo.com/group/development-axapta> " on the web.
> >
> > * To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
> subject=Unsubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> > ________________________________
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
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.
