GETWIN TALLY

Discussion in 'Free Source Codes' started by jagadish bhai, Jul 19, 2019.

    
?

alternative quantity using which code

Poll closed Sep 19, 2019.
  1. basic units

    33.3%
  2. addtional units

    100.0%
Multiple votes are allowed.
  1. jagadish bhai

    jagadish bhai New Member



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code already existing in this forum. You need to search for it............
     


  3. jagadish bhai

    jagadish bhai New Member


    plz help me sir
    but not working that code in this form

    [System:formulae]
    HPUnitDtlss:$ItemUnitQtys

    [Collection:HPUnitCollections]
    Source Collection: Default
    Walk: InventoryEntries

    Fetch:BilledQty,StockItemName
    By :ItemUnits:$$IsSysName:$AdditionalUnits:StockItem:$StockItemName
    Aggr Compute :ItemUnitQtys:Sum:$BilledQty:Symbol,ShortForm,Secondary ;+ " )"
    Format:Symbol,ShortForm,Secondary
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    When there are multiple Units...it will not total............in default tally.
     


  5. jagadish bhai

    jagadish bhai New Member


    what i am do plz help me sir



    [System:formulae]
    HPUnitDtlss:$ItemUnitQtys

    [Collection:HPUnitCollections]
    Source Collection: Default
    Walk: InventoryEntries

    Fetch:BilledQty,StockItemName
    By :ItemUnits:$$IsSysName:$AdditionalUnits:StockItem:$StockItemName
    Aggr Compute :ItemUnitQtys:Sum:$BilledQty:Symbol,ShortForm,Secondary ;+ " )"
    Format:Symbol,ShortForm,Secondary
     
    Last edited: Jul 22, 2019


  6. B Patil

    B Patil New Member


    Convert Qty from Tally Data Type Quantity to Number (remove Symbols) and Total it up
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    1000 Millilitres
    50 Litres
    120 Kgs
    5 Nos
    10 Dozens

    Total : 11185

    Is that a logical count ???
     


  8. jagadish bhai

    jagadish bhai New Member


    Fertilizer module in tally:-
    if you want my mail id :-winway757@gmail.com
     


  9. Mukesh1001

    Mukesh1001 New Member


    Try any
    $$CollQtyTotal:InventoryEntries:$BilledQty
    $$FilterQtyTotal:InventoryEntries:OwnItemOutEntries:$ActualQty + $$Negative:$$FilterQtyTotal:InventoryEntries:OwnItemOutRevEntries:$ActualQty
    $ActualQty * $$ToValue:$CostDate:$ClosingRate:StockItem:$StockItemName
    $$AllocTrackValue / #TRACKVCHQty
    $$AsInQty:$$NettQty:$$VchItemTotal:$ClosingBalance:StockItem:$StockItemName
    $$AsReqObj:$$CollQtyTotal:StockItemBelongsToGroupName:$ItemLedTrSaleQty
    ($$AsSignedQty:$$PrevFld / $$Number:$$AsSignedQty:$$PrevFldTotal) * 100
    $$BaseValue:$$ToValue:mad:ConsDay:$$ResidualValue:#StockItemName:mad:BatchName:mad:GodownName:#DSPVchOutQty
    $$CollQtyTotal:InventoryEntries:$BilledQty
    Double Sub Column Titles : $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
    EXPINV BilledQtyTotal
    if $StockItemName = $$ReqObject:$Name then $ActualQty else ($ComponentReqdQty:StockItem:$StockItemName * ($ActualQty / $BasicQty:StockItem:$StockItemName))
    $$IsSysName:$StockItemName OR $$IsSysName:$AdditionalUnits:StockItem:$StockItemName OR $$IsEmpty:$ActualQty
    $$NettQty:#DSPVchInTotalQty:#DSPVchOutTotalQty
    (##ShowQtyExtract AND $$IsInventoryOn) OR @@IsVarInvVch

    $$SubTotal:DSPVchInQty
    $$SubTotal:DSPVchOutQty
    $$Total:VCHBATCHBilledQty
    Line 34047: $$Total:VCHBilledQty
     


  10. ANAND J

    ANAND J Member



Share This Page