Amount Calculation Issue on Auto Column Report.

Discussion in 'Requests' started by zakirhossain_diu, Sep 28, 2019.

    

  1. Dear experts and Admins,
    I am using following collections to get Ledger wise Memo voucher total & sales VooucherTotal. While I am giving manual and single Month its getting perfect, But Problem is while selecting Auto Column itsjust showing Value of First months to all months.
    will you please tell me where i am missing??

    Thank You

    [Collection: AmmountVarianceVoucherColl]
    Type: Vouchers:VoucherType
    Child Of:$$VchTypeMemo
    Belongs To: Yes
    Fetch: LedgerName, Amount

    [Collection: AmmountVarianceSalesVoucherColl]
    Type: Vouchers:VoucherType
    Child Of: $$vchtypeSales
    Belongs To: Yes
    Fetch: LedgerName, Amount

    [Collection: SalesandMemovchColl]
    Collections:AmmountVarianceVoucherColl, AmmountVarianceSalesVoucherColl


    [Collection: LedgersBudgetColl]
    Source Collection:SalesandMemovchColl
    Walk: LedgerEntries
    By: Ledgername:$Ledgername
    Aggr Compute:SAmount:Sum:if @@SalesVr then $Amount else 0
    Aggr Compute:MAmount:Sum:if @@MemoVr then $Amount else 0

    [System: Formulae]
    MemoVr : $$IsMemo:$VoucherTypeName
    SalesVr : $$IsSales:$VoucherTypeName



    upload_2019-9-28_0-42-19.png
     


Share This Page