Tally Chapter 122 TDL for Advance Bank Details By Rajiv Mishra Computer Class

-

 


Few lines are missing here. Pls Watch the chapter Video for full coding







[Line: IFSCno]
Field: Long Prompt,IFSCno
Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
Local: Field: Long Prompt: Set as: "IFSC CODE NO"

[Line: MICRno]
Field: Long Prompt,MICRno
Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
Local: Field: Long Prompt: Set as: "MICR CODE NO"

[Line: AccountHolder1st]
Field: Long Prompt,AccountHolder1st
Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
Local: Field: Long Prompt: Set as: "1ST ACCOUNT HOLDER'S NAME"

[Line: AccountHolder2nd]
Field: Long Prompt,AccountHolder2nd
Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
Local: Field: Long Prompt: Set as: "2ND ACCOUNT HOLDER'S NAME"

[Field : IFSCno]
use : Name Field
Storage : IFSC


[Field : MICRno]
Use : Name Field
Storage :MICR

[Field : AccountHolder1st]
use : Name Field
Storage :AccountHolder1st

[Field : AccountHolder2nd]
use : Name Field
Storage :AccountHolder2nd



[System : UDF]

IFSC : String : 1001
MICR: String : 1002
AccountHolder1st : String : 1003
AccountHolder2nd : String : 1004



[#Menu : Gateway of Tally]

Add : Item : Bank Account Details : Display : Bank Account Details

[Report : Bank Account Details]


Use : DSP Template
Variable : SVFromDate, SVToDate
Set : SVfromDate : ##SVDate
Set : SVToDate : ##SVCurrentDate
Form : Bank Account Details Form


[Form : Bank Account Details Form]
Parts : DSp Company Name, DSP Company Address
Bottom Part:smsMark
Use : DSP Template 
Delete : Page Break
Add : Page Break : SatCl Page Break, SatOp Page Break
Height : 100% Screen
Width : 100% Screen
BackGround : Light Yellow
Space Top : If $$InPrintMode Then 0.5 Else 0 inches
Button : PrintButton,ExportButton,F2 ChangePeriod
Parts : Bank Account Details Tit,Bank Account Details Report
Local : Part: DSP Company Address : invisible : No

[Part:smsMark]
Line:smsMarkLn
[Line:smsMarkLn]
Field:smsMarkFld
[Field:smsMarkFld]
Use:Name Field
Set as:"Visit: Rajiv Mishra Youtube Channel"
Full Width:Yes
Align:Center
Color:"Blue"
Style:sms007
Border:Thin Bottom
Read Only:Yes
Skip Forward:Yes
[Style:sms007]
Font:"Times New Roman"
Height:14

[Part : SatCl Page Break]
Lines : SatCont Line
Float: Yes
Vertical : Yes

[Line : SatCont Line]
Field : SatCont Field

[Field : SatCont Field]

Set as : "Continued....."
Full Width : Yes
Align : Right

[Part :SatOp Page Break]
Parts: DSP OpCompanyName, DSP OpReportTitle 
Vertical: Yes
Part: SatOpPart

[Part: SatOpPart]
Line: SatOp Page Break
Common Border: Yes
Float: Yes

[Line: SatOp Page Break]
Use: Bank Account DetailscolumnTitles

Fields: Serial No1., Bankname, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch
Local: Field: Default: Border:Thin Left right 


[Part : Bank Account Details Tit]

Space Bottom : 0.2 inch
Line : Bank Account Details Tit Line1,Line2, Line3,Bank Account DetailsDate


[Line : Bank Account Details Tit Line1]

Field : Bank Account Details Tit Field1

[Field : Bank Account Details Tit Field1]
Use : Name Field
Set as : "Bank Account Detail Register"
Align : Center
Full Width : Yes
Style : Large Bold

[Line :  Line2]

Field :  Field2

[Field : Field2]
Use : Name Field
Set as : "Developed by Rajiv Mishra"
Align : Center
Full Width : Yes
Style : Normal



[Line :  Line3]

Field :  Field3

[Field : Field3]
Use : Name Field
Set as : "Delhi"
Align : Center
Full Width : Yes
Style : Normal

[Line : Bank Account DetailsDate]

Space Top: 1% page
Field : Bank Account DetailFromdt,ToooField,Bank Account DetailTodt

[Field : Bank Account DetailFromdt]

Use : Date Field 
Set as : ##SVfromDate
Width : 45% Screen
Align : Center
Style : Normal 

[Field : ToooField]

Use : Name Field
Set as : "To"
Width : 4% Screen
Align : Center
Style : Normal

[Field : Bank Account DetailTodt]

Use : Date Field 
Set as : ##SVToDate
Width : 45% Screen
Align : Center
Style : Normal 


[Part : Bank Account Details Report]

Line : Bank Account DetailscolumnTitles,Bank Account DetailsInfo
Repeat : Bank Account DetailsInfo : SKCcollection

Scroll : Both
Common Border : Yes
Float : Yes

Bottom Line:SatCOlTotals
Total :Opbal, Depamt, Witamt, Clbal

[Line : Bank Account DetailscolumnTitles]

Border : Column Titles

Fields : Serial No1., Bankname, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch

Local : Field : SerialNo1. : Set as : "SNo." 
Local : Field : SerialNo1. : Line : 0
Local : Field : Bankname : Set as : "Bank Name"
Local : Field : Bankname : Line : 0
Local : Field : Opbal : Set as : "Opening Balance"
Local : Field : Depamt : Set as : "Deposit Amt"
Local : Field : Witamt : Set as : "Withdrawn Amt"
Local : Field : Clbal : Set as : "Closing Balance"
Local : Field : Accno : Set as : "Account No."
Local : Field : Nameone : Set as : "1st Account Name"
Local : Field : Nametwo : Set as : "2nd Account Name"
Local : Field : Ifsc : Set as : "IFSC Code"
Local : Field : Micr : Set as : "MICR Code"
Local : Field : Brnch : Set as : "Branch"

Local : Field : Default : Type : String
Local : Field : Default : Style : Normal Bold 
Local : Field : Default : Align : Center


[Line : Bank Account DetailsInfo]

Fields : Serial No1., Bankname1, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch
Border : Thin Bottom
Local : Field : Default : Color : "Black"


[Line: SatCOlTotals]

Use : Bank Account DetailscolumnTitles

Local : Field : SerialNo1. : Set as: "" 
Local : Field : Bankname1 : Set as: "Grand Total"
Local : Field : Opbal : Set as: $$Total:Opbal
Local : Field : Depamt : Set as: $$Total:Depamt
Local : Field : Witamt : Set as: $$Total:Witamt
Local : Field : Clbal : Set as: $$Total:Clbal
Local : Field : Accno : Set as: ""
Local : Field : Nameone : Set as: ""
Local : Field : Nametwo : Set as: ""
Local : Field : Ifsc : Set as: ""
Local : Field : Micr : Set as: ""
Local : Field : Brnch : Set as: ""

[Field : SerialNo1.]

Use : Number Field
Set as : $$Line
Width : 3% Screen
Style : Normal
Align : Center
Border : Thin Left

[Field : Bankname1]

Use : Name Field
Set as : $Name
Width : 18% Screen
Style : Normal
Border : Thin Left

[Field : Opbal]

Use : Amount Field
Set as : $BSOpening
Width : 8% Screen
Style : Normal
Border : Thin Left

[Field : Depamt]

Use : Amount Field
Set as : $BSDebits
Width : 8% Screen
Style : Normal
Border : Thin Left

[Field : Witamt]

Use : Amount Field
Set as : $BSCredits
Width : 8% Screen
Style : Normal
Border : Thin Left

[Field : Clbal]

Use : Amount Field
Set as : $BSClosing
Width : 8% Screen
Style : Normal
Border : Thin Left


[Field :Accno]

Use : Short Name Field
Set as : $BankDetails
Width : 10% Screen
Style : Normal
Border : Thin Left



[Field : Nameone]

Use : Name Field
Set as : $AccountHolder1st
Width : 10% Screen
Style : Normal
Border : Thin Left



[Field : Nametwo]

Use : Name Field
Set as : $AccountHolder2nd
Width : 8% Screen
Style : Normal
Align : Center
Border : Thin Left

































[Field : Ifsc]

Use : Name Field
Set as : $IFSC
Width : 7% Screen
Style : Normal
Border : Thin Left 

[Field : Micr]

Use : Name Field
Set as : $MICR
Width : 6% Screen
Style : Normal
Border : Thin Left

[Field :Brnch]

Use : Name Field
Set as : $BankBranchName
Width : 6% Screen
Style : Normal
Border : Thin Left Right



















































































[Collection : SKCcollection]

Type : Ledger 
Child Of : $$GroupBank
Filter : SKCFilter
Belongs To : Yes

[System : Formula]
SKCFilter : $OpeningBalance > 0 OR $BSDebits > 0

टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

Tally Chapter 153 TDL for Custom List of Stock Item By Rajiv Mishra Computer Class

-
चित्र
  Few lines are missing Here. Watch the full video for full code.   Use            : ExtractAlias Collection     Source Collection    : Stock Item Src     Collection        : StockItem PartNo With Closing     Title               : $$LocaleString:"List of Items                                     Stock Qty     LastSale Price "         Fetch               : Name, VchStkItmBalance,LastSalePrice,ClosingBalance     Set as             : $FirstName     Keep Source        : ().     Client Only        : Yes     Format          : $VchStkItmBalance...
Read more »

Tally Chapter 130 TDL for Stamp & Signature By Rajiv Mishra Computer Class

-
चित्र
  Few lines of the code is missing. pls watch the video for full coding. Add: Right Parts: EXPSMPSignature2 [Part: EXPSMPSignature1] ;;Width: 100% page Horizontal Alignment:Right Vertical:No Lines : EXPINV Logo1 Graph Type : "C:\Users\user\Desktop\tdl image.jpg" Height : 1.00 Cm Width : 10.80 Cm [Line: EXPINV Logo1] Field : EXPINV Logo1 [Field: EXPINV Logo1] Set as : "Authorized Signatory" [Part:EXPSMPSignature2] Border:ll Vertical:No Horizontal Alignment:Right Width:20% Page Right Part:EXPSMPSignature1 Width:70% Page Width:50% Page
Read more »

Tally Chapter 105 TDL for Receipt contra Payment BULK Entry by Rajiv Mishra Computer Class

-
चित्र
 TDL CODE --------------TDL CODE STARTS HERE------------------------ [#Menu: Gateway of Tally] Add : Item : "Bulk Pay/ Rec/ Contra Entry" : Alter : JennyPayment EntryRpt [Report : JennyPayment EntryRpt] Form : JennyPayment EntryFrm Title : $$LocaleString:"Bulk Payment Entry" Object : Company [Form : JennyPayment EntryFrm] Part : Form SubTitle, JennyPayment DrLedPrt;JennyPayment CrLedPrt, JennyPayment DrLedPrt Width : 100% Page Height : 100% Page Space Left : 0.25 Space Right : 0.25 Horizontal Align: Left Local : Field : Form SubTitle : Info : "Bulk Payment / Receipt / Contra Entry" On : Form Accept : yes : Form Accept On : Form Accept : yes : Call : CphSale BulkAutoEntry ;; Sales Credit Part ;; ;;------------------------------------------------------------------------------------------ ; [Part : JennyPayment CrLedPrt] ; ; Line : JennyPayment CrLedLne;,JennyPayment SalesLedName ; ; [Line : JennyPayment CrLedLne] ; ; Field : Medium Prompt, JennyPayment CrLed...
Read more »