Tally Chapter 177 TDL for Multiple Discount By Rajiv Mishra Computer Class

 

Few lines are missing here.

Pls watch the full video first.

[#Line : EI ColumnOne]

Option : Global EI ColumnOne

[!Line: Global EI ColumnOne]

Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL,SchemeAmtTL1,SchemeAmtTL2

Info : "Dis-1"

Align : Centre

Width : 5

Style : Small

Border : Thin Left Right

Background : Red

[Field : SchemeAmtTL1]

Info : "Dis-2"

Align : Centre

Width : 5

Style : Small

Border : Thin Left Right

Background : Green

[Field : SchemeAmtTL2]

Info : "Dis-3"

Align : Centre

Width : 5

Style : Small

Border : Thin Left Right

Background : Blue

[#Line : EI ColumnTwo]

Option : Global EI ColumnTwo

[!Line: Global EI ColumnTwo]

Add : Right Fields : After : VCH DiscTitle : SchemeAmtTL ,SchemeAmtTL1,SchemeAmtTL2

Local : Field : SchemeAmtTL : Info : " "

[#Line : EI InvInfo]

Option : Global EI InvInfo

[#Line : CI InvInfo]

Option : Global EI InvInfo

[!Line: Global EI InvInfo]

Add : Right Fields : After : VCH Discount : SchemeAmt,SchemeAmt1,SchemeAmt2

[Field : SchemeAmt]

Use : Number Field

Width : 5

Set Always : Yes

Storage : SchemeAmt

Format : "Zero, Percentage"

Align : Right

[Field : SchemeAmt1]

Use : Number Field

Width : 5

Set Always : Yes

Storage : SchemeAmt1

Format : "Zero, Percentage"

Align : Right

[Field : SchemeAmt2]

Use : Number Field

Width : 5

Set Always : Yes

Storage : SchemeAmt2

Format : "Zero, Percentage"

Align : Right

[System:UDF]

SchemeAmt : Number : 2345

SchemeAmt1 : Number : 2346

SchemeAmt2 : Number : 2347

[#Field: VCH NrmlValue]

Delete : Set as

Add : Set as :($Rate * $BilledQty) * (100 - $SchemeAmt) / 100 *  (100 - $SchemeAmt1) / 100 *(100 - $SchemeAmt2) / 100