Dear Experts, Iam unable to display anything on the screen, iam only able to see the heading rest everything is blank.... Just Help [#Menu: Inventory Books] Add: Key Item :After: @@locPhysicalStockRegister: Re-ordering of Stock + : R : Display : STQuery [Report: STQuery] Use : DSP Template Form : STQuery Title : "Re-Ordering of Stock" PrintSet : Report Title : "Re_ordering" [Form: STQuery] Use : DSP Template Parts : DB Title, STQuery Local: Line : DB Title : Local : Field : Name Field: Set as : "Stockwise Breakup" [Part: STQuery] Lines : STQueryT, STQuery Repeat : STQuery : Last30days Sales Scroll : Vertical Common Borders : Yes Total : Lst30days, Lst90Days, ClosQtyCSknl, ToOrderStk [Line: STQueryT] Use : STQuery Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Lines : 0 Local : Field : ItemNameCSknl : Align : Left Local : Field : ItemNameCSknl : Set as: "Particulars" Local : Field : Lst30Days : Set as: "Last 30 Days" Local : Field : Lst90Days : Set as: "Last 90 Days" Local : Field : ClosQtyCSknl : Set as: "Closing Quantity" Local : Field : ToOrderStk : Set as: "To Order Stock" Border : Thin Top Bottom [Line: STQuery] Fields : ItemNameCSknl, Lst30Days, Lst90Days, ClosQtyCSknl, ToOrderStk [Field: ItemNameCSknl] Use : Name Field Set As : $StockItemName [Field: Lst30Days] Use : Number Field Style : Normal Format : "No Zero" Set as : $Tr30Qty Border : Thin Left Right Width : 13 [Field: Lst90Days] Use : Number Field Set As : $Tr90Qty Width : 13 Border : Thin Right [Field: ClosQtyCSknl] Use : Number Field Set As : $TrClQty Width : 13 Border : Thin Right [Field: ToOrderStk] Use : Number Field Set As : $TrOrderQty [Collection : Last30days sales] Type : Voucher Filter : IsSalesVT [collection : Last30days sales0] Source Collection : Last30days sales Walk : Inventory Entries By : *.* Parm Var : SVFromDate: Date : (##SVCurrentDate-30) Parm Var : SVToDate: Date : ##SVCurrentDate Aggr Compute : Tr30Qty:Sum:$ActualQty Aggr Compute : TrClQty:sum:$StkClBalance:StockItem:$StockItemName [collection : Last90days sales0] Source Collection : Last30days sales Walk : Inventory Entries By : *.* Parm Var : SVFromDate: Date : (##SVCurrentDate-90) Parm Var : SVToDate: Date : ##SVCurrentDate Aggr Compute : Tr90Qty:Sum:$ActualQty [System: Formula] ;;TotalQty1 : $$CollQtyTotal:CollVoucher:$InventoryEntries.ActualQty IsSalesVT : $$IsSales:$VoucherTypeName ;; End-of-File
[collection : Last30days sales0] Source Collection : Last30days sales Walk : Inventory Entries By : STock Item Name : $StockItemName
Dear Experts, Attached the TDL File, Few things which iam unable to do are: 1) I want to select the group from the list accordingly it should display stock details. 2) Purchase invoice field is calculating decimal part, that is not needed. 3) Number of months i.e it start counting from april onwards if Period is selected from apr to jul then it should return 4 nos of month. Please help, thanks Johar
Hi Frnd Sorry but due to Busy Schedule i am not able to work on you query but i will give u some hint First Try to Create a Report which display Item wise Closing Stock and sales qty till Today that i think u can do it.then try to get Last One month sale - kindly follow the below code which will help you to get this MDSPFromDate : if $$IsEmpty:##SVFromDate then @@MStartDate else ##SVFromDate MStartDate : $$Max:$$SystemPeriodFrom:$StartingFrom:Company:##SVCurrentCompany MDSPToDate : if $$IsEmpty:##SVToDate then $$Max@MDSPFromDate@MEndingDate else ##SVToDate MEndingDate : $$Min@MFinYrEnding:$EndingAt:Company:##SVCurrentCompany MFinYrEnding : $$Max:$$SystemPeriodTo:$$FinYearEnd@MDSPFromDate:$StartingFrom:Company:##SVCurrentCompany MDualDateStr : $$String@MDSPFromDate + " to " + $$String@MDSPToDate MSingleDateStr : "for " + $$String@MDSPFromDate Monthna : $$FullMonthName:$$String:$radiantmonth ;;;@@MDSPFromDate MYYear : $$YearOfdate:$$string@MDSPFromDate MDSPDateStr : if @@MDSPFromDate = @@MDSPToDate then @@MSingleDateStr else @@MDualDateStr Monthandyear : $$yearofdate:$radiantmonth ;;date ;;;; + "'" + @@myyear above is the few formula that used for some of my TDL which give date calculations Pls try and use this to get your report
For Single month u can use Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : ##SVCurrentDate also there is few more Formula may help u in general for Date calculation in Report MyMonthStart: $$MonthStart@DSPToDate FirstWkEnd: $$WeekEnd@MyMonthStart FirstWkCl: $$FromValue@MyMonthStart:$$ToValue@FirstWkEnd:$ClosingBalance SecWkStart: @@FirstWkEnd + 1 SecWkEnd: $$WeekEnd@SecWkStart SecWkCl: $$FromValue@MyMonthStart:$$ToValue@SecWkEnd:$ClosingBalance the above code display report for Different week - u can use this code with little changes to get different Months