Hi,
I would add the InventTrans with a not Existsjoin to the InventTable and pass from and to date as Range. In that case U only gets the Items that have no Transactions in the given period. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh [EMAIL PROTECTED] <blocked::blocked::blocked::mailto:[EMAIL PROTECTED]> Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.biz <blocked::blocked::http://www.as-t.biz/> arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 ________________________________ "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank." "The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks." ________________________________ ________________________________ Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von Rajkumar Gesendet: Freitag, 25. April 2008 14:36 An: development-axapta@yahoogroups.com Betreff: [development-axapta] No Transaction Records Hi, I have to print a report which needs to fetch records from InventTable and InventTrans for items which have no physical transaction during a defined period(dates). I have created a query in inventTable and trying to loop through the inventrans records in fetch method and find the items which are not falling in the defined period. The retrived items are passed using element.send(inventTable). It takes lot of time to print the data. Can anybody suggest the proper way to do this. Regards [Non-text portions of this message have been removed]