Dear Experts, I have created one field for displaying the total sales qty from day one till date, but it not showing me the details, Can anyone help me out???? [#Field : DspQtyOneTitle] Add: Left Fields: At Beginning: Global ACodeT, Global ATotQty Local: Field: ACodeT: Info: " " Local: Field : ATotQty: Info : " " [#Field : DspQtyTwoTitle] Add: Left Fields: At Beginning: Global ACodeT, Global ATotQty [Field : Global ACodeT] Info: "Code" Align: Centre Width: 15 Style: Small;;@@NumberWidth Style: Small [Field : Global ATotQty] Info: "Toatl Sales Qty" Align: Centre Width: 15;;@@NumberWidth Style: Small [#Field : DspStkInfo] Add: Left Fields: Global ACode, Global ATotSQty [Field : Global ACode] Use: Short Name Field Set As: $OnlyAlias Align: Centre Style: Small Width: 15 [Field : Global ATotSQty] Use: Number Field Set As: $TBilledQty ;;Format: "NoZero,Decimals:2" Align: Centre Style: Small [Collection: Total Stock Item] ;;Source Collection: CFBK Voucher Walk: Inventory Entries By: @@IsSalesIName Aggr Compute: TBilledQty: SUM: $BilledQty
First there is a missing SOURCE Collection...........hence there is no data to compute. Secondly... to have data from beginning till date........... please refer to this thread..... http://tdlexpert.com/index.php?thre...te-svtodate-in-sales-voucher.6513/#post-24878