Help in MultiCompany Cost Centre Vouchers Collection

Discussion in 'Free Source Codes' started by kapil22, Jun 6, 2021.

    
  1. kapil22

    kapil22 Member


    Dear Experts,
    i fetch the multi company Cost Centre voucher value shown in list.
    problems:
    1. voucher list not sort as per date.
    2. CostCentre summary value calculate only loaded company which is Blue Color.
    3. voucher report generate time is high can it be short.

    my first data line collection is cost centre.
    and second data line collection is voucher.

    annexing image & code for your kind reference:

    upload_2021-6-6_13-48-9.png

    Code:
    [Collection:     K011CCVoucherLoopColl]
    Collection:     K011LCCollection:     K011CompanyColl
    Sort:         Default:             $Date
    [Collection:     K011VchOfCostCentre]
    Type:         Vouchers
    Child Of:     $Name
    Fetch:         MasterID, Date, LedgerName, VoucherTypeName, VoucherNumber, Amount,
    Sort:         Default:             $Date
    [Collection:     K011LCCollection]
    Source Collection    :     K011VchOfCostCentre
    Walk         :     AllLedgerEntries, CostCentreAllocations
    By                   :     MasterID              :     $MasterID
    By             :     LedgerName        :    $LedgerName    
    By             :     CostCentreName    :    $Name:CostCentre:$Name
    by            :    Amount            :    $Amount
    Compute           :     Date                      : $Date
    Compute           :     VoucherTypeName    : $VoucherTypeName
    Compute           :     VoucherNumber     : $VoucherNumber
    Compute           :     Narration             : $().Narration
    compute        :    LedNarration        : $CostCentreAllocations.Narration
    Compute        :     CCName            : $Name:CostCentre:$Name
    AGGRCompute:    VchCCAmt        : SUM:    $Amount
    Sort                :     Default            : $Date
    Compute        :     CPName            : $$LoopCollObj:$Name
    searchkey    :    $CostCentreName
    [Collection:    K011CompanyColl]
    type:        Company
    Fetch:        Name
    
    [system: formula]
    CCASearchKey:    $CostCentreName
    CCAAmt:        $$ReportObject:$$CollectionFieldByKey:$VchCCAmt:@@CCASearchKey:K011LCCollection
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Sort : @@Default : $Date
     


  3. kapil22

    kapil22 Member


    not works
     


  4. kapil22

    kapil22 Member


    Sir,

    Sort: @@Default: $$Date:$Date

    this code works
     


Share This Page