Can see mfg journal inventoryin but can not see stock journal Inventoryin details in Report!!!

Discussion in 'Tally Developer' started by kotharivijay, May 10, 2018.

    
  1. kotharivijay

    kotharivijay New Member


    I hav tried but couldn't find anythin wrong in code ,pls help..


    [#Menu : Gateway of Tally]
    add :key item : after :mad:@locsalesregister :"HYDRO Report" :r:Display : My Voucher Report1
    [Report : My Voucher Report1]
    use :dsp template
    title : "HYDRO report"
    Form :My Voucher Report1
    Variable : SVFromDate,SVToDate
    Set : SVFromDate :$$monthstart : ##SVCurrentDate
    Set : SVToDate : $$monthEND : ##SVCurrentDate
    [#Menu : Gateway of Tally]

    [Form :My Voucher Report1]
    Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure

    Part :DAYBOOKHEAD1,My Voucher Report1
    [Part : daybookhead1]
    Use : My Voucher Report1
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string
    Local : Field : My Voucher Date : Set As : "Date"
    Local : Field : MyVoucherParty: Set As : "Particular"
    Local : Field :FIELD2 : Set As : "Voucher No"
    Local : Field : FIELD1 : Set As : "BATCH NAME"
    Local : Field : MYVCHNO: Set As : "QUANTITY"

    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyVchAmount : Set As : "AMOUNT"
    ;Local : Field : MyVchAmount : Set As : "Sales"
    ;Local : Field : MyVchAmount1 : Set As : "Receipt"
    ;Local : Field : MyVchAmount2 : Set As : "Payment"
    ;Local : Field : MyVchAmount3 : Set As : "Debit Note"
    ;Local : Field : MyVchAmount4 : Set As : "Credit Note"
    ;Local : Field : MyVchAmount5 : Set As : "Journal"
    ;Local : Field : MyVchAmount6 : Set As : "Purchase"
    ;

    ; Local :Field : Default : Style : Large Bold
    Local: Field: Default: Align: LEFT;Center
    ;Local: Field: Default:Background: Green


    [Part :My Voucher Report1]
    Line : My Voucher Report1
    Repeat :My Voucher Report1 :My Voucher Rep Collection
    Scroll : Vertical
    Border:THIN
    [Line :My Voucher Report1]
    Field :My Voucher Date,MyVoucherParty,FIELD2,FIELD1

    Right Field : MyVchNo,MyVchType,MyVchAmount
    Border:THIN
    Explode : MyInvExplode
    [Field :My Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border : THIN RIGHT
    [Field : MyVoucherParty]
    Use : NAme Field
    Set As : $PArtyLedgerName
    Border : THIN RIGHT
    [Field : FIELD1]
    Use : NAme Field
    Border : THIN RIGHT
    ;Set As : $PArtyLedgerName
    [Field : FIELD2]
    Use : NAme Field
    Set As : $REFERENCE
    Border : THIN RIGHT

    [Field : MyVchNo]
    Use : NAme Field
    Set As : $VoucherNumber
    Border : THIN RIGHT
    [Field : MyVchType]
    Use : Name Field
    Set As : $VoucherTypeName
    Border : THIN RIGHT
    [Field : MyVchAmount]
    Use : Amount Field
    Set As : $$FilterAmtTotal:AllInventoryEntries:MyFilter:$Amount
    Border : THIN RIGHT
    [System : Formula]

    [Collection : My Voucher Rep Collection]

    Type : Vouchers : VoucherType
    Child of : $$VchTypeStockJrnl

    Fetch : Date,Amount,VoucherTypeName,REFERENCE ,PArtyLedgerName,VoucherNumber
    ;Sort:DEFAULT:$REFERENCE
    [Part : MyInvExplode]
    Line : MyInvExplode
    Border:THIN
    Repeat : MyInvExplode : INVENTORYENTRIESIN
    [Line : MyInvExplode]
    Field :My Voucher Date,MyVoucherParty
    Right Field : MyVchNo,MyVchType,MyVchAmount
    ;Local : Field : My Voucher Date : Set As : “”

    Local : Field : MyVoucherParty: Set As : $StockItemName
    Local : Field : MyVchAmount: Set As : $Amount
    Local : Field : MyVchNo: Set As :""
    Local : Field : MyVchType: Set As :""
    Border:THIN
    Explode : My Batch Allocations

    [Part : My Batch Allocations]
    Line :My Batch Allocations
    Repeat :My Batch Allocations : BatchAllocations
    [Line :My Batch Allocations]
    Field :My Voucher Date,MyVoucherParty,FIELD2,FIELD1
    Right Field : MyVchNo,MyVchType,MyVchAmount
    ;Local : Field : My Voucher Date : Set As :“”
    ;Local : Field : MyVoucherParty: Set As :$BATCHNAME
    Local : Field : FIELD1: Set As :$BATCHNAME
    Local : Field : MyVchAmount: Set As : ""
    Local : Field : MyVchNo: Set As :$ACTUALQTY
    Local : Field : MyVchType: Set As :""
    ;Local : Field : Default : Color : Red
     

    Attached Files:



  2. kotharivijay

    kotharivijay New Member


    anyone.. like to help..!!
    Admin need ur support!!
     


  3. kotharivijay

    kotharivijay New Member


    anyone.. like to help..!!
    Admin need ur support!!
     


  4. mahgs

    mahgs Member


    Replace the code



    [Collection : My Voucher Rep Collection]

    Type : Vouchers : VoucherType
    Belongs To :Yes
    Child of : $$VchTypeStockJrnl

    Fetch : Date,Amount,VoucherTypeName,REFERENCE ,PArtyLedgerName,VoucherNumber
     


Share This Page