error in the below code working in Tally ERP 9 but not in Tally Prime and I also want to use it in Purchase and Sales voucher ?? ;=============================================================== ;======================= F11 Feature =========================== ;=============================================================== [#Part: CMP TallyShopFeatures Left] Add : Line : At End : CMP EnableBrokerLine [Line:CMP EnableBrokerLine] Space Bottom : 1.5 mms Field : Long Prompt,CMP EnableBrokerLine Local : Field : Long Prompt : Set as : "Enable My Report...?:" [Field:CMP EnableBrokerLine] Use : Logical Field Storage : EnableBroker Set as : If $$IsEmpty:$$Value then "No" else $$Value Sub Form: CMP BrokerNameReport: $$Value = "Yes" [Report: CMP BrokerNameReport] Form : CMP BrokerNameForm Object : Company [Form: CMP BrokerNameForm] Part : CMPBrokerDetails Bottom Part:smsMark86 width : 50 % Page Height: 50 % Page [Field:CMPName Field] Use : Name Field Skip : Yes Align : Center Border : Thin Bottom [Part:smsMark86] Line:smsMarkLn86 [Line:smsMarkLn86] Field:smsMarkFld86 [Field:smsMarkFld86] Use:Name Field Set as:"Visit: https://www.youtube.com" Full Width:Yes Align:Center Color:"Blue" Style:sms007 Border:Thin Bottom Read Only:Yes Skip Forward:Yes [Style:sms007] Font:"Times New Roman" Height:12 [Part:CMPBrokerDetails] Part : CMP BrokerNamePart Vertical : No Common Border : Yes [Part: CMP BrokerNamePart] Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails Repeat : CMP BrokerName LineDetails: BrokerNameList BreakOn : $$IsEmpty:$BrokerNameList Height : 10 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms Border : Thin Right [Line:CMP BrokerNamePartTit] Field : CMPName Field Local : Field : CMPName Field : Set as : "Broker Name" [Line: CMP BrokerName LineDetails] Field : CMP BrokerNameList;,CMP TransportList,CMP SalesManList;,CMP Broker CommissionField [Field: CMP BrokerNameList] Use : Name Field Storage : BrokerNameList Style : Small Bold ;=============================================================== ;======================= Add Fields =========================== ;=============================================================== [#PartBLLINE Narration] Add : Line : Before : VCH NarrPrompt : VCHBrokerLine [Line:VCHBrokerLine] Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsPurchase:##SVVoucherType Field : VCHBrokerNameTit,VCHBrokerName [Field:VCHBrokerNameTit] Use : Meduim Prompt Set as : "Broker Name :" Skip : Yes [Field:VCHBrokerName] Use : Name Field Storage : BrokerName Table : BrokerNameColl,EndofList Show Table : Always Key : CreateBroker [Key:CreateBroker] Key : Alt + C Action : Alter : CMP BrokerNameReport ;;========================================================= ;;================= Broker wise Report ================== ;;========================================================= [#Menu: Gateway of Tally] Add : Key Item : After : @@locSalesRegister : "My Purchase Report" : R : Display : BrokerReport ;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReport] Use : DSP Template Title : "Broker Report" Variable: SVFromDate, SVToDate Repeat : PartyName Form : BrokerReport Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Set : FilterBroker : "" [Form:BrokerReport] Button : PrintButton, ExportButton Button : ExplodeFlag,ChangePeriod,BtnBroker Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8 Part : SMSTitle,SMSPeriod,SMSDetails Bottom Part:smsMark88 Bottom Part :SMSTotals Width : 100% Page Space Left : 2 mms Space Right : 2 mms [Key: EnterToEdit] Key : Enter Title : $$LocaleString:"Explode" Type : BottomToolBarBtn2 Action : Explode [Part:smsMark88] Line:smsMarkLn88 [Line:smsMarkLn88] Field:smsMarkFld88 [Field:smsMarkFld88] Use:Name Field Set as:"Visit: https://www.youtube.com" Full Width:Yes Align:Center Color:"Blue" Style:sms007 Border:Thin Bottom Read Only:Yes Skip Forward:Yes [Part:SMSTitle] Line : SMSTitle Horizontal Align : Center [Part:SMSPeriod] Line : SMSPeriod [Line:SMSTitle] Field : Simple Field Local : Field : Simple Field : Style : Large Bold Local : Field : Simple Field : Info : "Purchase Report" Local : Field : Simple Field : Border: Thin Bottom Local : Field : Simple Field : Align : Center [Line:SMSPeriod] Right Field : Name Field Left Field : Short Prompt,GWLWBrokerFilter Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 50 Local : Field : Name Field : Align : Right Local : Field : Short Prompt : Set as: "Broker:" Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Field:GWLWBrokerFilter] Inactive : Not $EnableBroker:Company:##SVCurrentCompany Use : Simple Field Style : Normal Bold Set as : @VCHBrokerName Set Always : Yes VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker [Line:SMSHead] Use : SMSDetails Border : Column Titles Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Normal Bold Local : Field : SWSno : Set as : "Sno" Local : Field : SWSno : Border : Thin Left Right Local : Field : SMSPartyName : Set as : "Party Name" Local : Field : SMSPartyName : Align : Left Local : Field : SMSActulQty : Set as : "Actual Qty" Local : Field : SMSActulQty : Align : Left Local : Field : SMSBilledQty : Set as : "Billed Qty" Local : Field : SMSBilledQty : Align : Left Local : Field : SMSAmount : Set as : "Amount" Local : Field : SMSAmount : Border : Thin Left Right Space Top : 1.5 mms Space Bottom: 1.5 mms [Part:SMSDetails] Line : SMSHead,SMSDetails Repeat : SMSDetails:SMSPartyWise Scroll : Vertical Total : SMSActulQty,SMSBilledQty,SMSAmount Common Border : Yes [Line:SMSDetails] Field : SWSno,SMSPartyName Right Field : SMSActulQty,SMSBilledQty,SMSAmount Option : AlterOnEnter : $$IsVoucher Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Thin Top Explode : SMSExplode : ($$KeyExplode OR ##ExplodeFlag) [Field:SMSDefault] Use : Name Field Style : Normal Bold [Field:SWSno] Use : SMSDefault Set as : $$Line Width : 1.5 cm Align : Center Border : Thin Left Right [Field:SMSPartyName] Use : SMSDefault Set as : $PartyName Width : 60 Quick Search: Yes Space Left : 2 mms [Field:SMSActulQty] Use : Qty Field Type : Number Set as : $TotActQty;VoucherTypeName Width : 16 Space Left : 2 mms Border : Thin Left Right [Field:SMSBilledQty] Use : SMSActulQty Set as : $TotBillQty Width : 16 Space Left : 2 mms Border : Thin Right [Field:SMSAmount] Use : SMSDefault Set as : $TotAmount Type : Amount Width : @@AmountWidth Format : "No Zero, Symbol," + ##ShowForex Align : Right Key : Calculator Max : @@MaxNumberWidth Width : 16 Space Right : 2 mms Border : Thin Right Tooltip : "Amount Without TAX" [Part:SMSTotals] Line : SMSTotal [Line:SMSTotal] Border : Totals Use : SMSDetails Local : Field : Default : Type : String Local : Field : Default : Align : Right Local : Field : Default : Style : Large Bold Local : Field : Default : Border : Thin Left Local : Field : SWSno : Set as : "" Local : Field : SMSPartyName : Set as : "Grand Total" Local : Field : SMSActulQty : Set as : $$Total:SMSActulQty Local : Field : SMSBilledQty : Set as : $$Total:SMSBilledQty Local : Field : SMSAmount : Set as : $$Total:SMSAmount Local : Field : SMSAmount : Border : Thin Left Right Local : Field : SMSAmount : Align : Right [Part:SMSExplode] Line : SMSExplode Repeat : SMSExplode:SMSPartyExplode Border : Thin Bottom [Line:SMSExplode] Use : SMSDetails Delete : Border Local : Field : SWSno : Set as : "" Local : Field : Default : Style : Normal Italic Local : Field : SMSPartyName : Set as : $ItemName Local : Field : SMSPartyName : Align : Right Local : Field : SMSActulQty : Type : Quantity Local : Field : SMSActulQty : Set as : $SubActQty Local : Field : SMSBilledQty : Type : Quantity Local : Field : SMSBilledQty : Set as : $SubBillQty Local : Field : SMSAmount : Set as : $SubAmount ;=============================================================== ;======================= Add Filters =========================== ;=============================================================== [Button:BtnBroker] Key : F5 Action : Execute : BrokerReportWise Title : Report Filter Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReportWise] Form : BrokerReportWise [Form:BrokerReportWise] Part : BrokerReportWise Space Left : 2 mms Space Right : 2 mms [Part:BrokerReportWise] Line : BrokerReportWise [Line:BrokerReportWise] Field : Medium Prompt,BrokerReportWise Local : Field : Medium Prompt : Set as : "Select Broker Name:" Space Bottom : 2 mms [Field:BrokerReportWise] Table : BrokerNameColl,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterBroker Modifies : FilterBroker ;============================================================= ;================= System Functions ========================= ;============================================================= [System:UDF] EnableBroker : Logical : 4566 BrokerNameList : String : 4567 TransportList : String : 4568 SalesManList : String : 4569 BrokerName : String : 4570 TransportName : String : 4571 SalesManName : String : 4572 [System:Formula] SMSFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $SalesManName=@@SalesManWise BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport SalesManWise : If $$IsEndOfList:##FilterSalesMan or ##FilterSalesMan="" Then $SalesManName Else ##FilterSalesMan SMSExplodeFilter: $PartyName=#SMSPartyName [Collection: SMS Voucher] Type : Vouchers : VoucherType Child of : $$VchTypePurchase Belongs to : Yes Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,SalesManName Filter : NOTIsOptionalVoucher,SMSFilter [Collection:SMSPartyWise] Source Collection : SMS Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName Aggr Compute: TotActQty : Sum : $ActualQty Aggr Compute: TotBillQty: Sum : $BilledQty Aggr Compute: TotAmount : Sum : $Amount Sort : Default : $PartyName [Collection:SMSPartyExplode] Source Collection : SMS Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName By : ItemName : $StockItemName Aggr Compute: SubActQty : Sum : $ActualQty Aggr Compute: SubBillQty: Sum : $BilledQty Aggr Compute: SubAmount : Sum : $Amount Filter : SMSExplodeFilter [Collection:BrokerNameColl] Type : BrokerNameList: Company Childof : ##SVCurrentCompany Format : $BrokerNameList,25 Title : List of Brokers [Collection:TransportNameColl] Type : TransportList: Company Childof : ##SVCurrentCompany Format : $TransportList,25 Title : List of Transports [Collection:SalesManNameColl] Type : SalesManList: Company Childof : ##SVCurrentCompany Format : $SalesManList,25 Title : List of SalesMans [VariableartyNames] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterBroker] Type : String [Variable:FilterTransport] Type : String [Variable:FilterSalesMan] Type : String [System:Variables] FilterBroker : "" FilterTransport : "" FilterSalesMan : ""
[#Part: CMP TallyShopFeatures Left] -- this does not exists in PRIME, so find the appropriate PART name for Prime and replace that. For Sales and Purchase...... in [Line:VCHBrokerLine] add your condition for SALES....Purchase is already existing. This Field - [Field:CMPName Field] already exists.....So find all instances of CMPName Field and rename it.
;;------Tally Shop / Add-On------- [#Part: CMP TallyShop F11] Parts : CMP TallyShopFeatures Left Vertical : Yes Invisible : NOT ##SVTallyShop [#Part: CMP TallyShopFeatures Left] Add : Line : At End : CMP EnableBrokerLine [Line:CMP EnableBrokerLine] Space Bottom : 1.5 mms Field : Long Prompt,CMP EnableBrokerLine Local : Field : Long Prompt : Set as : "Enable My Report...?:" [Field:CMP EnableBrokerLine] Use : Logical Field Storage : EnableBroker Set as : If $$IsEmpty:$$Value then "No" else $$Value Sub Form: CMP BrokerNameReport: $$Value = "Yes" [Report: CMP BrokerNameReport] Form : CMP BrokerNameForm Object : Company [Form: CMP BrokerNameForm] Part : CMPBrokerDetails Bottom Part:smsMark86 width : 50 % Page Height: 50 % Page [Field:CMPName Field1] Use : Name Field Skip : Yes Align : Center Border : Thin Bottom [Part:smsMark86] Line:smsMarkLn86 [Line:smsMarkLn86] Field:smsMarkFld86 [Field:smsMarkFld86] Use:Name Field Set as:"Visit: https://www.youtube.com" Full Width:Yes Align:Center Color:"Blue" Style:sms007 Border:Thin Bottom Read Only:Yes Skip Forward:Yes [Style:sms007] Font:"Times New Roman" Height:12 [Part:CMPBrokerDetails] Part : CMP BrokerNamePart Vertical : No Common Border : Yes [Part: CMP BrokerNamePart] Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails Repeat : CMP BrokerName LineDetails: BrokerNameList BreakOn : $$IsEmpty:$BrokerNameList Height : 10 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms Border : Thin Right [Line:CMP BrokerNamePartTit] Field : CMPName Field1 Local : Field : CMPName Field1 : Set as : "Broker Name" [Line: CMP BrokerName LineDetails] Field : CMP BrokerNameList;,CMP TransportList,CMP SalesManList;,CMP Broker CommissionField [Field: CMP BrokerNameList] Use : Name Field Storage : BrokerNameList Style : Small Bold ;=============================================================== ;======================= Add Fields =========================== ;=============================================================== [#PartBLLINE Narration] Add : Line : Before : VCH NarrPrompt : VCHBrokerLine [Line:VCHBrokerLine] Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsPurchase:##SVVoucherType Field : VCHBrokerNameTit,VCHBrokerName [Field:VCHBrokerNameTit] Use : Meduim Prompt Set as : "Broker Name :" Skip : Yes [Field:VCHBrokerName] Use : Name Field Storage : BrokerName Table : BrokerNameColl,EndofList Show Table : Always Key : CreateBroker [Key:CreateBroker] Key : Alt + C Action : Alter : CMP BrokerNameReport ;;========================================================= ;;================= Broker wise Report ================== ;;========================================================= [#Menu: Gateway of Tally] Add : Key Item : After : @@locSalesRegister : "My Purchase Report" : R : Display : BrokerReport ;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReport] Use : DSP Template Title : "Broker Report" Variable: SVFromDate, SVToDate Repeat : PartyName Form : BrokerReport Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Set : FilterBroker : "" [Form:BrokerReport] Button : PrintButton, ExportButton Button : ExplodeFlag,ChangePeriod,BtnBroker Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8 Part : SMSTitle,SMSPeriod,SMSDetails Bottom Part:smsMark88 Bottom Part :SMSTotals Width : 100% Page Space Left : 2 mms Space Right : 2 mms [Key: EnterToEdit] Key : Enter Title : $$LocaleString:"Explode" Type : BottomToolBarBtn2 Action : Explode [Part:smsMark88] Line:smsMarkLn88 [Line:smsMarkLn88] Field:smsMarkFld88 [Field:smsMarkFld88] Use:Name Field Set as:"Visit: https://www.youtube.com" Full Width:Yes Align:Center Color:"Blue" Style:sms007 Border:Thin Bottom Read Only:Yes Skip Forward:Yes [Part:SMSTitle] Line : SMSTitle Horizontal Align : Center [Part:SMSPeriod] Line : SMSPeriod [Line:SMSTitle] Field : Simple Field Local : Field : Simple Field : Style : Large Bold Local : Field : Simple Field : Info : "Purchase Report" Local : Field : Simple Field : Border: Thin Bottom Local : Field : Simple Field : Align : Center [Line:SMSPeriod] Right Field : Name Field Left Field : Short Prompt,GWLWBrokerFilter Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 50 Local : Field : Name Field : Align : Right Local : Field : Short Prompt : Set as: "Broker:" Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Field:GWLWBrokerFilter] Inactive : Not $EnableBroker:Company:##SVCurrentCompany Use : Simple Field Style : Normal Bold Set as : @VCHBrokerName Set Always : Yes VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker [Line:SMSHead] Use : SMSDetails Border : Column Titles Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Normal Bold Local : Field : SWSno : Set as : "Sno" Local : Field : SWSno : Border : Thin Left Right Local : Field : SMSPartyName : Set as : "Party Name" Local : Field : SMSPartyName : Align : Left Local : Field : SMSActulQty : Set as : "Actual Qty" Local : Field : SMSActulQty : Align : Left Local : Field : SMSBilledQty : Set as : "Billed Qty" Local : Field : SMSBilledQty : Align : Left Local : Field : SMSAmount : Set as : "Amount" Local : Field : SMSAmount : Border : Thin Left Right Space Top : 1.5 mms Space Bottom: 1.5 mms [Part:SMSDetails] Line : SMSHead,SMSDetails Repeat : SMSDetails:SMSPartyWise Scroll : Vertical Total : SMSActulQty,SMSBilledQty,SMSAmount Common Border : Yes [Line:SMSDetails] Field : SWSno,SMSPartyName Right Field : SMSActulQty,SMSBilledQty,SMSAmount Option : AlterOnEnter : $$IsVoucher Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Thin Top Explode : SMSExplode : ($$KeyExplode OR ##ExplodeFlag) [Field:SMSDefault] Use : Name Field Style : Normal Bold [Field:SWSno] Use : SMSDefault Set as : $$Line Width : 1.5 cm Align : Center Border : Thin Left Right [Field:SMSPartyName] Use : SMSDefault Set as : $PartyName Width : 60 Quick Search: Yes Space Left : 2 mms [Field:SMSActulQty] Use : Qty Field Type : Number Set as : $TotActQty;VoucherTypeName Width : 16 Space Left : 2 mms Border : Thin Left Right [Field:SMSBilledQty] Use : SMSActulQty Set as : $TotBillQty Width : 16 Space Left : 2 mms Border : Thin Right [Field:SMSAmount] Use : SMSDefault Set as : $TotAmount Type : Amount Width : @@AmountWidth Format : "No Zero, Symbol," + ##ShowForex Align : Right Key : Calculator Max : @@MaxNumberWidth Width : 16 Space Right : 2 mms Border : Thin Right Tooltip : "Amount Without TAX" [Part:SMSTotals] Line : SMSTotal [Line:SMSTotal] Border : Totals Use : SMSDetails Local : Field : Default : Type : String Local : Field : Default : Align : Right Local : Field : Default : Style : Large Bold Local : Field : Default : Border : Thin Left Local : Field : SWSno : Set as : "" Local : Field : SMSPartyName : Set as : "Grand Total" Local : Field : SMSActulQty : Set as : $$Total:SMSActulQty Local : Field : SMSBilledQty : Set as : $$Total:SMSBilledQty Local : Field : SMSAmount : Set as : $$Total:SMSAmount Local : Field : SMSAmount : Border : Thin Left Right Local : Field : SMSAmount : Align : Right [Part:SMSExplode] Line : SMSExplode Repeat : SMSExplode:SMSPartyExplode Border : Thin Bottom [Line:SMSExplode] Use : SMSDetails Delete : Border Local : Field : SWSno : Set as : "" Local : Field : Default : Style : Normal Italic Local : Field : SMSPartyName : Set as : $ItemName Local : Field : SMSPartyName : Align : Right Local : Field : SMSActulQty : Type : Quantity Local : Field : SMSActulQty : Set as : $SubActQty Local : Field : SMSBilledQty : Type : Quantity Local : Field : SMSBilledQty : Set as : $SubBillQty Local : Field : SMSAmount : Set as : $SubAmount ;=============================================================== ;======================= Add Filters =========================== ;=============================================================== [Button:BtnBroker] Key : F5 Action : Execute : BrokerReportWise Title : Report Filter Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReportWise] Form : BrokerReportWise [Form:BrokerReportWise] Part : BrokerReportWise Space Left : 2 mms Space Right : 2 mms [Part:BrokerReportWise] Line : BrokerReportWise [Line:BrokerReportWise] Field : Medium Prompt,BrokerReportWise Local : Field : Medium Prompt : Set as : "Select Broker Name:" Space Bottom : 2 mms [Field:BrokerReportWise] Table : BrokerNameColl,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterBroker Modifies : FilterBroker ;============================================================= ;================= System Functions ========================= ;============================================================= [System:UDF] EnableBroker : Logical : 4566 BrokerNameList : String : 4567 TransportList : String : 4568 SalesManList : String : 4569 BrokerName : String : 4570 TransportName : String : 4571 SalesManName : String : 4572 [System:Formula] SMSFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $SalesManName=@@SalesManWise BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport SalesManWise : If $$IsEndOfList:##FilterSalesMan or ##FilterSalesMan="" Then $SalesManName Else ##FilterSalesMan SMSExplodeFilter: $PartyName=#SMSPartyName [Collection: SMS Voucher] Type : Vouchers : VoucherType Child of : $$VchTypePurchase Belongs to : Yes Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,SalesManName Filter : NOTIsOptionalVoucher,SMSFilter [Collection:SMSPartyWise] Source Collection : SMS Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName Aggr Compute: TotActQty : Sum : $ActualQty Aggr Compute: TotBillQty: Sum : $BilledQty Aggr Compute: TotAmount : Sum : $Amount Sort : Default : $PartyName [Collection:SMSPartyExplode] Source Collection : SMS Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName By : ItemName : $StockItemName Aggr Compute: SubActQty : Sum : $ActualQty Aggr Compute: SubBillQty: Sum : $BilledQty Aggr Compute: SubAmount : Sum : $Amount Filter : SMSExplodeFilter [Collection:BrokerNameColl] Type : BrokerNameList: Company Childof : ##SVCurrentCompany Format : $BrokerNameList,25 Title : List of Brokers [Collection:TransportNameColl] Type : TransportList: Company Childof : ##SVCurrentCompany Format : $TransportList,25 Title : List of Transports [Collection:SalesManNameColl] Type : SalesManList: Company Childof : ##SVCurrentCompany Format : $SalesManList,25 Title : List of SalesMans [VariableartyNames] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterBroker] Type : String [Variable:FilterTransport] Type : String [Variable:FilterSalesMan] Type : String [System:Variables] FilterBroker : "" FilterTransport : "" FilterSalesMan : ""