Please help me experts for category name on Sales register reg

Discussion in 'Tally Developer' started by Murali.R, Oct 13, 2014.

    
  1. Murali.R

    Murali.R Member


    [#Line :EI ColumnOne]
    Add : Right Fields : Before : VCH QtyTitle :VCH KGPunitTitle

    [Field : VCH KGPUnittitle]
    info : "Category"
    Width : 40
    Style : Normal Bold
    Color : Red
    Inactive : Not @@IsSales

    [#Line: EI InvInfo]
    Add : Right Fields : Before : VCH BilledQty : SSVchTax

    [Field : SSVchTax]
    Use : Name Field
    Set as : $Category:Stockitem:$Stockitemname
    Storage : SSVchTax
    Width : 40
    Skip : Yes
    ;Inactive : $$IsEnd:$StockItemName
    Inactive : Not @@IsSales
    Color : Red

    [System : UDF]
    SSVchTax : String : 5

    [#Part: DB Columnar]
    Total : DBC LedAmt, DBC GrossAmt,EI AccAllocAmt, DBCAmount, DBC AddlCost, DBC Qty, DBC Revenue, DBC Cost, DBC Profit

    [#Line: DSP ColVchTitle]
    Add : Field : Fldarea
    Local: Field:fldArea:info:$$LocaleString:"Catagory"
    Local:Field:Align:Center
    Local : Field: Width: 20

    [#Line: DSP ColVchDetail]
    add: Fields :fldArea

    [#Line: DSP ColVchDetailAlt]
    add: Fields :fldArea

    [Field:fldArea]
    Use : Namefield
    Set as: $SSVchTax
    Border: Thin Left
    Align: Left
    width :40

    ;----------------


    /*
    [#Line: DSP ColVchTotal]
    Use : DSP ColVchDetail
    Delete : Explode
    Delete : Empty
    Delete : Total
    Border : Flush Totals
    Space Top : if $$InPrintMode then 0.25 else 0
    Fixed : Yes
    Local : Field : Default : Inactive: No
    Local : Field : DBC LedAmt : Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$Total:DBCLedAmt
    Local : Field : DBC Date : Set as : ""
    Local : Field : DBC Party : Set as : $$LocaleString:"Grand Total"
    Local : Field : DBC VchType : Set as : ""
    Local : Field : DBC VchNo : Set as : ""
    Local : Field : DBC BookName : Set as : ""
    Local : Field : DBC BookSlNo : Set as : ""
    Local : Field : DBCPartyExciseRegNo : Set as : ""
    Local : Field : DBC VchRef : Set as : ""
    Local : Field : DBC STNo : Set as : ""
    Local : Field : DBC ServiceTaxNo : Set as : ""
    Local : Field : DBC Narr : Set as : ""
    Local : Field : DBC ExciseRegNo : Set as : ""
    Local : Field : DBC PANNo : Set as : ""
    Local : Field : DBC CSTNo : Set as : ""
    Local : Field : DBC Qty : Set as : $$Total:DBCQty
    Local : Field : DBC Rate : Set as : ""
    Local : Field : DBC GrossAmt : Set as : $$Total:DBCGrossAmt
    Local : Field : EI AccAllocAmt : Set as : $$Total:amount
    Local : Field : DBC Amount : Set as : $$Total:DBCAmount
    Local : Field : DBC AddlCost : Set as : $$Total:DBCAddlCost
    Local : Field : DBC Revenue : Set as : $$Total:DBCRevenue
    Local : Field : DBC Cost : Set as : $$Total:DBCCost
    Local : Field : DBC Profit : Set as : $$Total:DBCProfit
    /*
     


  2. Mahesh Sethi

    Mahesh Sethi Member


    Dear Mr. Murli,

    Pls Try This . This Code is Prvoide by one of expert from forum.

    [#Part: DB Columnar]
    Total : DBC LedAmt, DBC GrossAmt,EI AccAllocAmt, DBCAmount, DBC AddlCost, DBC Qty, DBC Revenue, DBC Cost, DBC Profit

    [#Line: DSP ColVchTitle]
    Local:Field:fldArea:info:$$LocaleString:"Catagory"
    Local:Field:Align:Center
    Local : Field: Width: 20

    [#Line: DSP ColVchDetail]
    add: Fields :Atend :fldArea

    [Field:fldArea]
    Use : Namefield
    Set as: $StockCatagoryName:Stock Item: $StockItemName
    Border: Thin Left
    Align: Left
    width :10

    ;----------------


    /*
    [#Line: DSP ColVchTotal]
    Use : DSP ColVchDetail
    Delete : Explode
    Delete : Empty
    Delete : Total
    Border : Flush Totals
    Space Top : if $$InPrintMode then 0.25 else 0
    Fixed : Yes
    Local : Field : Default : Inactive: No
    Local : Field : DBC LedAmt : Set as : If $$IsRemoteCompany then @@AsLedColtotVal Else $$Total:DBCLedAmt
    Local : Field : DBC Date : Set as : ""
    Local : Field : DBC Party : Set as : $$LocaleString:"Grand Total"
    Local : Field : DBC VchType : Set as : ""
    Local : Field : DBC VchNo : Set as : ""
    Local : Field : DBC BookName : Set as : ""
    Local : Field : DBC BookSlNo : Set as : ""
    Local : Field : DBCPartyExciseRegNo : Set as : ""
    Local : Field : DBC VchRef : Set as : ""
    Local : Field : DBC STNo : Set as : ""
    Local : Field : DBC ServiceTaxNo : Set as : ""
    Local : Field : DBC Narr : Set as : ""
    Local : Field : DBC ExciseRegNo : Set as : ""
    Local : Field : DBC PANNo : Set as : ""
    Local : Field : DBC CSTNo : Set as : ""
    Local : Field : DBC Qty : Set as : $$Total:DBCQty
    Local : Field : DBC Rate : Set as : ""
    Local : Field : DBC GrossAmt : Set as : $$Total:DBCGrossAmt
    Local : Field : EI AccAllocAmt : Set as : $$Total:amount
    Local : Field : DBC Amount : Set as : $$Total:DBCAmount
    Local : Field : DBC AddlCost : Set as : $$Total:DBCAddlCost
    Local : Field : DBC Revenue : Set as : $$Total:DBCRevenue
    Local : Field : DBC Cost : Set as : $$Total:DBCCost
    Local : Field : DBC Profit : Set as : $$Total:DBCProfit
    /*

    if u satisfied then thanks to Admin who provide this platform.....

    Manish
     


  3. Murali.R

    Murali.R Member


    Sir please understand my need, i am attached file please see

    Thanks in advance admin
     

    Attached Files:



  4. Murali.R

    Murali.R Member


    Pleas anyone helpme experts
     

    Attached Files:



  5. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    I have replied to you for this query
     


  6. Murali.R

    Murali.R Member


    Thanks your reply Nagarajkumar sir,
    please sample code for collection method

    thanks in advance
     


  7. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member



  8. Murali.R

    Murali.R Member


    sir,
    Yes Stil i am Facing the problem
    Please My Requirment this Report Please helme sir
    Thanks in advance
     

    Attached Files:



Share This Page