Tally Chapter 238 TDL for Multi Reports Multi Prints in Sales Voucher By Rajiv Mishra Computer Class
.jpg)
Few lines are missing here.
Pls watch the full video to get full coding.
[#Form : Sales Color];; Add Print in SALES
Add : Print : ""
Add : Button :GatePass
[Button : GatePass]
Action :print Report:GatePass
Key :ctrl+F6
[Report: GatePass]
Use : Voucher
PrintSet : Report SubTitle : " "
PrintSet : SVPrintCopies : 1
Delete : Print : VCHPrintConfigure
Delete : Set
Form : GatePass
[Form : GatePass]
Parts : GatePassTopPart,GatePassTopPart1,GatePassTopPart2,GatePassBodyPart,GatePassLastPart
Width : 240 mm
Height : 320 mm
Space left : 20 mm
Space Top : 20 mm
;;-----------------------------------------------------------------------------------------------------------------------
[Part : GatePassTopPart]
Line : GatePassTopPartLine
Height : 15 mm
Width : 220 mm
[Line : GatePassTopPartLine]
Space Top : 3 mm
Fields : GatePassTopPartLineField
Right Field: GatePassTopPartLine1F3
[Field : GatePassTopPartLineField]
Set as : "Rajiv Mishra Company"
Style : MyStyleGat
Full Width : Yes
Align : Center
[Field : GatePassTopPartLine1F3]
Set as : @MyIndianTSet
Style :normal bold
Align :center
Width: 25 MM
MyIndianTSet :if $$SetNo = 1 then "(Original) " else +
if $$SetNo = 2 then "(Duplicate)" else +
if $$SetNo = 3 then "(Triplicate) " else +
"(Extra) "
;;=======================================================================================================================
[Part : GatePassTopPart1]
Left Part : GatePassTopPartin1.1
Right Part : GatePassTopPartin1,GatePassTopPartin2
Height : 28 mm
Width : 220 mm
Border : Thin Cover
[Part:GatePassTopPartin1.1]
Line : OurproductLineChem1
Width : 35 mm
Height : 20 mm
Space Top : 5 mm
Space Left : 5 mm
Image : OurproductImageChem1
[Resource: OurproductImageChem1]
Source : "C:\users\user\desktop\aa.jpg.jpg"
Resource Type : jpeg
[Line: OurproductLineChem1]
Field: OurProductChem1
[Field: OurProductChem1]
Set as: ""
Space Left : 5 mm
[Part:GatePassTopPartin1]
Line : OurproductLineChem1.1
Width : 30 mm
Height : 19 mm
Space Top : 5 mm
Space Left : 5 mm
Space Right: 5 mm
Image : OurproductImageChem1.1
[Resource: OurproductImageChem1.1]
Source : "C:\users\user\desktop\aa.jpg"
Resource Type : jpeg
[Line: OurproductLineChem1.1]
Field: OurProductChem1.1
[Field: OurProductChem1.1]
Set as: ""
Space Left : 5 mm
[Part:GatePassTopPartin2]
Line : GatePassTopPartin2L1,GatePassTopPartin2L2
Height : 28 mm
Width : 110 mm
Border : Thin Left
[Line : GatePassTopPartin2L1]
Field : GatePassTopPartin2L1F1
Border : Thin Bottom
Space Top : 5 mm
[Field : GatePassTopPartin2L1F1]
Set as : "GATE PASS"
Style : MyStyleGat
Align : Center
Full Width: yes
[Line : GatePassTopPartin2L2]
Field : GatePassTopPartin2L2F1,GatePassTopPartin2L2F2,GatePassTopPartin2L2F3,GatePassTopPartin2L2F4
Border : Thin Bottom
Height : 9 MM
Space Top: 3 mm
[Field : GatePassTopPartin2L2F1]
Set as : "Invoice No.:"
Style : Large Bold
Width : 40 mm
Space Left : 5 mm
[Field : GatePassTopPartin2L2F2]
Set as : $VoucherNumber
Style : Large
Width : 30 mm
[Field : GatePassTopPartin2L2F3]
Set as : "Date. :"
Style : Large Bold
Width : 30 mm
[Field : GatePassTopPartin2L2F4]
Set as : $Date
Style : Large
Width : 30 mm
;;=======================================================================================================================
[Part : GatePassTopPart2]
Left Part : GatePassTopPart2Innr
Right Part : GatePassTopPart2Innr1
Height : 40 mm
Width : 220 mm
Border : Thin Left Right
[Part : GatePassTopPart2Innr]
Line : GatePassTopPart2InnrL1,GatePassTopPart2InnrL2,GatePassTopPart2InnrL3,GatePassTopPart2InnrL4,GatePassTopPart2InnrL5
Height : 40 mm
Width : 65 mm
[Line : GatePassTopPart2InnrL1]
Field : GatePassTopPart2InnrL1F1
Space Top : 5 mm
[Field : GatePassTopPart2InnrL1F1]
Set as : "Rajiv Mishra Company LIMITED"
Style : Large Bold
Full Width: yes
[Line : GatePassTopPart2InnrL2]
Field : GatePassTopPart2InnrL2F1
Space Top : 2 mm
[Field : GatePassTopPart2InnrL2F1]
Set as : "Plot No. IIPL, D-8, 1st Floor,"
Style : Normal
Width : 65 mm
[Line : GatePassTopPart2InnrL3]
Field : GatePassTopPart2InnrL3F1
[Field : GatePassTopPart2InnrL3F1]
Set as : "Karawal Nagar Industrial Area, Delhi"
Style : Normal
Width : 65 mm
[Line : GatePassTopPart2InnrL4]
Field : GatePassTopPart2InnrL4F1
[Field : GatePassTopPart2InnrL4F1]
Set as : ""
Style : Normal
Width : 65 mm
[Line : GatePassTopPart2InnrL5]
Field : GatePassTopPart2InnrL5F1
[Field : GatePassTopPart2InnrL5F1]
Set as : ""
Style : Normal
Width : 65 mm
[Part : GatePassTopPart2Innr1]
Line : GatePassTopPart2Innr1L1,GatePassTopPart2Innr1L2
Bottom Line: GatePassTopPart2Innr1L3,GatePassTopPart2Innr1L4,GatePassTopPart2Innr1L5,GatePassTopPart2Innr1L6
Height : 40 mm
Width : 130 mm
Border : Thin Left
Repeat : GatePassTopPart2Innr1L2:Address
[Line : GatePassTopPart2Innr1L1]
Field : GatePassTopPart2Innr1L1F1,GatePassTopPart2Innr1L1F2
[Field : GatePassTopPart2Innr1L1F1]
Set as : "To ,"
Style : Large Bold
Width : 10 mm
[Field : GatePassTopPart2Innr1L1F2]
Set as : $PartyName
Style : Large Bold
Width : 100 mm
[Line : GatePassTopPart2Innr1L2]
Field : GatePassTopPart2Innr1L2F1
[Field : GatePassTopPart2Innr1L2F1]
Set as : $Address
Style : Normal
Space Left : 10 mm
Width : Width : 100 mm
[Line : GatePassTopPart2Innr1L3]
Field : GatePassTopPart2Innr1L3F1,GatePassTopPart2Innr1L3F2
Border : Thin Top
[Field : GatePassTopPart2Innr1L3F1]
Use : Short Prompt
Set as : "VAT TIN No."
Style : Large Bold
Width : 30 mm
[Field : GatePassTopPart2Innr1L3F2]
Set as : $VATTINNumber:Ledger:$PartyLedgerName
Style : Large
Width : 100 mm
[Line : GatePassTopPart2Innr1L4]
Field : GatePassTopPart2Innr1L4F1,GatePassTopPart2Innr1L4F2
[Field : GatePassTopPart2Innr1L4F1]
Use : Short Prompt
Set as : "CST TIN No."
Style : Large Bold
Width : 30 mm
[Field : GatePassTopPart2Innr1L4F2]
Set as : $InterStatestNumber:Ledger:$PartyLedgerName
Style : Large
Width : 100 mm
[Line : GatePassTopPart2Innr1L5]
Field : GatePassTopPart2Innr1L5F1,GatePassTopPart2Innr1L5F2
[Field : GatePassTopPart2Innr1L5F1]
Use : Short Prompt
Set as : "Vehicle No :"
Style : Large Bold
Width : 30 mm
[Field : GatePassTopPart2Innr1L5F2]
Set as : $BasicShipVesselNo
Style : Large
Width : 90 mm
[Line : GatePassTopPart2Innr1L6]
Field : GatePassTopPart2Innr1L6F1,GatePassTopPart2Innr1L6F2
[Field : GatePassTopPart2Innr1L6F1]
Use : Short Prompt
Set as : "Transport :"
Style : Large Bold
Width : 30 mm
[Field : GatePassTopPart2Innr1L6F2]
Set as : $BasicShippedBy
Style : Large
Width : 90 mm
;;======================================================================================================================
[Part : GatePassBodyPart]
Height : 180 mm
Width : 220 mm
Border : Thin Cover
Line : GatePassBodyPartL1,GatePassBodyPartL2
Bottom Line : GatePassBodyPartL3
Common Border: Yes
Repeat : GatePassBodyPartL2:InventoryEntries
Total : GatePassBodyPartL2F4,GatePassBodyPartL2F4.1,GatePassBodyPartL2F5
[Line : GatePassBodyPartL1]
Field: GatePassBodyPartL1F1,GatePassBodyPartL1F3
Right Field: GatePassBodyPartL1F4,GatePassBodyPartL1F4.1,GatePassBodyPartL1F5
Height : 8 mm
Space Top: 2 mm
Border : Thin Bottom
[Field: GatePassBodyPartL1F1]
Set as : "Sr. No."
Style : Normal Bold
Width : 15 mm
Align : Center
[Field: GatePassBodyPartL1F3]
Set as : "Item Description"
Style : Normal Bold
Width : 110 mm
Align : Center
[Field: GatePassBodyPartL1F4]
Set as : "Quantity"
Style : Normal Bold
Width : 35 mm
Align : Center
[Field: GatePassBodyPartL1F4.1]
Set as : "Qty (Board)"
Style : Normal Bold
Width : 25 mm
Align : Center
[Field: GatePassBodyPartL1F5]
Set as : "Value in Rs."
Style : Normal Bold
Width : 30 mm
Align : Center
[Line : GatePassBodyPartL2]
Field: GatePassBodyPartL2F1,GatePassBodyPartL2F3
Right Field: GatePassBodyPartL2F4,GatePassBodyPartL2F4.1,GatePassBodyPartL2F5
Height : 6 mm
[Field: GatePassBodyPartL2F1]
Set as : $$Line
Style : Normal
Width : 15 mm
Align : Center
Border : Thin Right
[Field: GatePassBodyPartL2F3]
Set as : $StockItemName
Style : Normal
Width : 110 mm
[Field: GatePassBodyPartL2F4]
Use : Qty Field
Set as : $BilledQty
Style : Normal
Width : 35 mm
Align : Right
Border : Thin Left right
[Field: GatePassBodyPartL2F4.1]
Use : Number Field
Align : Right
Width : 25 mm
Style : Normal
Set as : $$String:$ActualQty:Symbol,ShortForm,Secondary
[Field: GatePassBodyPartL2F5]
Set as : ""
Style : Normal
Width : 30 mm
Align : Right
Border : Thin Left
[Line : GatePassBodyPartL3]
Field: GatePassBodyPartL3F1,GatePassBodyPartL3F2,GatePassBodyPartL3F3
Right Field: GatePassBodyPartL3F4,GatePassBodyPartL3F4.1,GatePassBodyPartL3F5
Height : 8 mm
Border : Thin Top
Space Top: 3 mm
[Field: GatePassBodyPartL3F1]
Set as : ""
Style : Normal
Width : 15 mm
Align : Center
[Field: GatePassBodyPartL3F2]
Set as : ""
Style : Normal
Width : 90 mm
Align : Center
[Field: GatePassBodyPartL3F3]
Set as : "TOTAL"
Style : Normal Bold
Width : 20 mm
Align : Right
Border : Thin Bottom
[Field: GatePassBodyPartL3F4]
Use : Qty Field
Set as : $$Total:GatePassBodyPartL2F4
Style : Large Bold
Width : 35 mm
Align : Right
Border : Thin Bottom
[Field: GatePassBodyPartL3F4.1]
Use : Number Field
Set as : $$Total:GatePassBodyPartL2F4.1
Style : Large Bold
Width : 25 mm
Align : Right
Border : Thin Bottom
[Field: GatePassBodyPartL3F5]
Use : Amount Field
Set as : $Amount
Style : Large Bold
Width : 30 mm
Align : Right
Border : Thin Bottom
;;======================================================================================================================
[Part : GatePassLastPart]
Line : GatePassLastPartL1,GatePassLastPartL2
Height : 17 mm
Border : Thin Box
Width : 220 mm
[Line : GatePassLastPartL1]
Field : GatePassLastPartL1F1,GatePassLastPartL1F2
Height : 8 mm
Border : Thin Bottom
[Field : GatePassLastPartL1F1]
Set as : "Prepared by :"
Style : Large Bold
Width : 80 mm
Border : Thin Right
[Field : GatePassLastPartL1F2]
Set as : "Authorising Person :"
Style : Large Bold
Width : 60 mm
[Line : GatePassLastPartL2]
Field : GatePassLastPartL2F1,GatePassLastPartL2F2
Height : 8 mm
[Field : GatePassLastPartL2F1]
Set as : "Signature :"
Style : Large Bold
Width : 80 mm
Border : Thin Right
[Field : GatePassLastPartL2F2]
Set as : "Signature :"
Style : Large Bold
Width : 60 mm
;;======================End Of File =========================
;;-------------------FORMAT 2-----------------------
[#Form : Sales Color]
Add : Button :Cash Sales Report
[Button : Cash Sales Report]
Title : Cash Sales
Key :ctrl+F1
Action :Display:Cash Sales Report
[Report: Cash Sales Report]
Form : CashsalesReport
;Object : Company
[Form: CashsalesReport]
Part : CashsalesReportTitle, CashsalesReportDt1
height : 100% Screen
Width: 100% Screen
[Part:CashsalesReportTitle]
Line: CashsalesReportTitle
[Line:CashsalesReportTitle]
Field:CashsalesReportTitle
[Field:CashsalesReportTitle]
Use: name field
Set as: "Cash Sale Report"
Full Width:Yes
Style: Small Bold
Align:Center
[Part:CashsalesReportDt1]
Line: cashsalestitleline,CashsalesDtLine
Repeat:CashsalesDtLine:Cashsalescoll
Common Border:Yes
Scroll:Vertical
Border : Thin Left Right
[Collection:cashsalescoll]
Type: vouchers:vouchertype
Child Of:$$VchTypeSales
Belongs To: Yes
Fetch: date, vouchernumber, basicbuyername, amount
Filter:onlycashEntries
[System:Formulas]
onlycashEntries: $$IsLedOfGrp:$partyledgername:$$GroupCash
[Line:cashsalestitleline]
Field: cs sno, cs billdate, cs billno, cs partyname, cs totalbillamt
Local:Field: cs sno:Set as: "S.no"
Local:Field:cs billdate:Set as: "bill Date"
Local:Field:cs billno:Set as: "Bill No."
Local:Field:cspartyname:Set as: "Party Name"
Local:Field:cs totalbillamt:Set as: "Total Bill Amount"
Border : Thin Left Right bottom
[Line:CashsalesDtLine]
Field: cs sno, cs billdate, cs billno, cs partyname, cs totalbillamt
[Field: cs sno]
Use:number Field
Set as: $$Line
Border : Thin Left Right bottom
[Field: cs billdate]
Use: uni Date Field
Set as: $date
Border : Thin Left Right bottom
[Field:cs billno]
Use:name Field
Set as:$vouchernumber
Border : Thin Left Right bottom
[Field: cs partyname]
Use:name field
Set as:$basicbuyername
Border : Thin Left Right bottom
[Field: cs totalbillamt]
Use:amount Field
Set as: $amount
Border : Thin Left Right bottom
;;--------------------FORMAT 3--------------------
[#Menu:Gateway of Tally]
Add:Button:LedButton, BnkButton, OSRButton, OSPButton
[#Menu:Display Menu]
Add:Button:LedButton, BnkButton, OSRButton, OSPButton
[#Form:Sales Color]
Add:Button:LedButton, BnkButton, OSRButton, OSPButton
[Key:LedButton]
Key:Alt + L
Title:$$LocaleString:"Show Ledgers"
Action: Display Collection : Ledger Vouchers
[Key:BnkButton]
Key:Alt + c
Title:$$LocaleString:"Show Cash/Bank"
Action:Display:Bank Group Summary
[Key:OSRButton]
Key:Alt + R
Title:$$LocaleString:"Receivables"
Action:Display:Bills Receivable
[Key:OSPButton]
Key:Alt + p
Title:$$LocaleString:"Payables"
Action:Display:Bills Payable
;;-------------------------TRANSPORT---------------------
टिप्पणियाँ
एक टिप्पणी भेजें