11 thoughts on “Create a Report in Tally to fetch Data through Collection”
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
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.
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
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?
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.
[Part : MyPartDet]
line : MyLineDet
Repeat : MyLineDet : MyFirstCollection
Scroll : vertical
vertical : yes
If it doens’t work then remove height and width from the form.
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
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.
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
Hi, how do get bill wise collection statement.. thanks in advance..
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
You can put a filter to the collection
Filter : myfilter
[System :formulae]
myfitler : LedgerName Contains “xyz” something like that
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?
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.
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
[Part : MyPartDet]
line : MyLineDet
Repeat : MyLineDet : MyFirstCollection
Scroll : vertical
vertical : yes
If it doens’t work then remove height and width from the form.
Yes, it is working now.
Thank you