Tally Prime TDL File Video 2 CODE

-

 


[#Menu :Gate way of Tally]

Add :Button :Refresh TDL


[Button :Refresh TDL]

Title :"Refresh TDL"

Key :F5

Action :Refresh TDL


[System :Form keys]

Key :Refresh TDL


[System :Menu Keys]

Key :Refresh TDL


[#Form :Default]

Key :Refresh TDL




;;Rajiv Balance Sheet

[#Menu: Gate Way Of Tally]


Add : Item : Rajiv Balance Sheet : Display : Rajiv Balance Sheet

[Report: Rajiv Balance Sheet]


Use : DSP Template

; Set : SV From Date : ##SVFromDate ;;$$MonthStart:##SVCurrentDate

; Set : SV To Date : ##SVToDate ;;$$MonthEnd:##SVCurrentDate


[Form: Rajiv Balance Sheet]


Use : DSP Template

Part : Rajiv Balance Sheet

Width : 100% Page

Height : 100% Page


[Part: Rajiv Balance Sheet]


Line : Rajiv Balance Sheet,bd

Repeat:bd:ledgerout

Scroll : Both

[Line : Rajiv Balance Sheet]


Fields : partynem,Month Field

Repeat:Month Field: Monthcoll



[Field:partynem]

Use:name field

Set as:"Party Name"


[Line:bd]

Add:Field:bd,amtd

Repeat : amtd : Monthcoll

[Field:bd]

Use:name field

Set as:$na


[Field:amtd]

Use:amount field

Set as:$$amtfn:#bd:mad:DFrom:mad:DTo

DFrom : $$PeriodDateFrom

DTo : $$PeriodDateTo


[Function:amtfn]

Parameter : PartyName :String

Parameter : PerFrom :Date

Parameter : PerTo :Date

Variable : SVFromDate : Date

Variable : SVToDate : Date

Variable : RetAmt : Amount

Return : Amount


05: Log: ##PerFrom

06: Log: ##PerTo

08: Set : RetAmt : ($$AsAmount:0)

09: Log: ##RetAmt

01:Set:SVFromDate : ##SVFromDate

02:Set:SVToDate : ##PerTo


03:Set:RetAmt: ($$FilterAmtTotal:SaleVchsSum:SelLedName:$Amount) - ($$FilterAmtTotal:RecptVchsSum:SelLedName:$Amount)

07: Log: ##RetAmt

04: Return : ##RetAmt

[Collection: Rajiv Balance SheetLedCol]


Type : Ledger

Fetch: Name, ClosingBalance

Filter: SelLedName


[Collection: SaleVchs]


Type : Vouchers : VoucherType

Child Of : $$VchTypeSales


[Collection: SaleVchsSum]


Source Collection : SaleVchs

Walk : Ledger Entries


By : LedgerName : $LedgerName

By : Date : $..Date


Aggr Compute : Amount : Sum : $Amount

[Collection: RecptVchs]


Type : Vouchers : VoucherType

Child Of : $$VchTypeReceipt


[Collection: RecptVchsSum]


Source Collection : RecptVchs

Walk : Ledger Entries


By : LedgerName : $LedgerName

By : Date : $..Date


Aggr Compute : Amount : Sum : $Amount


[System: Formulae]


SelLedName : $LedgerName = ##PartyName


[Field:Month Field]


Use: Name Field

Set as : $MonthName

[Collection: Monthcoll]

Type : Period

Repeat : Month

ClientOnly : Yes

Compute : MonthName: $$FullMonthName:$$PeriodDateFrom

[Collection:ledgerout]

Type:ledger

Child Of:$$GroupSundryDebtors

Compute:na:$name

Compute:bal:$closingbalance

;; select $na,$bal from ledgerout

 


टिप्पणियाँ

एक टिप्पणी भेजें

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

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

-
चित्र
  Few lines are missing Here. Watch the full video for full code.   Use            : ExtractAlias Collection     Source Collection    : Stock Item Src     Collection        : StockItem PartNo With Closing     Title               : $$LocaleString:"List of Items                                     Stock Qty     LastSale Price "         Fetch               : Name, VchStkItmBalance,LastSalePrice,ClosingBalance     Set as             : $FirstName     Keep Source        : ().     Client Only        : Yes     Format          : $VchStkItmBalance...
Read more »

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

-
चित्र
TDL CODE For NEW COLUMN in INVOICE    NOTE:-   2 lines of this TDL File is Missing, Please Watch the VIDEO Lesson for those lines               इस TDL FILE की  2 Lines  नही दी गै है, कृप्या  TALLY CHAPTER  87 VIDEO को जरुर देखे       TDL PLAYLIST : - https://youtube.com/playlist?list=PL3OwfzHiGFsAjgxYzZQBUtJ5btzC0dc51 TDL CHAPTER 77:- https://youtu.be/fND31-N0ESc TDL CHAPTER 78:- https://youtu.be/hIAFXaOEdXE TDL CHAPTER 79:- https://youtu.be/PW4isAdC57w TDL CHAPTER 80:- https://youtu.be/hdPuzzIyIIw TDL CHAPTER 81:- https://youtu.be/1MNuLYCzQNs . TDL CHAPTER 82:- https://youtu.be/sdsaN-OW8WU TDL CHAPTER 83:- https://youtu.be/eYF6gkGJtJU TDL CHAPTER 84:- https://youtu.be/vWcjy55NfHo TDL CHAPTER 85:- https://youtu.be/2H9C7PWPlX4 TDL CHAPTER 86:- https://youtu.be/6KV-Ldflzp8 TDL CHAPTER 87:-https://youtu.be/PBKnm4MTuWk __________________________________________ ____________...
Read more »

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

-
चित्र
 TDL CODE --------------TDL CODE STARTS HERE------------------------ [#Menu: Gateway of Tally] Add : Item : "Bulk Pay/ Rec/ Contra Entry" : Alter : JennyPayment EntryRpt [Report : JennyPayment EntryRpt] Form : JennyPayment EntryFrm Title : $$LocaleString:"Bulk Payment Entry" Object : Company [Form : JennyPayment EntryFrm] Part : Form SubTitle, JennyPayment DrLedPrt;JennyPayment CrLedPrt, JennyPayment DrLedPrt Width : 100% Page Height : 100% Page Space Left : 0.25 Space Right : 0.25 Horizontal Align: Left Local : Field : Form SubTitle : Info : "Bulk Payment / Receipt / Contra Entry" On : Form Accept : yes : Form Accept On : Form Accept : yes : Call : CphSale BulkAutoEntry ;; Sales Credit Part ;; ;;------------------------------------------------------------------------------------------ ; [Part : JennyPayment CrLedPrt] ; ; Line : JennyPayment CrLedLne;,JennyPayment SalesLedName ; ; [Line : JennyPayment CrLedLne] ; ; Field : Medium Prompt, JennyPayment CrLed...
Read more »