My Inward Qty My Outward Qty

Discussion in 'Tally Developer' started by Taufeeq Shaikh, Jan 4, 2014.

    
  1. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Dear All,

    I have made two UDF Qty Fields for Gross Inward & Gross Outward. I had also tried for fetching it in two columns besides Inward & Outward Column. But its not working. Kindly Help.



    ;;======================= Stock Journal Modification ========================;;


    [#Line: SJ TitleTwoB]

    Add : Field : At Beginning: DSP VCHGROut


    [#Line: SJ TitleTwoC]

    Add : Field : At Beginning : DSP VCHGRInw

    [#Part: SJOut]

    Total : GrOut

    [#Part: SJIn]

    Total : GrInw

    [#Line: SJDetailsB]

    Add : Field : At Beginning : GrOut

    [#Line: SJDetailsD]

    Add : Field : At Beginning : GrInw


    [Field: GrOut]

    Use : Qty Primary Field
    Width : @@VCHQtyWidth
    Set as : $GrOut
    Storage : GrOut
    Inactive : $$IsEnd:$StockItemName OR @@NoBaseUnits
    Validate : NOT $$IsEmpty:$$Value OR $$IsSysName:$TrackingNumber



    [Field: GrInw]

    Use : Qty Primary Field
    Width : @@VCHQtyWidth
    Set as : $GrInw
    Storage : GrInw
    Inactive : $$IsEnd:$StockItemName OR @@NoBaseUnits
    Validate : NOT $$IsEmpty:$$Value OR $$IsSysName:$TrackingNumber



    [#Line: SJ Totals]

    Add : Field : At Beginning : GrOutTot

    [Field: GrOutTot]

    Use : Voucher Qty Total
    Set as : $$Total:GrOut
    Style : if @@IsInvVch then "Normal" else "Normal Bold"


    [System : Udf]

    GrOut: Quantity : 30111
    GrInw: Quantity : 30112
    GroutTot: Quantity : 30113



    ;;============== Dispalying in Stock Journal / Daybook Report ==========;;

    [#Line: DSP VchInv1Titles]

    Add : Field : Before : DSP VchInTitle : DSP VCHGRInw
    Add : Field : Before : DSP VchOutTitle : DSP VCHGROut


    [Field: DSP VCHGRInw]

    Info : $$LocaleString:"Gross Inw"
    Align : Centre
    Style : Normal Bold



    [Field: DSP VCHGROut]

    Info : $$LocaleString:"Gross Out"
    Align : Centre
    Style : Normal Bold



    [#Line: DSP VchInv2Titles]

    Add : Field : Before : DSP InDetTitle : DSP VCHGRInw1
    Add : Field : Before : DSP OutDetTitle : DSP VCHGROut1


    [Field: DSP VCHGRInw1]

    Use : Qty Title Field
    Width : @@DSPVchQtyWidth
    Set as : $$LocaleString:"Quantity"
    Align : Centre


    [Field: DSP VCHGROut1]

    Use : Qty Title Field
    Width : @@DSPVchQtyWidth
    Set as : $$LocaleString:"Quantity"
    Align : Centre



    [#Line: DSP VchInvDetail]

    Add : Field : After : DSP InBlock : DSP GrInw
    Add : Field : After : DSP OutBlock : DSP GrOut


    [Field: DSP GrInw]

    Use : Qty Primary Field
    Set as : $GrInw
    Border : Thin Left


    [Field: DSP GrOut]

    Use : Qty Primary Field
    Set as : $GrOut
    Border : Thin Left



    [#Part: DayBookVCHINVAlloc Explosion]

    Local: Line: DSP InvAllocDetails: Add: Field : Before : DSP VchBilledQty : DSP GrInw


    [#Line: DSP InvDetails]

    Add : Field : Before : DSP DBDrQty : DSP GrInw





    ;;================ Fetching UDF values in collection ==============================================;;


    [#Collection: StkJrnl Vouchers of Company]

    Fetch : AllInventoryEntries.GrInw, AllInventoryEntries.GrOut

    [#Collection: Daybook Vouchers of Company]

    Fetch : AllInventoryEntries.GrInw, AllInventoryEntries.GrOut

    [#Collection: NRM Vouchers of Company]

    Fetch : AllInventoryEntries.GrInw, AllInventoryEntries.GrOut
     
    kamalpatel likes this.


  2. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    It should be fetched in Stock Voucher Register / Day Book Report
     
    kamalpatel likes this.


  3. sayed

    sayed Member


    sir stock jouranl voucher in inward and outward is big problem to me
    how i remove stock jouranl voucher from inward and outward in stock summary report ?
     


  4. Muhammadhaneef

    Muhammadhaneef New Member


    How can get stock journal (Destination) Production Field alter i want to showing alt unit with ActQty in stock journal voucher.
     


  5. svn

    svn Member


    CAN YOU PLEASE TELL ME FOR TAX AMOUNT INWORDS CODE ?
     

    Attached Files:



  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$InWords
     


Share This Page