Few lines are missing here. Watch the full video for complete code.
[#Menu: Gateway Of Tally]
Add : Item : Paid & Pending Bills: Display: Paid n Pending Bills
[Report : Paid n Pending Bills]
Variable : SVFromDate, SVToDate
Set : SVfromDate : ##SVDate
Set : SVToDate : ##SVCurrentDate
Form : Paid n Pending Bills
[Form : Paid n Pending Bills]
Parts : DSp Company Name, DSP Company Address
Height : 100% Screen
Width : 100% Screen
BackGround : Light Yellow
Space Top : If $$InPrintMode Then 0.5 Else 0 inches
Button : PrintButton, ExportButton,F2 ChangePeriod
Part : Paid n Pending Bills
Local : Part: DSP Company Address : invisible : No
[Part : Paid n Pending Bills]
Parts: Cleared Bills, Uncleared Bills
[Part : Cleared Bills]
Space Bottom : 0.2 inch
Line : Cleared BillsHead1,Cleared BillsHead2,Cleared Bills
Repeat : Cleared Bills : List of Cleared Bills
Border: Thin Box
Scroll : Both
Common Border : Yes
Float : Yes
[Line : Cleared BillsHead1]
Space Bottom : 0.2 inch
Border: Full Thin Bottom
Use:Cleared BillsHead2
Local : Field : Date2 : Set as: ""
Local : Field : Ref1 : Set as: ""
Local : Field : Party1 : Set as:"List of Cleared Bills"
Local : Field : Amount1 : Set as: ""
[Line : Cleared BillsHead2]
Border: Full Thin Bottom
Field : Cleared BillsHead2
[Field : Cleared BillsHead2]
Fields:Date2,Ref1,Party1,Amount1
[Field : Date2]
Use : NameField
Set as : "Bill Date"
Style :Normal Bold
[Field : Ref1]
Use : NameField
Set as : "Ref No."
Style :Normal Bold
[Field : Party1]
Use : NameField
Set as : "Party Name"
Style :Normal Bold
[Field : Amount1]
Use : NameField
Set as : "Bill Amount"
Style :Normal Bold
Align:Right
[Part : Uncleared Bills]
Space Bottom : 0.2 inch
Line :UnCleared BillsHead1,UnCleared BillsHead2, Uncleared Bills
Repeat : Uncleared Bills : List of Uncleared Bills
Border: Thin Box
Scroll : Both
Common Border : Yes
Float : Yes
[Line : UnCleared BillsHead1]
Space Bottom : 0.2 inch
Border: Full Thin Bottom
Use : UnCleared BillsHead2
Local : Field : Date3 : Set as: ""
Local : Field : Ref2 : Set as: ""
Local : Field : Party2 : Set as:"List of UnCleared Bills"
Local : Field : Amount2 : Set as: ""
Local : Field : Amount3 : Set as: ""
[Line : UnCleared BillsHead2]
Border: Full Thin Bottom
Field : UnCleared BillsHead2
[Field : UnCleared BillsHead2]
Fields:Date3,Ref2,Party2,Amount2,Amount3
[Field : Date3]
Use : NameField
Set as : "Bill Date"
Style :Normal Bold
[Field : Ref2]
Use : NameField
Set as : "Ref No."
Style :Normal Bold
[Field : Party2]
Use : NameField
Set as : "Party Name"
Style :Normal Bold
[Field : Amount2]
Use : NameField
Set as : "Op Bill Amount"
Style :Normal Bold
Align:Right
[Field : Amount3]
Use : NameField
Set as : "Cl Bill Amount"
Style :Normal Bold
[Line : Cleared Bills]
Field : Cleared Bills
[Field : Cleared Bills]
Fields : BILLDate1, BILLRef1, BILLParty1,BILLOp1
[Field: BILLDate1]
Use : UniDateField
Set as : $BillDate
Style : Normal Bold
Border: Thin Right
[Field: BILLRef1]
Use : ShortNameField
Set as : $Name
Width : 12
Style : Normal
Border: Thin Right
[Field: BILLParty1]
Use : NameField
Set as : $DSPAccName:Ledger:$Parent
Border: Thin Right
[Field: BILLOp1]
Use : AmountField
Type : Amount
Set as : $OpeningBalance
Style : Normal Bold
Align : Right
[Line : Uncleared Bills]
Field : Uncleared Bills
[Field : Uncleared Bills]
Fields : BILLDate2, BILLRef2, BILLParty2,BILLOp2,BILLCl2
[Field: BILLDate2]
Use : UniDateField
Set as : $BillDate
Style : Normal Bold
Border: Thin Right
[Field: BILLRef2]
Use : ShortNameField
Set as : $Name
Width : 12
Style : Normal
Border: Thin Right
[Field: BILLParty2]
Use : NameField
Set as : $DSPAccName:Ledger:$Parent
Border: Thin Right
[Field: BILLOp2]
Use : AmountField
Type : Amount
Set as : $OpeningBalance
Style : Normal
Border: Thin Right
[Field: BILLCl2]
Use : AmountField
Type : Amount
Set as : $ClosingBalance
[Collection: List of Cleared Bills]
Type : Bill
Child Of : $$GroupSundryDebtors OR $$GroupSundryCreditors
Belongs To : Yes
Cleared : Yes
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें