pls help me . I want to control Not applicable from table in Delivery note. like New number control in default tally. I make a code but not working. below ar my code [#Part: CLBasic] Option : CLBasic ExcludeNewNumber : $$IsTrackingOn OR ($$IsSalesOrdersOn OR $$IsPurcOrdersOn OR $$IsJobWorkOn OR $$IsJobOrderIn OR $$IsJobOrderOut) Option : CLBasic ExcludeOnAcc : $$IsBillWiseOn Option : CLBasic ExcludeNOTApplicable : $$IsTrackingOn OR ($$IsSalesOrdersOn OR $$IsPurcOrdersOn OR $$IsJobWorkOn OR $$IsJobOrderIn OR $$IsJobOrderOut) ;;case: User has authroized to override Tax classifcation Option : CLBasic AllowTaxOverride : @@IsStatApplicable [#Field: VCHSalesOrder] ; Table : VCH So, New Order Number, Not Applicable : (NOT @@HasBatchWise AND NOT $$IsMultiGodownOn) ; add: Table : VCH SoG, New Order Number : (NOT @@HasBatchWise AND $$IsMultiGodownOn); AND @@CLExcludeNOTApplicable Table : VCH So, New Order Number,Not Applicable : (NOT @@HasBatchWise AND NOT $$IsMultiGodownOn) Table : VCH SoG, New Order Number ,New NOtApplicable Number : (NOT @@HasBatchWise AND $$IsMultiGodownOn) Table : VCH SoB, New Order Number,Not Applicable : (@@HasBatchWise AND NOT $$IsMultiGodownOn) Table : VCH SoBG, New Order Number ,Not Applicable : (@@HasBatchWise AND $$IsMultiGodownOn) [Collection: New NOtApplicable Number] Use : Not Applicable Filter : IsNOTApplicableNumberAllowed [System:UDF] DisallowNotApplicable: Logical:0078 [System:Formulae] IsNOTApplicableNumberAllowed :NOT $$Allow:CLExcludeNOTApplicable:Vouchers OR(@@IsSalesOrder OR @@IsPurcOrder OR @@IsJobOrderIn OR @@IsJobOrderOut) [!Part: CLBasic ExcludeNOTApplicable] Add : Line : After : CL Print Before Save : CL ExcludeNOTApplicable, CL ExcludeNOTApplicableNewNoText ;[#Part: CLBasic ExcludeNewNumber] ; ; Add : Line : After : CL Print Before Save : CL ExcludeNewNumber,CL ExcludeNOTApplicable, CL ExcludeNewNoText ; [Line : CL ExcludeNOTApplicable] Field : Long Prompt, CL ExcludeNOTApplicable Space Bottom : 0.15 Local : Field : Long Prompt : Info : $$LocaleString:"Exclude NOT Applicable from Item Allocations:" [Field: CL ExcludeNOTApplicable] Use : Logical Field Set as : If $$IsEmpty:$DisallowNotApplicable then No Else $$Value Storage : DisallowNotApplicable [Line: CL ExcludeNOTApplicableNewNoText] Field : Left Sub Title Space Bottom : 0.15 Local : Field : Left Sub Title : Info : $$LocaleString:"(for tracking/orders)" Local : Field : Left Sub Title : Style : Normal Italic
I would suggest you to add another table with the conditions you require instead of using a filter in the current collection.