hi, i added a stock item named "4 OL BC" to the gate way of tally for easy accessible and set the current month for report with day wise report code is here Code: [#Menu : Gateway of Tally] Add : Item : 4 OL BC : Display : All Stock ItemsS : NOT $$IsEmpty:$$SelectedCmps [Report: All Stock ItemsS] Use : Item Monthly Summary Set : Stock Item Name : "4 OL BC" Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate now i want to add a button to the Report of Item monthly Summary's toolbar to view the previous whole months report for example this the current month report of stock item "4 OL BC" now when i press the button then show the previous month report like below I want to create a button to see the report of the previous month Code: [#Report : item monthly Summary] Local : Form : Default : Add : Button : ShowOnlyAbovesid [Button : ShowOnlyAbovesid Key : F8 Title : ShowOnlyAbovesid Action : Set : SVFromDate : $$MonthStart:##SVCurrentDate -31 Action : Set : SVFromDate : $$MonthStart:##SVCurrentDate -31 so please help to create a button on report of item monthly summary of previous month hope some one will help
the function $$MonthStart gives the date as 01-Month-year. it is not at all necessary that -31 will always give the previous month's date. as it may contain 28/29/30 days even depending on month. therefore, if you give following a try, it may help... Code: $$MonthStart:($$MonthStart:##SVCurrentDate -1) Hope this helps...
Hope this works for you... [#Report : item monthly Summary] Local : Form : Default : Add : Button : ShowOnlyAbovesid [Button : ShowOnlyAbovesid Key : F8 Title : ShowOnlyAbovesid Action : Call : ChgPrevMonth [Function : ChgPrevMonth] 01 : Action : Set : SVFromDate : $$MonthStart:$$PrevMonth:##SVFromDate 02 : Action : Set : SVToDate : $$MonthEnd:$$PrevMonth:##SVFromDate