Tally Chapter 108 TDL for Cash Discount in Amount by Rajiv Mishra Computer Class | TDL FILE Banaye






--------------------CODE STARTS HERE--------------------





 ;;===================================================CODE By Rajiv Mishra=================================================




[#Line: EI ColumnOne]

Add: Option: Disc EI ColumnOne: @@IsSales

Add: Option: Disc EI ColumnOne: @@IsPurchase


[!Line: Disc EI ColumnOne]

Local: Field: VCH DiscTitle: Set as: "Disc Amt"

Local: Field: Default : Style : Normal Bold


[#Line: VCHBATCH ColumnOne]

Add: Option: Disc EI ColumnName: @@IsSales

Add: Option: Disc EI ColumnName: @@IsPurchase


[!Line: Disc EI ColumnName]

Local: Field: VCH DiscTitle: Info: "Disc Amt"



[#Field: MPSDiscountTitle]

Set as: "Discount Amt"





[System: Formula]

CalcedAmt: ($Rate * $BilledQty) - $BatchDiscount

NrmlAmount: ($BilledQty * $Rate) - $BatchDiscount


[# Field: EXPINV DiscTitle]


Info : $$LocaleString:"Disc."

Border : Thin Left

Align : Centre

Width : 5

Style : Small

Invisible : If (@@IsJobOrderOut OR @@IsJobOrderIn OR (@@IsSales And (@@AcctsInvoice OR @@AcctsInvoiceMfgr))) Then Yes Else (NOT @@WithDiscount OR (NOT @@InvWithRate AND NOT @@InvWithAmt))




[#Field: VCH Discount]

Delete: Format

Add: Format: "Nopercent,NoZero"



[#Field: VCHBATCH Discount]

Delete: Format

Add: Format: "Nopercent,NoZero"


[#Field: VCH Value]

Resetval: if (@@NoBaseUnits OR $$IsEmpty:BilledQty) then $$Value else (($Rate * $BilledQty) - $Discount)


[#Field: EXPINV Discount]


Use : Number Field

Align : Right

Style : Small

Set as : $Discount

Width : 5

Border : Thin Left

Format : "NoZero,NoPercentage"

Invisible : If (@@IsJobOrderOut OR @@IsJobOrderIn OR (@@IsSales And (@@AcctsInvoice OR @@AcctsInvoiceMfgr))) Then Yes Else (NOT @@WithDiscount OR (NOT @@InvWithRate AND NOT @@InvWithAmt))


------------------Code Ended Here----------

टिप्पणियाँ

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

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

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

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