Filter Sales Register Columnar Report Based on UDF

Dear Admin Sir,

I want Delivery Date and Trail Date in Invoice as well as Sales Register Columnar Report. that is done fine.
but now i want filter Sales Register Columnar Report Based on Trail Date.
[E.G for F2: Change Period like that Based on Trail Date Period
Like F7 : Trail Date

FROM DATE : 05/10/2015
TO DATE : 05/12/2015

]

Herewith i Shared the code..

Please help me sir.

;;----------------------------------------------------------------------------------
;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara
;; Serial No :
;; Dealer :
;; Contact No :
;; Objective : Trial Date and Delivery Date
;; Date : 20/11/2015
;; Author : Mr Vishal
;;----------------------------------------------------------------------------------

;;----------------------------------------------------------------------------------
;; Company Level
;;----------------------------------------------------------------------------------

[#Part: CMP AccFeat Left]

Add: Line: CMP EnableModule

[Line: CMP EnableModule]

Field : Medium Prompt, CMP EnableModule
Local : Field : Medium Prompt : Info : "Enable Sales Module ? "
Space Top : 1

[Field: CMP EnableModule]

Use : Logical Field
Storage : CMPEnableModule
Color : Red
Style : Normal Bold


[System: UDF]

CMPEnableModule : Logical : 1001

[System : Formula]

CMPEnableModule: $CMPEnableModule:Company:##SVCurrentCompany ;;and @@isERPPlusModuleOn

;;----------------------------------------------------------------------------------
;; Voucher Level
;;----------------------------------------------------------------------------------

[#Part: DBLLINE Narration]


option : BankDet VCH Narration : @@IsSales AND @@CMPEnableModule


[!Part: BankDet VCH Narration]

Add : Line : At Beginning : TrailDate,DeliveryDate


[Line: TrailDate]


Fields : Medium Prompt, TrailDate
Local : Field : Medium Prompt : Info : $$LocaleString:"Trail Date :"
Local : Field : Medium Prompt : Color : Red

[Field: TrailDate]

Use : Uni Date Field
Storage : TrailDate
Width : 10

[Line: DeliveryDate]


Fields : Medium Prompt, DeliveryDate
Local : Field : Medium Prompt : Info : $$LocaleString:"Delivery Date :"
Local : Field : Medium Prompt : Color : Red

[Field: DeliveryDate]

Use : Uni Date Field
Storage : DeliveryDate
Width : 10


[System: UDF]

TrailDate : Date : 1120
DeliveryDate : Date : 1124

;;----------------------------------------------------------------------------------
;; Columnar Report Level
;;----------------------------------------------------------------------------------

;;------------------------------------------------------
;; Columnar Report Configuration
;;------------------------------------------------------

[#Part: CMP COLBasics]

Option : CMP COLBasics1 : @@CMPEnableModule

[!Part: CMP COLBasics1]

Add : Line : At Beginning : COLREGWithItTD,COLREGWithItDD

[Line: COLREGWithItTD]

Fields : Medium Prompt, COLREGWithItTD
Local : Field : Medium Prompt : Info : $$LocaleString:"Show Trail Date ?"
Local : Field : Medium Prompt : Color : Red

[Field: COLREGWithItTD]

Use : Logical Field
Modifies: COLREGWithItTD
Color : Red

[System: Variables]

COLREGWithItTD : No

[Variable: COLREGWithItTD]

Type : Logical
Persistent : Yes


[Line: COLREGWithItDD]

Fields : Medium Prompt, COLREGWithItDD
Local : Field : Medium Prompt : Info : $$LocaleString:"Show Delivery Date ?"
Local : Field : Medium Prompt : Color : Red

[Field: COLREGWithItDD]

Use : Logical Field
Modifies: COLREGWithItDD
Color : Red


[System: Variables]

COLREGWithItDD : No

[Variable: COLREGWithItDD]

Type : Logical
Persistent : Yes


[#Collection: Columnar Filtered Vouchers of Company]

Fetch : TrailDate, DeliveryDate

[#Line: DSP ColVchTitle]

Local: Field: DBC TD: Set as : $$LocaleString:"Trail Date"
Local: Field: DBC DD: Set as : $$LocaleString:"Delivery Date"

[#Line: DSP ColVchDetail]

Add: Fields : After: DBC VchNo BC TD, DBC DD

[Field: DBC TD]

Set as : $TrailDate
Border : thin left right
Align : Center
width : 12
Invisible : NOT ##COLREGWithItTD

[Field: DBC DD]

Set as : $DeliveryDate
Border : thin left right
Align : Center
width : 12
Invisible : NOT ##COLREGWithItDD

 

Dear,
code giving ERROR : Could not find original discription for Collection: Columnar Filtered Vouchers of Company. Any Solution ?

 

The code is not for current release that's why you are getting this error. If you will run this in earlier version of Tally.ERP9 (4.93 or earlier) then you will not get this error.
If you want to run this in current release then comment the collection which gives error.

 

Dear Experts,
As Maulik sir told it is not working in earlier version also. I am using ERP 9 1.1 . I go through Tally Developer 1.6 to 3.10 could not find these collections. It may be included in later version. For lower version fetching formula must be diff. As Kamdar sir suggested I tried both Collection , Columnar filter voucher of company and filter voucher of company. Both are giving same ERROR " Could not find original description for columnar filter voucher of company ". it means these collection r not exist in these version. Any suggestion.
Thanks.

 

Have you tried in license copy of Tally.ERP9 and check in 4.93

 

Amitji , is there a way to remove the Sales CGst Sgst and Roundoff columns from the columnar register.. Because I have tried this code and the moment i go in columnar register these columns come no matter what.. I want just the total amount.. Is it possible or do we need to make a different display menu completely for this?