Tally Chapter 214 TDL to SORT Pending Biils By Rajiv Mishra Computer Class

 

Few lines are Missing here.

Pls Watch the Full video to get full coding

Sub Title: $$LocaleString:"Name", $$LocaleString:"Date", $$LocaleString:"Balance", $$LocaleString:"Date Number"

Delete : Format

FullHeight : Yes

Align : Right

Add: Format : $$Name, 14

Add: Format : $BillDate, 8 : Universal Date

Add: Format : $BaseClosing : "AllSymbols, DrCr"

Add: Format : $FinalDateNumbers

[system : formula]

FormulaMonth : If $$MonthOfDate:$BillDate <=2 then $$MonthOfDate:$BillDate+13 else $$MonthOfDate:$BillDate+1

FormulaYear : If $$MonthOfDate:$BillDate <=2 then $$YearOfDate:$BillDate-1 else $$YearOfDate:$BillDate

FormulaDay : $$DayOfDate:$BillDate

FormulaDateToNum : (1461*$FormulaYear)/4+(153*$FormulaMonth)/5+$FormulaDay ;;;(146097*$FormulaYear)/400+(153*$FormulaMonth+8)/5+$FormulaDay

FinalDateNumbers : $$Round:$FormulaDateToNum:1

[#Line: VCHBILL MainLine]

Add : Field : Before : VCHBILL Name : VCHBILL NameTemp

[Field : VCHBILL NameTemp]

Use : Name field

Set As : If not $$InCreateMode Then $$Table:VCHBILLNameTemp:$Name else $$Value

Table : MyNewBillColl : $$InCreateMode and $BillType = $$SysName:AgstRef

Table : MyNewBillColl, BillRefBlankColl : not $$InCreateMode and $BillType = $$SysName:AgstRef

Show Table : Always

Set Always : Yes

Dynamic : ""

Width : @@VCHShortNameWidth

Skip : $BillType != $$SysName:AgstRef

Inactive : $BillType != $$SysName:AgstRef

[#Field: VCHBILL Name]

Set As : If not $$IsEmpty:#VCHBILLNameTemp then $$Table:VCHBILLNameTemp:$Name else $$ExclEvaluate:$$FnSetBillName

[Collection : BillRefBlankColl]

Title : "Blank"

List Name : " "

[Collection : MyNewBillColl]

Use : Pending Bills

Delete : Sub Title

Add : Sub Title: $$LocaleString:"Date Number", $$LocaleString:"Name", $$LocaleString:"Date", $$LocaleString:"Balance"

Delete : Format

FullHeight : Yes

Add : Format : $FinalDateNumbers, 10 ;;FinalDateNumbers, 10

Add : Format : $$Name, 14

Add : Format : $BillDate, 8 : Universal Date

Add : Format : $BaseClosing : "AllSymbols, DrCr"

Client Only : Yes

Keep Source : ...

Option : ShowBillFnlBlnc : ##VchShowBillFnlBlnc

Delete : Sort

Add : Sort : @@default : $FinalDateNumbers, $$Number:$Name

[#Line: VCHBILL CTLineOne]

Local : Field : VCH ShortTitle : Width : @@VCHShortNameWidth*2

[#Line: VCHBILL CTLineTwo]

Local : Field : VCH ShortTitle : Width : @@VCHShortNameWidth*2

[#Line: VCHBILL CTLineThree]

Local : Field : VCH ShortTitle : Width : @@VCHShortNameWidth*2

[#Line: VCHBILL ExplLine]

Add : Field : Before : VCHBILL Name : VCHBILL NameTemp