Help me on group voucher reports

Discussion in 'Free Source Codes' started by SANTOSH SHRESTHA, Feb 3, 2020.

    

  1. [#Line: DSP GrpVchExpl]
    Explode:santa:##ExplodeFlag OR $$KeyExplode
    [Part:santa]
    Line:santa1
    Repeat:santa1:itemscoll


    [Line:santa1]
    Remove on: #PoPONo!=$$ExplodeOwner:#PoPONo
    Field:name field, Qty field,Rate field,Amount field
    Local:Field:Name field:Set as:$StockItemName
    Local:Field:Qty field:Set as:$BilledQty
    Local:Field:Rate field:Set as:$Rate
    Local:Field:Amount field:Set as:$Amount

    ;Invisible: $$IsFirstObj

    [Collection:mystkcoll]
    Type:Vouchers:VoucherType
    Child Of:$$VchTypeSales
    Belongs To : Yes
    Fetch :LedgerEntries.Amount,PARTYLEDGERNAME,COSTCENTRENAME,VOUCHERNUMBER, Date, Name, Parent, ClosingBalance, Rate, OpeningValue, ClosingValue, PendingValue, TrackLedger, OpeningBalance, BatchName, GodownName, DiscountFetch:*,InventoryEntries.,*;,InventoryEntries.
    ;Filter:myfilter
    [Collection:itemscoll]
    Source Collection:mystkcoll
    Walk:AllLedgerEntries,InventoryAllocations
    By:VoucherNumber:$VoucherNumber
    ; By:LedgerName:$LedgerName
    By:StockItemName:$StockItemName
    Compute:stkqty:$billedQty
    Compute:Rate:$Rate
    Compute:Amount:$Amount
    ;Filter:paBB

    [Field : Po PONo]
    Use : Short Name Field
    Set as : $VoucherNumber ;;$VOUCHERNUMBER
    Style : Normal
    Width : 10 % Screen

    [System:formula]
    myfilter: $LedgerName = ##SVLedgerName
    PaBB : $Name =$LedgerName;#DSPVchExplAccount
     

    Attached Files:

    • dd.png
      dd.png
      File size:
      32.5 KB
      Views:
      66


Share This Page