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

11 thoughts on “Create a Report in Tally to fetch Data through Collection

  1. Giridharan Varadharajan says:

    Giridharan Varadharajan
    Sir,
    I have finished this assignment.
    The coding and output are in my folder under following name
    1. Led display using Collection.txt
    2. Led display using collection.png
    please verify

    1. Please create a sub folder in your folder. Name it as ReportFolder and move your files to that folder. I want all your files properly categorised to appropriate folder/sub folder.

  2. Zakir Hossain says:

    Dear sir
    while we are creating collection we need to specify “Type”. How can we understand will be the type of my collection. can you please explain?
    Collection type can be voucher, ledger, stockitem what else and how we should select a Type for my collection

    Thank you

    1. Sathis Kumar S says:

      Hi, how do get bill wise collection statement.. thanks in advance..

  3. Nitesh Mehndiratta says:

    How to get the collection of voucher of a particular ledger.
    I think the code would be

    [Collection : MyVouchers]
    Type : Vouchers
    ChildOf : Name of the Ledger of which vouchers are required in double quotes

    Kindly correct me if I am wrong, I am asking you because there is no way to check the same

    1. You can put a filter to the collection
      Filter : myfilter

      [System :formulae]
      myfitler : LedgerName Contains “xyz” something like that

  4. Tojo Thomas says:

    Dear Sir,
    When we create a collection in the menu Inventory Info, what do we specify for the “Type ” attribute? How do we understand what is the type of the collection we are creating?

    1. Please start from unit 1 and do all the projects and save to your Dropbox and you will understand the things
      on your own.
      You can’t understand anything if you just jump to a report

      If you want to study the course in your way only then I can’t offer any explanations or help.
      But if you go unit by unit then I could be helpful to you to understand the stuff.

  5. FARRAKH HAYAT says:

    Error:
    could not fit on screen
    too small to be used
    I have tried to control size but could not.
    Kindly guide.

    [#Menu:GateWay of Tally]

    Add:Item :My TM Report : Display: My First Report

    [Report: My First Report]
    Form : My First Form

    [Form : My First Form]
    Parts : MyPartDet
    Height : 8 Inches
    Width : 6 Inches

    [Part : MyPartDet]
    line : MyLineDet
    Repeat : MyLineDet : MyFirstCollection ;;Repeating “Line” and “Collection” under Part level.

    [line : MyLineDet]
    Field : MyLedName, MyLedBel

    [Field : MyLedName]
    Use : Name Field
    Set As : $Name

    [Field : MyLedBel]
    Use : Amount Field
    Set As : $ClosingBalance

    [Collection:MyFirstCollection]
    Type : Ledger

    1. [Part : MyPartDet]
      line : MyLineDet
      Repeat : MyLineDet : MyFirstCollection
      Scroll : vertical
      vertical : yes
      If it doens’t work then remove height and width from the form.

Leave a Reply