Dear Sir,. I have created a Sales Order Report with all details of Sales Order .In this sales order Report one Column is Sales Voh no. and another is Billed Qty . I used SearchKey for getting Sales Vch No . Its work Fine no problem. The code and collection I have used for this is below. [Field:Cust ProInvNo] Use: Name Field Set as:$$ReportObject:$$CollectionFieldByKey:$vouchernumber:#CustProOrderNo:test Width: 10 [Collection:Test] Type:vouchers:vouchertype Child Of:$$VchTypeSales Belongs To:yes Fetch:vouchernumber,BasicPurchaseOrderNo,BatchAllocations.*,BilledQty Fetch:StockItemName Search Key:$BasicPurchaseOrderNo Problem is when i used same method for getting the stock item qty that is billed then this is not working may any solve this problem? Screen shot of report is attached . In blue field i want sales item qty. thanks & Regards Rishi
Kindly stop OPENING a new Thread for each and every query. All your issues are regarding the SalesOrder --- so you must continue your subsequent queries in the same thread. It will be easier for others to have a proper LINE and grasp of the subject. कृपया प्रत्येक प्रश्न के लिए एक नया थ्रेड खोलना बंद करें। आपके सभी मुद्दे सेल्सऑर्डर के संबंध में हैं --- इसलिए आपको अपने बाद के प्रश्नों को उसी थ्रेड में जारी रखना चाहिए। दूसरों के लिए उचित लाइन और विषय पर पकड़ बनाना आसान होगा।
Add fetch : inventoryentries.* to your collection Remove search key then create new collection using first one as source In new collection walk : InventoryEntries Compute: BilledQty : $billedQty Compute: BasicPurchaseOrderNo :$$owner:$BasicPurchaseOrderNo SearchKey: $BasicPurchaseOrderNo Use search key here and us new collection in report Note: reply from mobile, there may be spelling errors