How to use 'Group By' to filter excel rows based on the invoice no.?

Discussion in 'Tally Developer' started by karthik loganadin, Jul 8, 2019.

    
  1. karthik loganadin

    karthik loganadin New Member


    Dear all,

    I am in the middle of importing Invoice details from Excel. By using Collection object i fetched all the records in master Collection. Now i want to group those master records based on the Invoice no.

    Please advice me what i should use? Group by or filter?.
    Please share that bit of code for the following Source object

    Master collection

    [Object: Mater Sales Object]

    InvNo : $_2
    InvDt : $_3
    PartyName : $_4
    State : $_5
    HSNCode : $_6
    Rate : $_7
    Qty : $_8
    GST % : $_9
    Amount : $_10
    Tax Amount : $_11
    Total:$_12


    And for each distinct Invoice no in the master collection, i want the following child collection

    [Object: Child Sales Object]

    InvNo : $_2
    InvDt : $_3
    Rate : $_7
    Qty : $_8
    GST % : $_9
    Amount : $_10
    Tax Amount : $_11
    Total:$_12



    Please elp

    Regards
    Karthik
     


Share This Page