Tally Chapter 216 TDL for Post Dated Entry Print By Rajiv Mishra Computer Class

-

 







Few lines are missing Here.

Pls Watch the full video to get full coding.




[Line:DR OutList]

Fields:DROUTLineTally,InvDateTally,OInvNoTally,OInvCustomerNameTally,OInvAmountTally,DROUTListPDA,DROUTListFinalBalance ;,DROUTList030,DROUTList3060,DROUTList6090,DROUTList90120,DROUTListM120,

Border:Thin Bottom


[Field:DROUTLineTally]

Use:Name Field

Set as:"No"

Width:10 mms

Skip:Yes

Border:Thin Right


[Field:InvDateTally]

Use:Name Field

Set as:"INV Date"

Width:25 mms

Border:Thin Right

Skip:Yes

Align:Right



[Field:OInvNoTally]

Use:Name Field

Set as:"INV No"

Width:25 mms

Border:Thin Right

Align:Right

Skip:Yes


[Field:OInvCustomerNameTally]

Use:Name Field

Set as:"Cus Name"

Width:25 mms

Border:Thin Right

Align:Left

Skip:Yes




[Field:OInvAmountTally]

Use:Name Field

Set as:"INV Amt"

Width:25 mms

Align:Right

Skip:Yes

Border:Thin Right



[Field:DROUTList030]

Use:Name Field

Set as:"0 - 30"

Width:25 mms

Border:Thin Right

Align:Right

Skip:Yes


[Field:DROUTList3060]

Use:Name Field

Set as:"30 - 60"

Width:25 mms

Border:Thin Right

Align:Right

Skip:Yes


[Field:DROUTList6090]

Use:Name Field

Set as:"60 - 90"

Width:25 mms

Border:Thin Right

Align:Right

Skip:Yes


[Field:DROUTList90120]

Use:Name Field

Set as:"90 - 120"

Width:25 mms

Border:Thin Right

Align:Right

Skip:Yes


[Field:DROUTListM120]

Use:Name Field

Set as:"120 - <"

Align:Right

Width:25 mms

Border:Thin Right

Skip:Yes


[Field:DROUTListPDA]

Use:Name Field

Set as:"PDC Amount"


Align:Right

Width:25 mms

Border:Thin Right

Skip:Yes


[Field:DROUTListFinalBalance]

Use:Name Field

Set as:"Final Balance"

Align:Right

Width:25 mms

Skip:Yes






[Field:DROUTList030Tally]

Use:Amount Field

Set as:if (@@DSPToDate - $BillDate) Between 0 and 30 Then $BillAmt Else ""

Width:25 mms

Style:Normal

Skip:Yes

Align:Right

;+Border:Thin Right


[Field:DROUTList3060Tally]

Use:Amount Field

Set as:if (@@DSPToDate - $BillDate) Between 31 and 59 Then $BillAmt Else ""

Width:25 mms

Style:Normal

Skip:Yes

Align:Right

;Border:Thin Right


[Field:DROUTList6090Tally]

Use:Amount Field

Set as:if (@@DSPToDate - $BillDate) Between 60 and 89 Then $BillAmt Else ""

Width:25 mms

Style:Normal

Skip:Yes

Align:Right

;Border:Thin Right


[Field:DROUTList90120Tally]

Use:Amount Field

Set as:if (@@DSPToDate - $BillDate) Between 90 and 119 Then $BillAmt Else ""

Width:25 mms

Style:Normal

Skip:Yes

Align:Right

;Border:Thin Right


[Field:DROUTListM120Tally]

Use:Amount Field

Set as:if (@@DSPToDate - $BillDate) Between 120 and 180 Then $BillAmt Else ""

Width:25 mms

Skip:Yes

Align:Right

;Border:Thin Right




[#Form :SALES Color];; Add Print in SALES

Add : Print : ReorderPopUpOutstanding

Add : Button :ReorderPopUpOutstanding

[Button : ReorderPopUpOutstanding]

Action :print Report:ReorderPopUpOutstanding

Key :<Enter your Key>


[Report:ReorderPopUpOutstanding]

Form:ReorderPopUpOutstanding



[Form:ReorderPopUpOutstanding]

Use : DSP TEMPLATE


Parts:AMOutStandingDetails


[Part:AMOutStandingDetails]

Line:DR OutList,LedOutStanding ;,DR OutListTotal

Repeat:LedOutStanding:MyLedg Outstanding

Space Top:1 mms


Total:OInvAmount,DROUTList030Tally,DROUTList3060Tally,DROUTList6090Tally,DROUTList90120Tally,DROUTListM120Tally,DROUTListPDATally,DROUTListFinalBalanceTally

Float:No

Scroll:Vertical

Common Border:Yes


[Line:LedOutStanding]

Field:DROUTLine,InvDate,OInvNo,OInvCustomerName,OInvAmount,DROUTListPDATally,DROUTListFinalBalanceTally,DROUTListBillDueDate ;;DROUTList030Tally,DROUTList3060Tally,DROUTList6090Tally,DROUTList90120Tally,,DROUTListM120Tally

Space Top:1 mms

Remove if : #DROUTListBillDueDate > $$MachineDate


[Field:DROUTLine]

Use:Number Field

Set as:$$Line

Width:10 mms

Skip:Yes

Style:Normal


[Field:InvDate]

Use:Short Date Field

Set as:$BillDate

Width:20 mms

Style:Normal

Skip:Yes

Align:Right


[Field:OInvNo]

Set as:$Name

Width:20 mms

Style:Normal

Align:Right

Skip:Yes


[Field:OInvCustomerName]

Set as:$DSPAccName:Ledger:$Parent

Width:35 mms

Style:Normal

Align:Right

Skip:Yes


[Field:OInvAmount]

Use:Amount Field

Set as:$BillAmt

Width:25 mms

Align:Right

Skip:Yes

Style:Normal

;Border:Thin Right


[Field:DROUTListPDATally]

Use:Amount Field

Set as:$$AmountSubtract:$FinalBalance:$OpeningBalance

Align:Right

Style:Normal

Width:25 mms

Skip:Yes

;Border:Thin Right


[Field:DROUTListFinalBalanceTally]

Use:Amount Field

Set as:$FinalBalance

Align:Right

Style:Normal

Width:25 mms

Skip:Yes


[Field:DROUTListBillDueDate]

Use:Short Date field

Set as : @@CreditPeriod

Invisible:Yes




[Collection:MyLedg Outstanding]

Type : Bills

Cleared : No

Filter:ABSNP



Compute : PartyName : $$FuncDSPAccName:$Parent

Compute : BillAmt: $OpeningBalance ;$ClosingBalance

Compute : MyDate:$LedgerEntries.LedgerEntries.BillAllocations.BillDate

;Filter : MyLedg


Fetch : LedgerEntries.LedgerEntries.BillAllocations.Amount

Fetch : LedgerEntries.CurLangVoucherTypeName,ClosingBalance

Sort : @@Default : $BillDate, $Parent

Fetch : LedgerEntries.LedgerEntries.BankAllocations.InstrumentDate,BillDate


;Filter:ABSNP


[Line:DR OutListTotal]


Use:LedOutStanding

Local : Field : Default :Style : Normal Bold

Local : Field : Default : Align : Right

Local : Field : Default : Type : String

Local : Field : DROUTLine : Set As : ""

Local : Field : InvDate : Set As : ""

Local : Field : OInvNo : Set As : "Total"

Local : Field : OInvAmount: Set As :$$Total:OInvAmount

Local : Field : DROUTList030Tally: Set As :$$Total:DROUTList030Tally

Local : Field : DROUTList3060Tally: Set As :$$Total:DROUTList3060Tally

Local : Field : DROUTList6090Tally: Set As :$$Total:DROUTList6090Tally

Local : Field : DROUTList90120Tally: Set As : $$Total:DROUTList90120Tally

Local : Field : DROUTListM120Tally: Set As : $$Total:DROUTListM120Tally

Local : Field : DROUTListPDATally: Set As : $$Total:DROUTListPDATally

Local : Field : DROUTListFinalBalanceTally: Set As : $$Total:DROUTListFinalBalanceTally


Border:Thin Top


[System : Formula]

ABSNP : $$FuncDSPAccName:$Parent:##LedgerName Contains ""


टिप्पणियाँ

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

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

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 »