Two Questions regarding Sales Register

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

 

Please attach your codes.

 

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

 

Please describe your problem in detail.

 

how to apply these settings (see image attached)




how to change date

 

For Setting of Column use F5
For Date use F2

 

i want to set these settings through coding, & unable to understand how to do this

 

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