1. We are making changes to http://tdlexperts.com. So redirected to new portal http://tdlexperts.net. Kindly cooperate!!!
    Dismiss Notice

How to get Tax Rate of Invoice??

Discussion in 'Requests' started by Johar, Dec 21, 2016.

  1. Johar

    Johar New Member


    Dear Experts,

    Can you tell me how to get Invoiced Tax name i.e ---- 14.5%, 5% or CST

    below is my code, please help.

    Thanks

    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; TDL ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    [System : Formula]
    OnlyVATCSTparty: $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$DebitTotals
    OnlyVATCSTdrs : $$IsDr:$Amount

    [Report : VATCST Report]
    Form : MyVATCST
    Variables : SV CurrentCompany, SVFromDate, SVToDate, SVSortMethod, LedgerName
    Set : SV Sort Method : @@Default
    Set : SV From Date : $$MonthStart:##SVCurrentDate
    Set : SV To Date : $$MonthEnd:##SVCurrentDate

    Title : "VAT/CST BillWise Report -- Period : " + @@DSPDateStr

    [Form : MyVATCST]
    Use : DSP Template
    BackGround : Light Sea Green
    Parts : VATCST Title, VATCST Body

    [Part : VATCST Title]
    Line : VATCST Title

    [Border : VATCST Title Border]
    Top : Thin
    Bottom : Thin

    [Line : VATCST Title]
    Border : VATCST Title Border
    Fields : VATCST Title

    [Field : VATCST Title]
    Use : Name Field
    Set as : "Particulars"
    FullWidth : Yes
    Style : Large
    Border : Thin Bottom

    [Part : VATCST Body]
    Line : VATCST Body Detail
    Repeat : VATCST Body Detail : Ledger
    Scroll : Vertical
    Local : Collection : Ledger : Filter : OnlyVATCSTparty

    [Line : VATCST Body Detail]
    Left Fields : VATCSTLedName
    Explode : MyVATCSTExplodPart : ($$KeyExplode OR ##ExplodeFlag)

    [Field : VATCSTLedName]
    Set As: $Name
    Variable: LedgerName
    Modifies: ledgerName
    Style: Large
    FullWidth: Yes
    Color: Blue
    Background: MyBlueColor

    [!Part : MyVATCSTExplodPart]
    Lines: VATCSTLedger Bills Title, VATCSTLedger Bills, VATCSTEmptyLine
    Repeat: VATCSTLedger Bills : VATCSTColl
    Vertical: Yes

    [Line : VATCSTEmptyLine]
    Fields : Space11, Space22, Space33

    [Field : Space11]
    Use : Short Name Field
    Set As : " "

    [Field : Space22]
    Use : Short Name Field
    Set As : " "

    [Field : Space33]
    Use : Short Name Field
    Set As : " "

    [Line : VATCSTLedger Bills Title]
    Fields: VATCSTBill DateTitle, VATCSTBillNoTitle, VATCSTbillPty, VATCSTbillAmountTitle, VATCSTBillVATAmountTitle, VATCSTBillClassName

    [Field : VATCSTBill DateTitle]
    Use: Short Name Field
    Set as: "Bill Date"
    Style: Normal Bold
    Border: Thin Box
    Width: 15
    Align: Center

    [Field : VATCSTBillNoTitle]
    Use: Short Name Field
    Set as: "Bill Number"
    Style: Normal Bold
    Border: Thin Box
    Width: 20
    Align: Center

    [Field : VATCSTbillPty]
    Use: Short Name Field
    Set as: "Party Name"
    Style: Normal Bold
    Border: Thin Box
    Width: 50
    Align: Center

    [Field: VATCSTBillAmountTitle]
    Use: Short Name Field
    Set as: "Amount"
    Style: Normal Bold
    Border: Thin Box
    Width: 35
    Align: Center

    [Field: VATCSTBillVATAmountTitle]
    Use: Short Name Field
    Set as: "VAT Amount"
    Style: Normal Bold
    Border: Thin Box
    Width: 35
    Align: Center

    [Field: VATCSTBillClassName]
    Use: Short Name Field
    Set as: "Tax Classification Name"
    Style: Normal Bold
    Border: Thin Box
    Width: 35
    Align: Center


    [Line : VATCSTLedger Bills]
    Fields: VATCSTBill Date, VATCSTBillNo, VATCSTONo, VATCSTBillAmount, VATCSTBillVATAmount, VATCSTClassName

    [Field : VATCSTBill Date]
    Use: UniDateField
    Set as: $Date
    Style: Small Italic
    Width: 15
    Align: Center
    Border : Thin Right

    [Field : VATCSTBillNo]
    Use: Short Name Field
    Set as: $VoucherNumber
    Style: Small Italic
    Width: 20
    Align: Center
    Border : Thin Right

    [Field : VATCSTONo]
    Use : Name Field
    Set As: $LedgerName
    Width : 50
    Style : Small
    Align : Center
    Border : Thin Right

    [Field: VATCSTBillAmount]
    Use : Amount Field
    Set as : $Amount
    Style : Small Italic
    Width : 35
    Align : Right
    Border : Thin Right

    [Field: VATCSTBillVATAmount]
    Use : Amount Field
    Set as : $VATAmount
    Style : Small Italic
    Width : 35
    Align : Right
    Border : Thin Right

    [Field: VATCSTClassName]
    Use : Name Field
    Set as : ?????????????????????? <----------- What to Specify ?????????
    Style : Small Italic
    Width : 35
    Align : Right
    Color : Red
    Border : Thin Right


    [Collection: VATCSTColl]

    Type : Vouchers : Ledger
    Child of : #LedgerName
    Belongs To : Yes
    Fetch : Date, VoucherNumber, Amount, VATAmount
    Filter : OnlyVATCSTdrs
     


Share This Page