Supports Export of selected Master Groups, and sub groups: Ultimate aim of this TDL is to support export of All types masters for Selected group.. without disturbing tally default reports. Accounts Groups Stock Item Groups Only XML is supported as yet Code: [#Menu : Display Menu] Add : Key Item : After : @@locListofAccounts : "Selected List of Accounts" : L : Display : Selected List of Accounts : NOT $$IsEmpty:$$SelectedCmps ;------------------------------------------------------------------------------------------------------------------ [System : Variables ] SelectedMaster : "" [Variable : SelectedMaster] Type : String Persistent : No [System : Formulae] SelectedMasterFilter : $Name = ##SelectedMaster ;---------------------------------------------------------------------------------------------------------------------- [Report: Selected List of Accounts] Title : $$LocaleString:"Selected List of Accounts" Variables : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod, IsItemWise Variables : SelectedMaster, AccountType, GroupName, CostCategoryName, CostCentreName, DSPGodownName, StockGroupName, StockCategoryName Variable : DSPShowMonthly, DSPNotScaleable, IMPClAsOp, DSPCursorPosition Variable : Serial Number, STariffclassification, ShowUnusedMasters Filtered : Yes Set : AccountType : if $$IsEmpty:##AccountType then $$SysName:Ledgers else ##AccountType Set : DSPNotScaleable : Yes Set : SVFromDate : $BooksFrom:Company:##SVCurrentCompany Set : SVToDate : "" PrintSet : ReportTitle : $$SPrintf:@@ListOfAccTypeFormat:##AccountType:@@UnusedMaster PrintSet : ReportSubTitle : "" Set : IMPClAsOp : No Print : Selected Acct List Print Config Export : Yes PrintSet : PrintFileName : "Master" [Form: Selected List of Accounts] Use : List of Accounts Delete : Parts: AccType Title, AccType Body Add : Parts: AccType Title, Sel AccType Body [Part :Sel AccType Body] Scroll : Vertical Option : REPAcc Body : NOT ##SVExport OR ($$IsSysNameEqual:HTML:##SVExportFormat OR $$IsSysNameEqual:AnsiHTML:##SVExportFormat OR $$IsSysNameEqual:ASCII:##SVExportFormat OR $$IsSysNameEqual:AnsiASCII:##SVExportFormat OR $$IsSysNameEqual:Excel:##SVExportFormat OR $$IsSysNameEqual:AnsiExcel:##SVExportFormat) Option : SELAcc Body : ##SVExport AND ($$IsSysNameEqual:SDF:##SVExportFormat) OR ($$IsSysNameEqual:AnsiSDF:##SVExportFormat) Option : SELSoapEnvelopeOpt: ##SVExport AND (($$IsSysNameEqual:XML:##SVExportFormat) OR ($$IsSysNameEqual:AnsiXML:##SVExportFormat)) [!Part :SELSoapEnvelopeOpt] Use : SELSoapEnvelope [!Part: SELSoapEnvelope] Parts : EXPSoapHeader, SELSoapBody Vertical : Yes Delete : Scroll [Part: SELSoapBody] Switch : SVMSGVersion0 : SELSoapBody0 : ##SVMSGVersion = "0" Switch : SVMSGVersion1 : SELSoapBody1 : ##SVMSGVersion != "0" XMLTag : "BODY" Vertical: Yes [!Part: SELSoapBody0] Part : SELSoapRequest [!Part: SELSoapBody1] Part : EXPSoapReqDesc, SELSoapReqData Local : Part : EXPSoapReqDesc : XMLTag : "DESC" Local : Part : EXPSoapReqDesc : Delete : Line : EXPSoapReportName Local : Part : EXPSoapReqData : XMLTag : "DATA" [Part: SELSoapRequest] XMLTag : "IMPORTDATA" Parts : EXPSoapReqDesc, SELSoapReqData Vertical: Yes [Part: SELSoapReqData] XMLTag : "REQUESTDATA" Part : SELSoapDataBody ;, SVSRemCmpMsgs Option : SVSRemCmpMsg : $$IsSysNameEqual:XML:##SVExportFormat AND $$CollNumTotal:STATVchType:$MigVal > 0 AND $$NumItems:RemoteCmpStateInfo > 0 Local : Part : SVSRemCmpMsgs : Local : Part : SVSRemCmpInfo : Delete : XMLAttr [Part: SELSoapDataBody] Use : SELAccBody Scroll : Vertical [!Part: SELAcc Body] Lines : EXPORT Master ;; Local : Field : EV Value : Type : String Option : SEL AllMasters : $$IsSysNameEqual:AllMasters:#AccountType Option : SEL AccMasters : $$IsSysNameEqual:AllAcctMasters:#AccountType Option : SEL InvMasters : $$IsSysNameEqual:AllInvMasters:#AccountType Option : SEL StatMasters : $$IsSysNameEqual:AllStatMasters:#AccountType Option : SEL Groups : $$IsSysNameEqual:Groups:#AccountType Option : SEL Ledgers : $$IsSysNameEqual:Ledgers:#AccountType Option : SEL PayHeads : $$IsSysNameEqual:PayHeads:#AccountType Option : SEL CostCategories : $$IsSysNameEqual:CostCategories:#AccountType Option : SEL CostCentres : $$IsSysNameEqual:CostCentres:#AccountType Option : SEL EmployeeGroups : $$IsSysNameEqual:EmployeeGroups:#AccountType Option : SEL Employees : $$IsSysNameEqual:Employees:#AccountType Option : SEL Godowns : $$IsSysNameEqual:Godowns:#AccountType OR $$IsSysNameEqual:Locations:#AccountType Option : SEL StockGroups : $$IsSysNameEqual:StockGroups:#AccountType Option : SEL StockCategories: $$IsSysNameEqual:StockCategories:#AccountType Option : SEL StockItems : $$IsSysNameEqual:StockItems:#AccountType Option : SEL Currencies : $$IsSysNameEqual:Currencies:#AccountType Option : SEL Units : $$IsSysNameEqual:Units:#AccountType Option : SEL VoucherTypes : $$IsSysNameEqual:VoucherTypes:#AccountType Option : SEL Attd Types : $$IsSysNameEqual:AttendanceTypes:#AccountType Option : SEL Budgets Scenario: $$IsSysNameEqual:BudgetScenarios:#AccountType Option : SEL SerialNumbers : $$IsSysNameEqual:SerialNumbers:#AccountType Option : SEL TariffClassifications : $$IsSysNameEqual:TariffClassifications:#AccountType Option : SEL GSTClassifications : $$IsSysNameEqual:GSTClassifications:#AccountType [!Part: SEL All Masters] Repeat : EXPORT Master : EAT AllMasters [!Part: SEL Acc Masters] Repeat : EXPORT Master : EAT AccMasters [!Part: SEL Inv Masters] Repeat : EXPORT Master : EAT InvMasters [!Part: SEL StatMasters] Repeat : EXPORT Master : EAT Statutory Masters [!Part: SEL Groups] Repeat : EXPORT Master : EAT Groups Local : Collection: EAT Groups : Delete: Child Of Local : Collection: EAT Groups : Add : Child Of : ##SelectedMaster Local : Collection: EAT Groups : Add :Collection : EAT Currency Local : Collection: EAT Groups : Add :Collection : EAT DirLedgers Local : Collection: EAT DirLedgers: Delete: Child Of: Local : Collection: EAT DirLedgers : Add: Child Of : ##SelectedMaster [!Part: SEL Ledgers] Repeat : EXPORT Master : EAT Ledgers [!Part: SEL PayHeads] Repeat : EXPORT Master : EAT PayHeads [!Part: SEL Cost Categories] Repeat : EXPORT Master : EAT Cost Categories Local : Collection: EAT Cost Categories : Delete: Child Of Local : Collection: EAT Cost Categories : Add: Child Of : ##SelectedMaster [!Part: SEL Cost Centres] Repeat : EXPORT Master : EAT Cost Centres [!Part: SEL EmployeeGroups] Repeat : EXPORT Master : EAT Employee Groups [!Part: SEL Employees] Repeat : EXPORT Master : EAT Employees [!Part: SEL Godowns] Repeat : EXPORT Master : EAT Godowns [!Part: SEL Stock Groups] Repeat : EXPORT Master : EAT Stock Groups Local : Collection: EAT Stock Groups : Delete: Child Of Local : Collection: EAT Stock Groups : Add : Child Of : ##SelectedMaster Local : Collection: EAT Stock Groups : Add :Collection : EAT TariffClassifications Local : Collection: EAT Stock Groups : Add :Collection : EAT GSTClassifications Local : Collection: EAT Stock Groups : Add :Collection : EAT SerialNumbers Local : Collection: EAT Stock Groups : Add :Collection : EAT Godowns Local : Collection: EAT Stock Groups : Add :Collection : EAT Stock Categories Local : Collection: EAT Stock Groups : Add :Collection : EAT Unit Local : Collection: EAT Stock Groups : Add :Collection : EAT Currency Local : Collection: EAT Stock Groups : Add :Collection : EAT Dir Stock Items Local : Collection: EAT Stock Groups : Sort : @@Default : $Priority, -$BaseLangIsSimpleUnit, $$Type, $Depth, $Name Local : Collection: EAT Dir Stock Items : Delete: Child Of Local : Collection: EAT Dir Stock Items : Add: Child Of : ##SelectedMaster [!Part: SEL Stock Categories] Repeat : EXPORT Master : EAT Stock Categories [!Part: SEL TariffClassifications] Repeat : EXPORT Master : EAT TariffClassifications [!Part: SEL GSTClassifications] Repeat : EXPORT Master : EAT GSTClassifications [!Part: SEL Stock Items] Repeat : EXPORT Master : EAT StockItems [!Part: SEL Currencies] Repeat : EXPORT Master : EAT Currency [!Part: SEL Units] Repeat : EXPORT Master : EAT Unit [!Part: SEL SerialNumbers] Repeat : EXPORT Master : EAT SerialNumbers [!Part: SEL Voucher Types] Repeat : EXPORT Master : EAT Voucher Type [!Part: SEL Attd Types] Repeat : EXPORT Master :EAT Attd Type [!Part: SEL Budgets Scenario] Repeat : EXPORT Master : EAT Budgets And Scenarios ;------------------------------------------------------------------------------------------------------------------------ [Report :Selected Acct List Print Config] Use : SV Print Configuration Form : Selected Acct List Print Config [Form: Selected Acct List Print Config] Use : SV Print Configuration Add : Parts : Selected AccList Print Common Local : Field : Form SubTitle : Set as : $$SPrintf:@@OutputActionFormat:@@OutputAction:#ReportTitle Local : Field : AccountType : Modifies: AccountType Local : Field : SelectedMaster : Modifies: SelectedMaster [Part: Selected AccList Print Common] SpaceTop : 1 Lines : AccountType, SelectedMaster, IncludeDependentMaster, IMPClAsOp, IMPSVToDate, IMPClExpl HorizontalAlign : Centre [Line: SelectedMaster] Fields : Medium Prompt, SelectedMaster Local : Field : Medium Prompt : Info : $$LocaleString:"Selected Master " Local : Field : Medium Prompt : Width : @@LongWidth [Field: SelectedMaster] Use : Short Name Field Set as : ##SelectedMaster Modifies : SelectedMaster Skip : NOT ($$IsSysNameEqual:Groups:#AccountType OR $$IsSysNameEqual:StockGroups:#AccountType) Set By Condition : NOT ($$IsSysNameEqual:Groups:#AccountType OR $$IsSysNameEqual:StockGroups:#AccountType): "" Table : List of Groups : $$IsSysNameEqual:Groups:#AccountType Table : List of StockGroups : $$IsSysNameEqual:StockGroups:#AccountType ShowTable : Always ;-------------------------------------------------------------------------------------------------------------- [Table : Selected All Masters] Title : $$LocaleString:"All Masters" List Name : $$SysName:AllMasters /* ;------------------------------------------------------------------------------------------------------------------------- [Collection: List of Employees] Type : Cost Centre Fetch : Name, ForPayroll, IsEmployeeGroup, MasterId, CanDelete Compute : Alias : $$Alias Compute : NumChildren : $$NumChildren Filter : BelongsToCstCatName Filter : EmployeesFilter Sort : @@Default : $$Name [Collection: List of EmployeeGroups] Type : Cost Centre Fetch : Name, ForPayroll, IsEmployeeGroup, MasterId, CanDelete Compute : Alias : $$Alias Compute : NumChildren : $$NumChildren Filter : EmployeesFilter Filter : EmployeeGroupFilter Filter : BelongsToCstCatName Sort : @@Default : $$Name [Collection: List of AttdType] Type : AttendanceType Fetch : Name, MasterId, CanDelete Compute : Alias : $$Alias Compute : NumChildren : $$NumChildren Sort : @@Default : $$Name [Collection: List of Budgets Scenario] Type : Budget Fetch : Name, IsScenario, MasterId, CanDelete Compute : Alias : $$Alias Compute : NumChildren : $$NumChildren Compute : BudgetType : $BudgetType Sort : @@Default : $BudgetType, $$Name Format : BudgetType, 25 Filter : BudgetScenarioFilter ;----------------------------------------------------------------------------------------------------- [Field: SelectedMaster] Use : Short Name Field Set as : ##SelectedMaster Modifies : SelectedMaster Skip : NOT ($$IsSysNameEqual:Groups:#AccountType OR $$IsSysNameEqual:StockGroups:#AccountType) Set By Condition : NOT ($$IsSysNameEqual:Groups:#AccountType OR $$IsSysNameEqual:StockGroups:#AccountType): "" Table : Selected All Masters, List of Groups : $$IsSysNameEqual:Groups:#AccountType Table : Selected All Masters, List of StockGroups : $$IsSysNameEqual:StockGroups:#AccountType ;Table : Selected All Masters, List of Ledgers : $$IsSysNameEqual:Ledgers:#AccountType ;Table : Selected All Masters, List of PayHeads : $$IsSysNameEqual:PayHeads:#AccountType ;Table : Selected All Masters, List of CostCategories : ($$IsSysNameEqual:CostCategories:#AccountType) OR ($$IsSysNameEqual:CostCentres:#AccountType AND $$ExplodeLevel = 0) OR + ; ($$IsSysNameEqual:Employees:#AccountType AND $$ExplodeLevel = 0) OR ($$IsSysNameEqual:EmployeeGroups:#AccountType AND $$ExplodeLevel = 0) ;Table : Selected All Masters, List of CostCentres : $$IsSysNameEqual:CostCentres:#AccountType AND $$ExplodeLevel > 0 ;Table : Selected All Masters, List of Employees : $$IsSysNameEqual:Employees:#AccountType AND $$ExplodeLevel > 0 ;Table : Selected All Masters, List of EmployeeGroups : $$IsSysNameEqual:EmployeeGroups:#AccountType AND $$ExplodeLevel > 0 ;Table : Selected All Masters, List of Budgets Scenario: $$IsSysNameEqual:BudgetScenarios:#AccountType ;Table : Selected All Masters, List of Godowns : $$IsSysNameEqual:Godowns:#AccountType OR $$IsSysNameEqual:Locations:#AccountType ;Table : Selected All Masters, List of StockCategories: $$IsSysNameEqual:StockCategories:#AccountType ;Table : Selected All Masters, List of StockItems : $$IsSysNameEqual:StockItems:#AccountType ;Table : Selected All Masters, RemoteCurrency : $$IsSysNameEqual:Currencies:#AccountType ;Table : Selected All Masters, Units : $$IsSysNameEqual:Units:#AccountType ;Table : Selected All Masters, Serial Number : $$IsSysNameEqual:SerialNumbers:#AccountType ;Table : Selected All Masters, List of VoucherTypes : $$IsSysNameEqual:VoucherTypes:#AccountType ;Table : Selected All Masters, List of Attd Types : $$IsSysNameEqual:AttendanceTypes:#AccountType ;Table : Selected All Masters, TariffClassifications : $$IsSysNameEqual:TariffClassifications:#AccountType ;Table : Selected All Masters, GSTClassifications : $$IsSysNameEqual:GSTClassifications:#AccountType ShowTable : Always