How i get Party Ledger wise Openning & Closing Quantity

Discussion in 'Tally Developer' started by suyash, Feb 21, 2022.

    
Tags:
  1. suyash

    suyash New Member


    Hii Experts plz help me for how to get Party wise Openning & Closing Quantity summary
     


  2. kosi

    kosi Member


    Where is your codes. Write your codes and send it here. We will go through and correct errors for u
     


  3. suyash

    suyash New Member


    [Collection: StkVchGdwnBatchOPBal1]
    Source Collection : StkVchStockItems1
    By : StockItemName : $$Owner:$Name
    By : LedgerName : $$Owner:##LedgerName
    Aggr Compute : OpeningBalance : Sum : $OpeningBalance
    Search Key : $StockItemName + ##LedgerName

    [Collection: StkVchStockItems1]
    Type: Stock Item

    [Field: CmpPartyOpBl]
    Use : Number Field
    Set as : $$ReportObject:$$CollectionFieldByKey:$OpeningBalance:#CMPartyBillNo:StkVchGdwnBatchOPBal1;$$IsOpeningBal:mad:@ReqObjNames:$Name;$$CollQtyTotal:OpBlSalesColl:$Opbal;:1:isopeparty ;$$FromValue:OpeningBalance:Ledger:##LedgerName;@bbb;@my2;if ($$IsEmpty:#CMPartyReceived And $$IsEmpty:#CMPartySend And $$IsEmpty:#CMPartyOp) then $$number:mad:my2 else $$Number:mad:my1;(#CMPartyReceived=$$Number:" " And #CMPartySend=$$Number:" ") then @my1 else @my2
    my1 : #CMPartyOp+@aaa
    my2 : #CMPartyOp+@bbb
    aaa : $$FilterNumTotal:OpBlSalesColl:IsSameVchPartyOp:$BilledQty-$$FilterNumTotal:OpBlSalesColl:IsSameVchPartyOp:$EiCylinderQtys;$VchCylinderReceieds
    d : $$FilterValue:$CyPartyOpQty:partyStockOpBlColl:1:IsSamePartyOp;If ($$IsEmpty:mad:@PurBags And $$IsEmpty:mad:@SalesBags) then @@OpBagPending else @@OpCollBags;if $$IsEmpty:#CMPartyOp then $$FilterValue:$CyPartyOpQty:partyStockOpBlColl:1:IsSamePartyOp else "0"

    a : #CMPartyOp+#CMPartySend
    b : #CMPartyReceived

    bbb : $$FromValue:mad:@CmpStartDate:$$ToValue:##SVFromDate:mad:c
    c : $$FilterNumTotal:OpBlSalesColl2:IsSameVchPartyOp:$BilledQty;-$$FilterNumTotal:OpBlSalesColl2:IsSameVchPartyOp:$EiCylinderQtys

    Set Always : Yes
    Width : 15% Page
    Style : Normal Bold
    Align : Center
    Format : "No Comma"
    Color : Blue
     


  4. suyash

    suyash New Member


    plz help me for this if you know how to get value Party wise stock Op/Cl qty
     


Share This Page