You cannot view this unit as you're not logged in yet.

3 thoughts on “I: Sales report Customization IX

  1. Sameer Bansal says:

    [#Menu: Gateway of Tally]
    Add: Item: Ledger Report: Display: New Ledger Report

    [Report: New Ledger Report]
    Add: Form: NewLedgerReport

    [Form: NewLedgerReport]
    Part : NewLedgerReport_TopPart
    Width : 100% screen
    Height : 100% screen
    Button : Change Period, Export Button, ExplodeFlag

    [Part: NewLedgerReport_TopPart]
    Add: Line : NewLedgerReport_ColumnLine, NewLedgerReport_MainLine
    Repeat : NewLedgerReport_MainLine: NewLedgerReport_Coll_Walk
    Vertical : Yes

    [Line: NewLedgerReport_ColumnLine]
    Use : NewLedgerReport_MainLine
    Local : Field: NewLedgerReport_Date : Info: “Date”
    Local : Field: NewLedgerReport_VchNo : Info: “Vch. No.”
    Local : Field: NewLedgerReport_PartyName : Info: “Party Name”
    Local : Field: NewLedgerReport_Item : Info: “Item”
    Local : Field: NewLedgerReport_Qty : Info: “Qty.”
    Local : Field: NewLedgerReport_Rate : Info: “Rate”
    Local : Field: NewLedgerReport_Amount : Info: “Amount”
    Local : Field: Deafult : Type: String
    Border : Column Titles

    [Line: NewLedgerReport_MainLine]
    Field: NewLedgerReport_Date, NewLedgerReport_VchNo, NewLedgerReport_PartyName, NewLedgerReport_Item
    Right Field: NewLedgerReport_Qty, NewLedgerReport_Rate, NewLedgerReport_Amount

    Explode: InventoryExplodePart: ($$KeyExplode OR ##ExplodeFlag)

    [Part: InventoryExplodePart]
    Line: ExplodeLineMain
    Repeat: ExplodeLineMain : AllInventoryEntries

    [Line: ExplodeLineMain]
    Field: Name Field
    Local: Field: Name Field: Set as: “ASLKDFJKALSJFKLASJ FKLASJ FKASJFASJFLASK JFKAS ”
    Local: Field: Name Field: Full Width: Yes
    Local: Field: Name Field: Type: String

    [Field: NewLedgerReport_Date]
    Use : Uni Date Field
    Set as : $Date

    [Field: NewLedgerReport_VchNo]
    Use : Number Field
    Set as : $VchNo

    [Field: NewLedgerReport_PartyName]
    Use : Name Field
    Set as : $Name

    [Field: NewLedgerReport_Item]
    Use : Name Field
    Set as : $MyItem

    [Field: NewLedgerReport_Qty]
    Use : Qty Primary Field
    Set as : $MyQty

    [Field: NewLedgerReport_Rate]
    Use : Rate Field
    Set as : $sRate

    [Field: NewLedgerReport_Amount]
    Use : Amount Field
    Set as : $Amt

    [Collection: NewLedgerReport_Coll]
    Type : Vouchers: VoucherTypes
    Child Of : $$VchTypeSales
    Belongs To : Yes
    Fetch : StockItemName

    [Collection: NewLedgerReport_Coll_Walk]
    Source Collection: NewLedgerReport_Coll
    Walk : Ledger Entries
    By : MyItem : $StockItemName
    By : Name : $PartyLedgerName
    By : Date : $Date
    By : VchNo : $VoucherNumber
    Compute : MyQty : $BilledQty
    Compute : sRate : $Rate
    Compute : Amt : $Amount

    Here is my full code… which is accurate according to me but still explode function is not working.

Leave a Reply