Tally chapter 230 TDL for Auto to Manual Invoice Numbering By Rajiv Mishra Computer Class

-

 



few lines are Missing here.

Pls watch the full video to get full coding



[#Menu: Gateway of Tally]

 

 

add:item:"Auto To Manual Vourchar No":menu:Change Vch Number Type

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[Menu:Change Vch Number Type]

 

 

Item:"Auto To Manual Vourchar No":Execute:Add Vch To Other Field

 

 

 

 

 

 

 

 

[Report:Add Vch To Other Field]

 

 

Form:Add Vch To Other Field

 

 

Title:"Voucher Type"

 

 

 

 

 

 

 

 

[Form:Add Vch To Other Field]

 

 

Part:Add Vch To Other Field

 

 

On:Form Accept:Yes:Form Accept

 

 

On:Form Accept:Yes:Call:Save Vch Number:#AddVchToOtherField

 

 

 

 

 

[Part:Add Vch To Other Field]

 

 

Line:Add Vch To Other Field

 

 

 

 

 

 

 

 

 

 

 

[Line:Add Vch To Other Field]

 

 

Field:Medium Prompt,Add Vch To Other Field

 

 

Local:Field:Medium Prompt:Info:"Voucher Type"

 

 

 

 

 

[Field:Add Vch To Other Field]

 

 

Use:Name Field

 

 

Table:Voucher Type

 

 

 

 

 

 

 

 

[Function:Save Vch Number]

 

 

Parameter:VarVchType:String

 

 

Variable:VarBillNum:String

 

 

Variable:VarVchMstId:String

 

 

Variable:VarMstId:String

 

 

Variable:Counter :Number

 

 

Variable:NoOfItem :Number

 

 

 

 

 

00 : SET FILE LOG ON

 

 

01 : SET : Counter : 0

 

 

02 : START PROGRESS : ($$NumItems:MpVchTypeColl) : "Voucher update" : @@CmpMailName : "Updating Vouchers..."

 

 

 

 

 

10:Walk Collection:Mp Vch Type Coll

 

 

15:Set:VarBillNum:$VoucherNumber

 

 

20:Set:VarMstId:$MasterId

 

 

30:Set:VarVchMstId:"ID:"+##VarMstId

 

 

40:Call:FillVchNumToUdfValues

 

 

90: INCREMENT : Counter

 

 

100: SHOW PROGRESS : ##Counter

 

 

110:End Walk

 

 

404: END PROGRESS

 

 

406 : SET FILE LOG OFF

 

 

 

 

 

 

 

 

500:Call:Set Vch To Manual

 

 

 

 

 

600:Call:Set Vch Oth To Number Field

 

 

 

 

 

 

 

 

 

 

 

[Function:FillVchNumToUdfValues]

 

 

Object:Voucher:##VarVchMstId

 

 

10:Set Target

 

 

20:Set Object

 

 

30:Set Value:OldBillNumber:##VarBillNum

 

 

40:Accept Alter

 

 

50:Return

 

 

 

 

 

 

 

 

 

 

 

[Function:Set Vch To Manual]

 

 

Object:Voucher Type:##VarVchType

 

 

10:Set Target

 

 

20:Set Object

 

 

30:Set Value:Numbering Method:"Manual"

 

 

40:Set Value:Prevent Duplicates:Yes

 

 

50:Accept Alter

 

 

60:Return

 

 

 

 

 

 

 

 

[Function:Set Vch Oth To Number Field]

 

 

00 : SET FILE LOG ON

 

 

01 : SET : Counter : 0

 

 

02 : START PROGRESS : ($$NumItems:MpVchTypeColl) : "Voucher update" : @@CmpMailName : "Updating Vouchers..."

 

 

 

 

 

10:Walk Collection:Mp Vch Type Coll

 

 

15:Set:VarBillNum:$OldBillNumber

 

 

20:Set:VarMstId:$MasterId

 

 

30:Set:VarVchMstId:"ID:"+##VarMstId

 

 

40:Call:FillUdfToVchNumValues

 

 

90: INCREMENT : Counter

 

 

100: SHOW PROGRESS : ##Counter

 

 

110:End Walk

 

 

404: END PROGRESS

 

 

406 : SET FILE LOG OFF

 

 

 

 

 

[Function:FillUdfToVchNumValues]

 

 

Object:Voucher:##VarVchMstId

 

 

10:Set Target

 

 

20:Set Object

 

 

30:Set Value:VoucherNumber:##VarBillNum

 

 

40:Accept Alter

 

 

50:Return

 

 

 

 

 

 

 

 

[Collection:Mp Vch Type Coll]

 

 

Type:Vouchers:VoucherType

 

 

Child Of:##VarVchType

 

 

Fetch:VoucherNumber,MasterId,OldBillNumber

 

 

Parm Var:SvFromDate:$StartingFrom:Company:##SVCurrentCo mpany

 

 

Parm Var:SvToDate:$$FinYearEnd:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany

 

 

 

 

 

[#Field: VCH Type Combo]

 

 

Add:Fields:Vch Old Bill Number

 

 

 

 

 

 

 

 

[Field:Vch Old Bill Number]

 

 

Use:Name Field

 

 

Storage:OldBillNumber

 

 

Invisible:Yes

 

 

 

 

 

 

 

 

[System:udf]

 

 

OldBillNumber:String:850

 


टिप्पणियाँ

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

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

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 »

Tally Chapter 130 TDL for Stamp & Signature By Rajiv Mishra Computer Class

-
चित्र
  Few lines of the code is missing. pls watch the video for full coding. Add: Right Parts: EXPSMPSignature2 [Part: EXPSMPSignature1] ;;Width: 100% page Horizontal Alignment:Right Vertical:No Lines : EXPINV Logo1 Graph Type : "C:\Users\user\Desktop\tdl image.jpg" Height : 1.00 Cm Width : 10.80 Cm [Line: EXPINV Logo1] Field : EXPINV Logo1 [Field: EXPINV Logo1] Set as : "Authorized Signatory" [Part:EXPSMPSignature2] Border:ll Vertical:No Horizontal Alignment:Right Width:20% Page Right Part:EXPSMPSignature1 Width:70% Page Width:50% Page
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 »