Tally CHapter 92 TDL for Outstanding Bills Detailed Report by Rajiv Mishra Computer class

 



TDL FILE




  



TDL PLAYLIST : - https://youtube.com/playlist?list=PL3OwfzHiGFsAjgxYzZQBUtJ5btzC0dc51







NOTE:-  

3 lines of this TDL File is Missing, Please Watch the VIDEO Lesson for that line              


इस TDL FILE की  3 Lines  नही दी गै है, कृप्या  TALLY CHAPTER  90 VIDEO को जरुर देखे    



Variable : SVFromDate, SVToDate

Set : SVfromDate : ##SVDate

Set : SVToDate : ##SVCurrentDate

Form : Cleared And Uncleared Bills



[Form : Cleared And Uncleared 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 : Cleared And Uncleared Bills

Local : Part: DSP Company Address : invisible : No




[Part : Cleared And Uncleared 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


[Collection: List of UnCleared Bills]

Type : Bill

Child Of : $$GroupSundryDebtors OR $$GroupSundryCreditors

Belongs To : Yes

Cleared : No










टिप्पणियाँ

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

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

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

TDL CODE for New Column in Invoice by Rajiv Mishra Computer class