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/