Selected Master Groups Export

Discussion in 'Free Source Codes' started by Devendra_Rawat, Aug 1, 2019.

    
  1. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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
                
     
    Last edited: Aug 1, 2019
    panam and Frz like this.


  2. anish

    anish Member


    Thank You So much !
     


Share This Page