कुल पेज दृश्य

शुक्रवार, 14 जनवरी 2022

Tally Chapter 123 TDL for DayBook in Column with all voucher Types By Rajiv Mishra Computer Class

 



Few lines are Missing here. Pls Watch the chapter video.



[Form :Column Day Book]

Part :daybookhead,daybookhead1, Column Day Book ;;,daybookhead2


bottom Part : daybookbottam

Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure


Background : LightOrange



[Part : daybookhead]

Line :daybookhead

[Line :daybookhead]

Field : Simple Field

;Local : Field : Simple Field : Set As : ". Coulmer Day Book on " + $$String:##SVCurrentDate


Local : Field : Simple Field : Set As : " Coulmer Day Book on " + $$String:##SVFromDate +" to " + $$String:##SVToDate

Local : Field : Simple Field : Style : Normal Bold

Local : Field : Simple Field : Align : Centre

[Part : daybookhead1]

Use : Column Day Book

Delete : Repeat

Delete : Scroll

Border : ColumnTitles

Local : Field : Default : Type : string

Local : Field : My Voucher Date : Set As : "Date"

Local : Field : MyVoucherParty: Set As : "Particular"

Local : Field : MyVchNo : Set As : "Voucher No"

Local : Field : MyVchType : Set As : "Voucher Type"

Local : Field : MEBNo : Set As : "Narration"

Local : Field : MyVchAmount0 : Set As : "Contra"

Local : Field : MyVchAmount : Set As : "Sales"

Local : Field : MyVchAmount1 : Set As : "Receipt"

Local : Field : MyVchAmount2 : Set As : "Payment"

Local : Field : MyVchAmount3 : Set As : "Debit Note"

Local : Field : MyVchAmount4 : Set As : "Credit Note"

Local : Field : MyVchAmount5 : Set As : "Journal"

Local : Field : MyVchAmount6 : Set As : "Purchase"

Local :Field : Default : Style : Large Bold

Local: Field: Default: Align: Center

Local: Field: Default:Background: Yellow



[Part :Column Day Book]

Line : Column Day Book

Repeat :Column Day Book :My Voucher Rep Collection

tOTAL : MyVchAmount0,MyVchAmount,MyVchAmount1,MyVchAmount2,MyVchAmount3,MyVchAmount4,MyVchAmount5,MyVchAmount6

Scroll : Vertical

[Line :Column Day Book]

Field :My Voucher Date,MyVoucherParty,MyVchNo,MyVchType,MEBNo


Right Field : MyVchAmount0,MyVchAmount,MyVchAmount1,MyVchAmount2,MyVchAmount3,MyVchAmount4,MyVchAmount5,MyVchAmount6

Option : Alter On Enter


[Field :My Voucher Date]

Use : Short Date Field

Set As : $Date

Border : Thin Right


[Field : MyVoucherParty]


Use : NAme Field

Set As : $LedgerName

Width : 35

Border : Thin Right

Alter : Voucher





[Field : MyVchNo]

Use : NAme Field

Set As : $VoucherNumber

Width : 18

Border : Thin Right


[Field : MyVchType]

Use : Name Field

Set As : $VoucherTypeName

Border : Thin Right

Width : 15

[Field : MEBNo]

Use : Name Field

Set As : $Narration

Width : 60

Border : Thin Right

Style : Normal

Set Always : Yes


[Field : MyVchAmount0]

Use : Amount Field


Set As :if $VoucherTypeName CONTAINS "Con" then $Amount else ""

Format : "DrCr"

Border : Thin Right

[Field : MyVchAmount]

Use : Amount Field


Set As :if $VoucherTypeName CONTAINS "Sale" then $Amount else ""

Format : "DrCr"

Border : Thin Right

[Field : MyVchAmount1]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "Rec" then $Amount else ""

Border : Thin Right

[Field : MyVchAmount2]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "pay" then $Amount else ""

Border : Thin Right

[Field : MyVchAmount3]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "deb" then $Amount else ""

Border : Thin Right

[Field : MyVchAmount4]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "Cre" then $Amount else ""

Border : Thin Right

[Field : MyVchAmount5]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "Jou" then $Amount else ""

Border : Thin Right

[Field : MyVchAmount6]

Use : Amount Field

Set As :if $VoucherTypeName CONTAINS "Pur" then $Amount else ""

[Collection : My Voucher Rep Collection]

Type : Vouchers

Fetch : Date,Amount,VoucherTypeName,PArtyLedgerName,VoucherNumber,Narration


*/

[Part: daybookbottam]

Lines : daybookTotalLine

[Line: daybookTotalLine]

Use : Column Day Book

Local: Field: Default : Style : Small Bold

Local: Field: Default:Background: Green

Local: Field: Default: Type: String

Local: Field: Default: Align: Center

Local : Field : MyVoucherParty: Set As : "Total"

Local : Field : MyVoucherParty: Color: Blue

Local : Field : MyVchNo : Set As : "Day Book"

Local : Field : MyVchNo: Color: Blue

Local : Field : MyVchType : Set As : "Amount"

Local : Field : MyVchType : Color: Blue

Local : Field : MyVchAmount0 :Set As: $$Total:MyVchAmount0

Local : Field : MyVchAmount : Set As : $$Total:MyVchAmount

Local : Field : MyVchAmount1 : Set As : $$Total:MyVchAmount1

Local : Field : MyVchAmount2 : Set As : $$Total:MyVchAmount2

Local : Field : MyVchAmount3 : Set As : $$Total:MyVchAmount3

Local : Field : MyVchAmount4 : Set As : $$Total:MyVchAmount4

Local : Field : MyVchAmount5 : Set As : $$Total:MyVchAmount5

Local : Field : MyVchAmount6 : Set As : $$Total:MyVchAmount6

Border : Totals



[#menu: Gateway of Tally]


Button : NewTDLUpdate


[Button : NewTDLUpdate]

Title : TDL Update

Key : f6

Action : Browse URL : www.youtube.com/channel/UCytrmo9IC-3bULlhKpUHIpg


[#menu: Gateway of Tally]


Button : TDLCODEFILE


[Button : TDLCODEFILE]

Title : Tally TDL File

Key : f7

Action : Browse URL : www.youtube.com/channel/UCytrmo9IC-3bULlhKpUHIpg





कोई टिप्पणी नहीं:

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

 [#Form: Master Accounting Form] Delete: Bottom Buttons : Master Group, Master Ledger, Master VchType, Blank Button ;, Master Company Operat...