VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum relation

Posted by vukis on Stack Overflow See other posts from Stack Overflow or by vukis
Published on 2010-05-05T09:44:22Z Indexed on 2010/05/05 9:48 UTC
Read the original article Hit count: 235

Filed under:

dynamics-ax

|

AX

|

axapta

|

Dynamics

Hi. I have following situation: I need to join VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum and take VendTable.Vendgroup. In all cases (queries,or even views) Dynamics ax joins tables VendInvoiceJour.OrderAccount<- VendTable.AccountNum not VendInvoiceJour.InvoiceAccount <- VendTable.AccountNum. I`m trying to use this kind of query: qBdSVendJour = element.query().dataSourceTable(tablenum(VendInvoiceJour)); qBdSVendTbl = qBdSVendJour.addDataSource(tablenum(VendTable)); qBdSVendTbl.relations(true); qBdSVendTbl.joinMode(JoinMOde::InnerJoin); qBdSVendTbl.fetchMode(QueryFetchMode::One2One); qBdSVendTbl.addLink(FieldNum(VendInvoiceJour,InvoiceAccount),FieldNum(VendTable,AccountNum));//(Dynamics ax automaticaly corrects InvoiceAccount to orderaccount in reports if trying this link in morphx)

© Stack Overflow or respective owner

Related posts about dynamics-ax

Using Dynamics AX's Business Conectors to Generate Sales Orders

as seen on Stack Overflow - Search for 'Stack Overflow'
So, just like the title says, I need to create an application that gets data from another Database, and shoves it through Dynamics AX's throat. This data comes from a portal, not Enterprise Portal, but a PHP one. It stores some data from the order in a separate database. So as said, I need to 'import'… >>> More
Problems connecting to MS Dynamics AX 2009 Application Object Server

as seen on Server Fault - Search for 'Server Fault'
I've got a funny problem connecting to an AOS server. I got a domain network containing a (VM) Server running the Application Object Server (AOS). Client computer A) can connect to the AOS without problems and work. When client computer B) tries to connect, all I get is this error message: Logon… >>> More
Dynamics AX 2009 Visual Studio Template Files

as seen on Stack Overflow - Search for 'Stack Overflow'
Where online can I download the Visual Studio template files for Microsoft Dynamics AX 2009? >>> More
Creating Tables and Retrieving Query results with Dynamics AX 2009 business connector

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a C# command line tool to fetch data from AX and to add data (create new tables) to AX. Fetching data from an AX table is easy and documented here: http://msdn.microsoft.com/en-us/library/cc197126.aspx Adding data to an existing table is also easy: http://msdn.microsoft.com/en-us/library/aa868997… >>> More
Examples of Dynamics AX 2009 programming?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm just learning to program Dynamics AX 2009. So far I got the dev system running, I got some background about the architecture. Now I'm looking for some walkthrough-samples to learn more about programming in this system. Are there some samples available online? Can someone point me to some learning… >>> More

Related posts about AX

Using Dynamics AX's Business Conectors to Generate Sales Orders

as seen on Stack Overflow - Search for 'Stack Overflow'
So, just like the title says, I need to create an application that gets data from another Database, and shoves it through Dynamics AX's throat. This data comes from a portal, not Enterprise Portal, but a PHP one. It stores some data from the order in a separate database. So as said, I need to 'import'… >>> More
OpenID Simple Registration (sreg) vs. Attribute Exchange (ax)

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the relationship between the OpenID sreg and ax extensions? How does a relying party know which one to request, or both? >>> More
Runtime error of TASM language help!

as seen on Stack Overflow - Search for 'Stack Overflow'
.model small .stack 400h .data message db "hello. ", 0ah, 0dh, "$" firstdigit db ? seconddigit db ? thirddigit db ? number dw ? newnumber db ? anumber dw 0d bnumber dw 0d Firstn db 0ah, 0dh, "Enter first 3 digit number: ","$" secondn db 0ah, 0dh, "Enter second 3 digit number: ","$" messageB db… >>> More
Matplotlib canvas drawing

as seen on Stack Overflow - Search for 'Stack Overflow'
Let's say I define a few functions to do certain matplotlib actions, such as def dostuff(ax): ax.scatter([0.],[0.]) Now if I launch ipython, I can load these functions and start a new figure: In [1]: import matplotlib.pyplot as mpl In [2]: fig = mpl.figure() In [3]: ax = fig.add_subplot(1… >>> More
ASM programming, how to use loop?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. Im first time here.I am a college student. I've created a simple program by using assembly language. And im wondering if i can use loop method to run it almost samething as what it does below the program i posted. and im also eager to find someome who i can talk through MSN messanger so i can… >>> More