In Tally we take entries and generate reports to simplify our business.
Sometime we gave goods to our customer in credit and outstanding were generated. Then we need to collect all borrowing and required customer’s all details in one place.
It can be possible with TDL files. And today I have a special TDL for your Tally ERP 9 software.
With this TDL file you will get parties detail at one place with there State, GST Number, PAN Number, Mobile Number, and Outstanding.
It will be very helpful to collect outstanding and there GST details.
And also helpful in GST return filing.
Copy the following code in Tally and enjoy:
[#Menu: Gateway of Tally]
Add : Key Item : Party Details : D : Display Collection : LearnWell
[Collection: LearnWell]
Title : “List of Group”
Type : Group
Belongs To : Yes
Variable : GroupName
Report : Party Details
Trigger : GSTIN Grp Trigger Rep
Align : Centre
[Report : GSTIN Grp Trigger Rep]
Use : Collection Variable
Local : Line : Collection Variable : Add : Field : GSTINCGrpListFld
Local : Field: MV Title : Info : “GROUPS”
[Field: GSTINCGrpListFld]
Use : Name Field
Variable : GroupName
Modifies : GroupName
Table : LearnWell
Show Table : Always
[Report : Party Details]
Variable : SVFromDate, SVToDate
Set : SVfromDate : ##SVToDate
Set : GroupName : ##GroupName
Variable : IsMultiPage, InNewPages
Set : IsMultiPage : yes
Set : InNewPages : yes
Set : SVToDate : ##SVCurrentdate
Form : LearnWellWT
;;….www.Learnwells.com…,,
[Form : LearnWellWT]
Page Break : Cl Page Break1, Op Page Break1
Height : 100% Screen
Width : 100% Screen
BackGround : Lily White
Space Top : If $$InPrintMode Then 0.5 Else 0 inches
Button : PrintButton, ExportButton,F2 ChangePeriod,Delete Ledge,Form Remove Lin
Parts : ONC TitGSTIN,ONCinfoReportGSTIN,Develedbyname
[Part : ONC TitGSTIN]
Space Bottom : 0.2 inch
Line : ONC Tit LineGSTIN,ONC Tit LineGSTIN1,ONCDateGSTIN,SDOBCNCToDatedLinGSTIN
[Line : ONC Tit LineGSTIN]
Field : ONC Tit FieldGSTIN
[Field : ONC Tit FieldGSTIN]
Use : Name Field
Set as : $Name:Company:##SVCurrentCompany
Align : Center
Full Width : Yes
Style : TextStyleGSTIN
[Style: TextStyleGSTIN]
Font : Algerian
Height : 16
[Line : ONC Tit LineGSTIN1]
Field : ONC Tit FieldGSTIN1
[Field : ONC Tit FieldGSTIN1]
Use : Name Field
Set as : $Address:Company:##SVCurrentCompany
Align : Center
Full Width : Yes
Border : Thin Box
[Line : ONCDateGSTIN]
Field:Group SDOBNCGSTIN,Group SDOBNCansGSTIN
Space Bottom :2 mms
[Field:Group SDOBNCGSTIN]
Use:Name Field
SetAs:”Group Name:”
Width:25 mms
Style:Tiny
Align : Center
[Field:Group SDOBNCansGSTIN]
Use:Name Field
SetAs:##GroupName
Width:200 mms
Style:Tiny
[Line :SDOBCNCToDatedLinGSTIN]
Field : SDOBCNCfrmdateFldGSTIN
[Field :SDOBCNCfrmdateFldGSTIN]
Use:Medium prompt
Setas :”Detailed Report”
Width :40 mms
Style :Tiny
Align : Center
Border : Thin Box
[Part : ONCInfoReportGSTIN]
Line : ONCcolumnTitlesGSTIN,ONCInfoGSTIN
Repeat : ONCInfoGSTIN : MycollectionGSTIN
Scroll : Both
Common Border : Yes
Float : No
Border : Thin Box
[Line : ONCColumnTitlesGSTIN]
Border : Column Titles
Fields : ParticularsGSTIN,SDGroupNameGSTIN1,Op.Bal.GSTIN,SDGroupNameGSTIN,Regtypevaibh,Pan,Mobile,Outstanding
Local : Field : ParticularsGSTIN : Set as : “Particulars”
Local : Field : ParticularsGSTIN : Line : 0
Local : Field : Op.Bal.GSTIN : Set as : “State”
Local : Field : SDGroupNameGSTIN : Set as : “GST No.”
Local : Field : SDGroupNameGSTIN1 : Set as : “Group Name”
Local : Field : Regtypevaibh : Set as : “Registration Type”
Local : Field : Pan : Set as : “Pan No.”
Local : Field : Mobile : Set as : “Mobile No”
Local : Field : Outstanding : Set as : “Outstanding”
Local : Field : Default : Type : String
Local : Field : Default : Style : Small
Local : Field : Default : Align : Center
Local : Field : Default : Background : @@SV_UNYELLOW
[Line : ONCInfoGSTIN]
Fields :ParticularsGSTIN,SDGroupNameGSTIN1,Op.Bal.GSTIN,SDGroupNameGSTIN,Regtypevaibh,Pan,Mobile,Outstanding
Option : AlterOnEnter
[Field : ParticularsGSTIN]
Use : Name Field
Set as : $Name
Width : 26% Screen
Border : Thin Bottom
Alter : Ledger
[Field : Op.Bal.GSTIN]
Use : Name Field
Set as : if $$IsEmpty:$LedStateName then ” ” else $LedStateName + ” (“+ $$getgststatecode:($LedStateName) + “)”
Width : 12% Screen
Border : Thin Left
[Field : SDGroupNameGSTIN]
Set as : $PARTYGSTIN
Width : 12% Screen
Border : Thin Left
[Field : SDGroupNameGSTIN1]
Set as : $Parent
Width : 10% Screen
Border : Thin Left Right
[Field : Regtypevaibh]
Set as : $GSTRegistrationType
Width : 11% Screen
Border : Thin Left Right
[Field : Pan]
Set as :$IncomeTaxNumber
Width : 9% Screen
Border : Thin Left Right
[Field : Mobile]
Set as :$LedgerMobile
Width : 9% Screen
Border : Thin Left Right
[Field : Outstanding]
Set as :$ClosingBalance
Width : 11% Screen
Border : Thin Left Right
[Part: Develedbyname]
Space Bottom : 0.2 inch
Line: COlTotalsGSTIN
[Line: COlTotalsGSTIN]
Field : ONC Tit FieldGSTIN0
[Field : ONC Tit FieldGSTIN0]
Use : Name Field
Set as : “www.Learnwells.com”
Align : Center
Full Width : Yes
Border : Thin Box
[Part: Cl Page Break1]
Lines : Cont Line1
[Line: Cont Line1]
Field: Cont Field1
Border: Full Thin Top
[Field: Cont Field1]
Set As : “Continued……..”
Full width : Yes
Align : Right
[Part: Op Page Break1]
Parts : DSP OpCompanyName, DSP OpReportTitle
Vertical: Yes
[Collection : MycollectionGSTIN]
Type : Ledger
Child Of:##GroupName
Belongs To : Yes
[Button : Remove LinE]
Key : Alt+R
Action : Remove Line
Mode : Display
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save
Now your TDL is ready to use.
Also you can download it with below Button:
How to use the code
Add Mail id Section in code