Create a New Report of all Sales Voucher with Additional Columns

Discussion in 'Requests' started by Ramu Angappan, Feb 14, 2013.

    
  1. Ramu Angappan

    Ramu Angappan Member


    Dear Experts,

    I Want to create a new report only to display all the sales voucher. I have done this like how to do it in sales register screen.

    But when i enter a particular line it should not go to the voucher screen. it should go to its corresponding supplementary screen.

    EI Supplemntary

    I have written the code for the same, it displays only sales vouchers and when i enter it goes to Supplementary form but it doesn't go to that voucher screen's supplementary screen rather it displays only a general supplementary form.


    Someone please guide me



    [#Menu: Gateway of Tally]
    Add : Item : Despatch Reports : Display : Despatch Reports

    [Report: Despatch Reports]
    Form : Despatch Reports
    PreFetch Object : Ledger: ##LedgerName: LastVoucherDate, TaxType, IsCashBankAccount,IsCashAccount, IsTCSPartyLedger


    ;Variable : GroupVar

    [Form: Despatch Reports]

    Use : DSP Template
    Parts : Form SubTitle, Despatch Reports
    ;; Using Default Part Form SubTitle for Inserting a Title Line
    ;; Locally modifying the Title to suit our current Report Information
    Local : Field : Form SubTitle : Info : “ Despatch Reports”

    [Part: Despatch Reports]

    Lines : Despatch Reports Title, Despatch Reports Detail
    ;; The Line LL with DOB is instructed to repeat over all Ledgers
    Set : VoucherTypeName : $$VchTypeSales
    Repeat : Despatch Reports Detail : Company Vouchers
    ;; Associating the Object Ledger with Line LL with DOB such that every line will be associated with
    ;; subsequent ledger in the Collection Ledger
    Scroll : Vertical
    Common Border : Yes

    [Line: Despatch Reports Title]
    Use : Despatch Reports Detail
    Border : Thin Top Bottom
    Local: Field : Default : Type : String
    Local: Field : Default : Align: Centre
    ;; Locally setting values to individual Fields within this Line
    Local: Field: RS Name: Set As: “Name”
    Local: Field: RS ActTransp : Set As: Actual Transporter”
    Local: Field: RS DesBox: Set As: “Total Box”
    Local: Field: RS DesWeight : Set As: “Weight”
    Local: Field: RS DesDate : Set As: “Actual Despatch Date”
    Local: Field: RS DesDelDate : Set As: “Delivery Date”

    [Line: Despatch Reports Detail]

    Fields : RS Name, RS ActTransp, RS DesBox, RS DesWeight,RS DesDate
    Add : Left Fields : DSP VchAccount
    Right Fields: RS DesDelDate
    ;; All the Lines where Value for the UDF Birth Date is empty, Empty the lines
    ;Empty : $$IsEmpty:$DesDate
    ;; Value of any User Defined Fields/Methods can be retrieved using $ Prefix.

    [Field: RS Name]
    Use : Name Field
    ;; Name Field is a Template defined in Default TDL for Fields of Type String with predefined Width
    Set As : $FirstLedger ;; Default Method Name used to set Name
    Variable: GroupVar
    Variables : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod, SVBudget, SVVariance
    Variables : ExplodeFlag, ExplodeNarrFlag, IsDayBook, IsItemReport, VoucherTypeName, FamilyVoucherFlag
    Variables : DBBillExplodeFlag, DBCostExplodeFlag, DBInvExplodeFlag, DBIncludeFamily, DBBankExplodeFlag
    Variable : DSPShowMonthly, DSPHasMultiLevel, ShowForex
    Variable : OnlyInVouchers, OnlyOutVouchers
    Variable : OnlyAccVouchers, OnlyInvVouchers
    Variable : IsLedgerReport, IsCCReport, IsGrpReport
    Variable : DSPNotScaleable, DSPHasColumnTotal
    Variable : ColumnarDayBook, ExtractMode, ShowQtyExtract
    Variable : GroupName, StockGroupName, TallyAudit
    Variable : DSPShowGP, SVMaxAuditVouchers
    Variable: DBFilterVar
    Variable: SVClientRule
    Variable: SVServerRule
    Variable: IsMultiPage
    Variable: VchOfMaterialTranserOut, VchOfMaterialTranserIn
    Display : DesPScreen

    [Field: RS ActTransp]
    Use : Name Field
    Set As : $DesActualTrans ;; Default Method Ledger Phone used to set Phone
    Border : Thin Left

    [Field: RS DesBox]
    Use : Number Field
    Set As : $DesBox ;; Default Method EMail
    used to set Ledger Email
    Border : Thin Left

    [Field: RS DesWeight]
    Use : Number Field
    Set As : $DesWeight
    Border : Thin Left

    [Field: RS DesDate]
    Use : Uni Date Field
    ;; Uni Date Field is a Template defined in Default TDL for Fields of Type Date with predefined Width
    Set As : $DesDate
    Border : Thin Left

    [Field: RS DesDelDate]
    Use : Uni Date Field
    ;; Uni Date Field is a Template defined in Default TDL for Fields of Type Date with predefined Width
    Set As : $DesDelDate
    Border : Thin Left


    [Variable: Group Var]
    Type : String
    Default : ""
    Volatile : Yes

    [Report: DesPScreen]
    Form : EI Supplementary
    Variable : GroupVar
     

    Attached Files:



  2. Ramu Angappan

    Ramu Angappan Member


    I added voucher object with voucher I'd. It works but I want this screen to be editable... What command should I use??

    I have used display: my report
    In the above code
     



  3. hi,

    Use Alter instead of Display which will serve your purpose.
     


  4. Ramu Angappan

    Ramu Angappan Member



    I tried it Sir, but now its not even going to the new form that is its not going to display mode also.

    When i enter a line nothing happens

    Kindly Help!
     


Share This Page