Dear sir, Pls help me, I am learner and don't know how to fetch data from vouchers. the screen shoot & working code is att. Thanks in advance Mani The Code is as under: [#Menu: Display Menu] Item: Blank Item: [Sale Orders Report] : Menu: Sale Orders Report [Menu: Sale Orders Report] Item: A. Sale Orders Report: Display: Sale Orders Report [Report : Sale Orders Report] Use : DSP Template ;; Variable: SVFromDate, SVToDate ;; Set : SVFromDate: $$MachineDate ;; Set : SVToDate : $$MachineDate Form : SaleOrders Detail ;; Variables : SVFromDate, SVToDate, SVPrintOrientation ;; Set : SVFromDate: @@DateofLastRegEntry ;; Set : SVToDate : @@DateofLastRegEntry Title : "Sale Orders Detail" [Form : SaleOrders Detail] Use : DSP Template Space Bottom : 0.4 Space Top : 0.5 Space Left : 0.5 Space Right : 0.5 Full Height : Yes Full Width : Yes Full Object : Yes Part : Orders Bills and payrec Set Always : SVPrintOrientation: $$SysName:Landscape Button : Select Company,Close Company,Change Company,Change Period,Print Button,Export Button Background : Lily Yellow [Part : Orders Bills and payrec] Line : Orders Bills and payrec Title, Orders Bills and payrec Led, Orders Bills and payrec Total Line Repeat : Orders Bills and payrec Led: CFBK Summ Voucher ;;My Collection Scroll : Vertical ;;Total : Sale Order Value, Sale Value [Line : Orders Bills and payrec Title] Use : Orders Bills and payrec Led Border : Column Titles Local : Field : SNo : Info : "S. No." Local : Field : Party Ledger : Info : "Ledger Name" Local : Field : Party Orderno : Info : "Order No." Local : Field : Party Orderdt : Info : "Order Date" Local : Field : Party Orderamt: Info : "Order Amount" Local : Field : Party Ordersale: Info : "Sale Amount Against Order" Local : Field : Party Ordersale: Lines: 2 Local : Field : Party Orderrec: Info : "Payment Received Against Order" Local : Field : Party Orderrec: Lines : 2 Local : Field : Party Balance : Info : "Balance" [Line : Orders Bills and payrec Led] Field : SNo Right Fields : Party Ledger, Party Orderno,Party Orderdt,Party Orderamt,Party Ordersale,Party orderrec,Party Balance [Field : SNo] Use : Simple Field Set as : $$Line Border : Thin Left Style : Small Bold Align : Center Width : 5 [Field : Party Ledger] ;;Use : Name Field Set as : $PName ;;"Party Ledger Name" Align : Left Border : Thin Left Style : Small Bold Width : 36+9+9 [Field : Party Orderno] ;;Use : Name Field Set as : $OrNo Align : Left Border : Thin Left Width : 9+9 [Field : Party Orderdt] Use : Name Field Set as : "" Align : Left Border : Thin Left Width : 9+9 [Field : Party Orderamt] Use : Name Field Set as : "" Align : Left Border : Thin Left Width : 9+9 [Field : Party ordersale] Use : Name Field Set as : "" Align : Left Border : Thin Left Width : 9+9 [Field : Party orderrec] Use : Name Field Set as : "" Align : Left Border : Thin Left Width : 9+9 [Field : Party Balance] Use : Name Field Set as : "" Align : Left Border : Thin LeftRight Width : 9 [Line :Orders Bills and payrec Total Line] Use : Orders Bills and payrec Led Border : Column Titles Local : Field : SNo : Info : "" Local : Field : Party Ledger : Info : "" Local : Field : Party Orderno : Info : "" Local : Field : Party Orderdt : Info : "" Local : Field : Party Orderamt: Info : "" Local : Field : Party Ordersale: Info : "" ;;Local : Field : Party Ordersale: Lines: 2 Local : Field : Party Orderrec: Info : "" ;;Local : Field : Party Orderrec: Lines : 2 Local : Field : Party Balance : Info : "" ;;=================================== [Collection: My Collection] Type: Ledger Child Of: $$GroupSundryDebtors ;;Show all the Ledgers falling under Group "Sundry Debtors" or its sub-groups BelongsTo: Yes [Collection: CFBK Voucher] Type : Vouchers : VoucherType Child of : $$VchTypeSalesOrder Belongs To : yes Fetch : Date,order Number,Amount,Inventory Entries ;;=================================== [Collection: CFBK Summ Voucher] Source Collection : CFBK Voucher Walk : Inventory Entries By : PName : $PartyLedgerName By : IName : $StockItemName By : OrNo : $orderNumber Aggr Compute : BilledQty : SUM : $BilledQty Aggr Compute : Amount : SUM : $Amount Search Key : $IName + $PName [Collection: Smp Stock Item] Source Collection : CFBK Voucher Walk : Inventory Entries By : PName : $PartyLedgerName Aggr Compute : BilledQty : SUM : $BilledQty ;Filter : NonEmptyQty [Collection: CFBK Party] Source Collection : CFBK Voucher Walk : Inventory Entries By : IName : $StockItemName Aggr Compute : BilledQty : SUM : $BilledQty ;Filter : NonEmptyQty [Variable: IName] Type : String Repeat : ##DSPRepeatCollection [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName NonEmptyQty : NOT $$IsEmpty:$BilledQty
