How to get Total of No.of Kind Packages

Discussion in 'Tally Developer' started by Ch Suresh, Sep 27, 2021.

    
  1. Ch Suresh

    Ch Suresh Member


    Hello Everyone, Good Morning to all

    Please let me know how to get total of No. of Kind packages in Invoice Print
    I tried by separate column in voucher entry column but it is also not working
    i think i missed a collection. Please help me out how to write a collection for it
     

    Attached Files:



  2. Ch Suresh

    Ch Suresh Member


    Please review my code once

    [#Line: EI ColumnOne] ;; Inv Voucher Title
    Add:Right Field:Before : VCH QtyTitle: CHS Packet

    [Field:CHS Packet]
    Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
    SubTitle : Yes
    Setas : $$LocaleString:"Packets"
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes


    [#Line: EI InvInfo] ;; Inv Voucher Body
    Add:Right Field:Before:VCH BilledQty:CHS BilledPacks

    [Field:CHS BilledPacks]
    Use : Number Field
    Set as : $$Value
    Storage : BilledPackets
    Style : Normal Bold
    Border : Thin Left
    Align : Center

    [#Field: EI QtyTotal] ;;Inv Vch Total
    Add:Field:Before:EI ActualQtyTotal:VchFldPacTotal


    [Field: VchFldPacTotal]

    Use : Number Field
    Set as :$$Total:CHSBilledPacks;$$CollNumTotal:StkGrpinventoryEntries:$BilledPackets;:CHSBilledPacks;VCHBATCHBilledQty;VCHBATCHFldQty;VCHBATCHFldQty;
    Style : if @@IsInvVch then "Normal" else "Normal Bold"
    Storage : VchFldPacTotal
    Background : Green
    Align :Center
    Set Always : Yes


    [System:UDF]
    VchFldPacTotal: Number:697
    BilledPackets:Number:2020

    upload_2021-9-27_11-4-17.png
     
    Muhammadhaneef likes this.


  3. narayane88

    narayane88 Active Member


    in part level add same field for total
    in total field write $$total:(Field Name)
     


  4. Ch Suresh

    Ch Suresh Member


    Not working sir,
    I Tried like this in above code

    [Field: VchFldPacTotal]

    Use : Number Field
    Set as :$$Total:CHSBilledPacks
    Storage : VchFldPacTotal
    Background : Green
    Align :Center
    Set Always : Yes
     


  5. narayane88

    narayane88 Active Member


    in part level add follwing statement Totals: ( Field Name)
     


  6. narayane88

    narayane88 Active Member


    write this line n check


    [#Part: EI InvInfo]
    Total : CHSBilledPacks
     
    Ch Suresh likes this.


  7. Ch Suresh

    Ch Suresh Member



    Thank you very much sir
    It is working, Thanks allot
     


  8. Abhinandanjain

    Abhinandanjain New Member


    yes its working but it is not showing in invoice printing ???
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is not coming as it has not been defined for that purpose..........

    Above code is only for voucher Entry screen........ add the fields in the PRINT and it will display.
     
    Jaydeep Shah likes this.


  10. Abhinandanjain

    Abhinandanjain New Member


    Pls Tell, Sir how to add in print ???
     


  11. ONKAR

    ONKAR Active Member


    @Abhinandanjain and @ChSuresh

    try this one ,

    [#Line:EI ColumnOne]
    Add : Right Field : Before : VCH QtyTitle : CHS Packet
    Local : Field : CHS Packet : INFO : “PACKETS”

    [#Line:EI InvInfo]
    add : right field : before : VCH ActualQty :CHS Packet
    [Field : CHS Packet]
    use : Name field
    Storage :CHS PacketStorage
    Set always : yes
    Width : 15
    Align : Center
    invisible : not@@ISSALES @@ISSALESORDER
    [System : UDF]
    CHS PacketStorage : String : 6000

    [#Line: ExpInv Column1]
    Add : left Field : After :EXPINV DescTitle : CHS Packet
    Local : Field : CHS Packet : Info : ”PACKETS”
    Local : Field : CHS Packet : Delete : Storage
    Local : Field : CHS Packet : Type : String
    Local : Field : CHS Packet : align : Center
    Local : Field : CHS Packet : Width : 10
    Local : Field : CHS Packet : border : thin left

    [#Line :ExpInv InvDetails]
    add : left Fields : after : EXPINV Desc :CHSPacketStorage

    [ Field : CHS PacketStorage]
    use : Name Field
    Set as :$CHSPacketStorage
    Set Always : Yes
    Width : 10
    Align : Center
    Border : Thin Left
     


Share This Page