Dear Sir, I am creating a new tdl, but m unable to understand the below two things 1.) How to change the Sales Register Date (like Change Date form does) with coding. 2.) How to show data in Columnar format with the options given in the Screenshot. pls help me with this, after this my addin will complete Thanks in Advanced
Dear MPAL below is the code which I am currently using to get columnar DayBook data Code: [#Menu : Gateway of tally] Add : Item : After : Display : Get Columnar : Menu : GMTReportsXYX [Menu:GMTReportsXYX] Title : "Reports" Item : Columnar Register : Display : MisDayCol: Not $$IsEmpty:$$SelectedCmps:$$SelectedCmps [Report : MisDayCol] Title : "Columnar Register" Use : Day Book Set : ColumnarDayBook : Yes Set : Voucher Type Name : "Sales" [#Field: DSP MainDateTitle] Use : Short Date Field Set as : $$Date:$$MachineDate Set Always : Yes I am also using the below code but unable to get the appropriate result Code: [#Menu : Gateway of tally] Add : Item : After : Display : Get Columnar : Menu : GMTReportsXYX [Menu:GMTReportsXYX] Title : "Reports" Item : Columnar Register : Display : MisDayCol: Not $$IsEmpty:$$SelectedCmps:$$SelectedCmps [Report : MisDayCol] Title : "Columnar Register" Use : Day Book Set : ColumnarDayBook : Yes Set: Voucher Type Name:"Sales" [#Field: DSP MainDateTitle] Use : Short Date Field Set as : $$Date:$$MachineDate Set Always : Yes [#Field: COLREGWithVchType] ;Use : Short Date Field Set as : Yes Set Always : Yes [#Field: COLREGWithVchNo] ;Use : Short Date Field Set as : Yes Set Always : Yes [#Field: COLREGWithVchRef] ;Use : Short Date Field Set as : No Set Always : Yes [#Field: COLREGWithSTNo] ;Use : Short Date Field Set as : No Set Always : Yes [#Field: COLREGWithServiceTaxNo] ;Use : Short Date Field Set as : No Set Always : Yes /*[#Field: COLREGWithPANNo] ;Use : Short Date Field Set as : No Set Always : Yes [#Field: COLREGWithCSTNo] ;Use : Short Date Field Set as : No Set Always : Yes*/ [#Field: COLREGWithNarr] ;Use : Short Date Field Set as : No Set Always : Yes [#Field: COLREGWithQty] ;Use : Short Date Field Set as : Yes Set Always : Yes [#Field: COLREGWithRate] ;Use : Short Date Field Set as : Yes Set Always : Yes /*[#Field: COLREGWithAmount] ;Use : Short Date Field Set as : Yes Set Always : Yes*/ [#Field: CMP GetColType] ;Use : Short Date Field Set as : All Items (in One Col.) Set Always : Yes [#Line: DSP ColVchDetail] Border : Thin Bottom any help on this will be appreciated
For Auto column.You can use repeat field (it is like Repeat Line) . Example you can get it from party wise item wise report given in Sample TDl which available folder of Tally developer. You can also find out that how to change date in the same File . apply the same logic in your coding. Regrds Jobimon
Hello John, I am unable to understand the code for change the date from the sample file. can u pls show me an example???
There is one file in the sample file( i do not Remember Exact Name). Please Search with Keyword ##SVFromDate you will find it