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. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to