RE: [Axapta-Knowledge-Village] NotExist join in query using cross reference?

Sun, 26 Jun 2005 17:34:32 -0700

Title: Message
In Axapta we can run/build the cross reference which then allows us in any 'Query' (i.e. where we can put the range and sorting) screen to right click on the tables and add additional tables to query on (very useful)
Thanks
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande
Sent: 27 June 2005 06:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] NotExist join in query using cross reference?

hi
 
I am not sure as to what you mean by cross reference
 
regards
 
harry

James Flavell <[EMAIL PROTECTED]> wrote:
But can I specify it is a not exists join using cross reference?
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan Deshpande
Sent: 25 June 2005 07:59
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] NotExist join in query using cross reference?

hi
 
May be make a not exists join of inventtable with inventtrans, put a filter on inventtrans to select reftype of sales order and date less than 6 months
 
regards
 
harry

James Flavell <[EMAIL PROTECTED]> wrote:
Hi,

I would like to use the inventory aging to show inventory that has not had
any sale in the last 6 months.

I would like to know can I do this using cross refrence without any
modification?
I thought of linking in the custinvjourlines table in the query and then
specifying the invoice date.

Example
AS of today 24/06/2005
Filter custinvjourlines invoicedate criteria: '01/06/2005..'
With a notexists join to the onhand table

Is it possible to specify the join type or is it always InnerJoin when using
cross reference and hence I will have to do some modification?

Thanks
James



Sharing the knowledge on Axapta.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Sharing the knowledge on Axapta.



Sharing the knowledge on Axapta.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Sharing the knowledge on Axapta.



Sharing the knowledge on Axapta.


YAHOO! GROUPS LINKS



Reply via email to