1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Help with this code Change sales to Purchase

Discussion in 'Tally Developer' started by HAROON2015, Sep 17, 2019.

    
  1. HAROON2015

    HAROON2015 Member


    hi,
    i am using this code for showing all sale stock item in one report
    but i want to change this code to show purchased stock items
    Code:
    [#Menu : Gateway of Tally]
    Item : MyAutoColumnReport : Display : MyColReport
    [Report : MyColReport]
        Form     : MyColReport
        Variable: DosetAutoColumn,DspRepeatCollection,MyVariable,SVFromDate,SVToDate
        Set     : DosetAutoColumn : yes
        Repeat     : MyVariable
        Set     : DspRepeatCollection : MyStockitemCollection
        Set     : SVFromDate : $Booksfrom:Company:##SVCurrentCompany
        Set     : SVToDate : $$Monthstart:##SVCurrentDate
        [Form :MyColReport]
            Part :MyColReport,MyColReportBody
            Bottom Part : MyColReportBodyBTM
            Option : Set Auto Option : $$SetAutoColumns:MyVariable
            [Part :MyColReport]
                Line :MyColReport
                Border : Column Titles
                [Line :MyColReport]
                    Field : MyColReport,MyColSalesQty
                    Repeat : MyColSalesQty
                    Local : Field : MyColSalesQty : Align : Center
                    [Field :MyColReport]
                        Use : Name Field
                        Set As : "Particulars"
                    [Field :MyColSalesQty]
                        Use : Name Field
                        Set As : ##MyVariable
                        Border : Thin Left
    [Part : MyColReportBody]
        Line : MyColReportBody
        Repeat : MyColReportBody : MyCustomers
        Scroll : Vertical
        Total : MyColSalesQty
        Common Border : yes
        [Line :MyColReportBody]
            Field : MyColReport,MyColSalesQty
            Repeat : MyColSalesQty
            Local : Field : MyColReport : Set As : $Name
            Local : Field : MyColSalesQty : Type : Quantity
            Local : Field : MyColSalesQty : Align : Right
            Local : Field : MyColSalesQty : Set AS  : $$LedSaleQty:$Name:##MyVariable
   [Part : MyColReportBodyBTM]
    Use : MyColReport
    Local : Field : MyColReport  : Set As : $$Total:MyColReport
    Local : Field : MyColSalesQty: Set As : $$Total:MyColSalesQty
    Local : Line :MyColReport : Local : Field : MyColSalesQty : Align : Right
[Collection  : MyStockitemCollection]
    Type : Stock Items
    Compute : MyVariable : $Name
[Variable : MyVariable]
    Repeat : ##DspRepeatCollection
[Collection : MyCustomers]
    Type : Ledger
    Child of : $$GroupSundryDebtorS
     
    Last edited: Sep 17, 2019
    HAROON2015, Sep 17, 2019
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Simply change your collection parameters.....
     
    Amit Kamdar, Sep 18, 2019
    #2


  3. HAROON2015

    HAROON2015 Member


    done,
    thank you sir
    Code:
    [#Menu : Gateway of Tally]
    Item : MyAutoColumnReport : Display : MyColReport
    [Report : MyColReport]
        Form     : MyColReport
        Variable: DosetAutoColumn,DspRepeatCollection,MyVariable,SVFromDate,SVToDate
        Set     : DosetAutoColumn : yes
        Repeat     : MyVariable
        Set     : DspRepeatCollection : MyStockitemCollection
        Set     : SVFromDate : $Booksfrom:Company:##SVCurrentCompany
        Set     : SVToDate : $$Monthstart:##SVCurrentDate
        [Form :MyColReport]
            Part :MyColReport,MyColReportBody
            Bottom Part : MyColReportBodyBTM
            Option : Set Auto Option : $$SetAutoColumns:MyVariable
            [Part :MyColReport]
                Line :MyColReport
                Border : Column Titles
                [Line :MyColReport]
                    Field : MyColReport,MyColSalesQty
                    Repeat : MyColSalesQty
                    Local : Field : MyColSalesQty : Align : Center
                    [Field :MyColReport]
                        Use : Name Field
                        Set As : "Particulars"
                    [Field :MyColSalesQty]
                        Use : Name Field
                        Set As : ##MyVariable
                        Border : Thin Left
    [Part : MyColReportBody]
        Line : MyColReportBody
        Repeat : MyColReportBody : MyCustomers
        Scroll : Vertical
        Total : MyColSalesQty
        Common Border : yes
        [Line :MyColReportBody]
            Field : MyColReport,MyColSalesQty
            Repeat : MyColSalesQty
            Local : Field : MyColReport : Set As : $Name
            Local : Field : MyColSalesQty : Type : Quantity
            Local : Field : MyColSalesQty : Align : Right
            Local : Field : MyColSalesQty : Set AS  : $$LedPurcQty:$Name:##MyVariable
   [Part : MyColReportBodyBTM]
    Use : MyColReport
    Local : Field : MyColReport  : Set As : $$Total:MyColReport
    Local : Field : MyColSalesQty: Set As : $$Total:MyColSalesQty
    Local : Line :MyColReport : Local : Field : MyColSalesQty : Align : Right
[Collection  : MyStockitemCollection]
    Type : Stock Items
    Compute : MyVariable : $Name
[Variable : MyVariable]
    Repeat : ##DspRepeatCollection
[Collection : MyCustomers]
    Type : Ledger
    Child of : $$GroupSundryCreditors
     
    HAROON2015, Sep 18, 2019
    #3


Share This Page