[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
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें