Sales report

Discussion in 'Requests' started by Hems, Jun 14, 2022.

    
  1. Hems

    Hems Member


    Dear experts
    Maine is plateform ki sahayata se ek sale report teyar ki hain. Is report me mujhe amount column me without tax sale amount chahiye.
    Mujhe kya change krna hoga.
    Please any suggestion.

    My code


    [#Menu:Gateway of Tally]

    Add: Item: Before: @@LocQuit: Report: Display: SVR SalesReport


    [Report: SVR SalesReport]

    Use : DSP Template
    Form: SVR SalesReport

    Title:"Sale Voucher"


    [Form: SVR SalesReport]
    Use : DSP Template

    Part: SVR MenuTitlePart, SVR MenuDetailsPart

    Height:100% Page

    Width:100 % Page

    Background:White


    [Part: SVR MenuTitlePart]

    Line: SVR MenuTitlePart

    Border: thin Top Bottom

    Background: Pale Sea Green


    [Line: SVR MenuTitlePart]


    Field: SVR SnoTitle, SVR DateTitle, SVR VchNoTitle, SVR PartyNameTitle,SVR RefrenceTitle, SVR AmountTitle, SVR NarationTitle

    Local:Field: Default: Type: String

    Local:Field: Default: Style: Normal Bold

    Local: Field: Default: Align:Center

    Local:Field: SVR SnoTitle: Set as: "So.No"
    Local:Field: SVR DateTitle:Set as: "Date"

    Local:Field: SVR VchNoTitle: Set as: "Voucher"
    Local:Field: SVR PartyNameTitle: Set as: "PartyName"


    Local:Field: SVR RefrenceTitle: Set as: "Salesman"

    Local: Field: SVR Amount Title: Set as: "Amount"

    Local: Field: SVR NarationTitle: Set as: "Narration"



    /*=====Details Recprd-===*/


    [Part: SVR MenuDetailsPart]

    Line: SVR MenuDetailsPart

    Border: thin Bottom

    Repeat: SVR MenuDetailsPart:Coll AllSalesVch

    Scroll:Vertical

    common border: yes
    bottom line: totalline1
    total :SVRAmountTitle

    [Line: SVR MenuDetailsPart]

    Field: SVR SnoTitle, SVR DateTitle, SVR VchNoTitle, SVR PartyNameTitle,SVR RefrenceTitle, SVR AmountTitle, SVR NarationTitle
    border : thin bottom


    [Field: SVR SnoTitle]

    Use:Number Field

    Style:Normal Bold

    Width:5% page

    Border:thin Left

    Align:Center

    Set as:$$Line


    [Field: SVR DateTitle]

    Use: Date Field

    Style:Normal Bold

    Width:8% page

    Border: thin Left

    Align:Center

    Set as:$SVRDateTitle


    [Field: SVR VchNoTitle]

    Use:Number Field
    Style:Normal Bold

    Width: 5% page

    Border: thin Left

    Align:Center

    Set as:$SVRVchNoTitle


    [Field: SVR PartyNameTitle]

    Use: Name Field

    Style: Normal Bold

    Width: 25% page

    Border: thin Left

    Align:Center

    Set as:$SVRPartyNameTitle



    [Field: SVR RefrenceTitle]

    Use:Name Field

    Style:Normal Bold

    Width:15% page

    Border: thin Left

    Align:Center

    Set as:$SVRRefrenceTitle


    [Field: SVR AmountTitle]

    Use: Amount Field

    Style:Normal Bold

    Width: 10% page

    Border: thin Left

    Align: Center

    Set as:$SVRAmountTitle


    [Field: SVR NarationTitle]

    Use:Name Field

    Style:Normal Bold

    Width: 12% page

    Border: thin Left

    Align:Center

    Set as:$SVRNarationTitle


    /*======-for amount total=====*/


    [line : totalline1]


    Border: thin top


    Field: SVR SnoTitle, SVR DateTitle, SVR VchNoTitle, SVR PartyNameTitle,SVR RefrenceTitle, SVR AmountTitle, SVR NarationTitle

    Local:Field: Default: Type: String

    Local:Field: Default: Style: Normal Bold

    Local: Field: Default: Align:Center

    Local:Field: SVR SnoTitle: Set as: ""
    Local:Field: SVR DateTitle:Set as: ""

    Local:Field: SVR VchNoTitle: Set as: ""

    Local:Field: SVR PartyNameTitle: Set as: "Total"

    Local:Field: SVR RefrenceTitle: Set as: ""

    Local: Field: SVR Amount Title: Set as:$$total:SVRAmountTitle

    Local: Field: SVR NarationTitle: Set as: ""

    /*======-Collection Data=====*/



    [Collection: Coll SalesVoucher]

    Type : Vouchers: VoucherType

    Child of : $$VchTypeSales

    Belongs To: Yes


    [Collection: Coll AllSalesVch]

    Source Collection: Coll SalesVoucher

    Walk Inventory Entries

    Compute : SVRDateTitle : $date
    Compute : SVRVchNoTitle : $vouchernumber
    Compute : SVRRefrenceTitle : $BasicOrderRef
    Compute : SVRPartyNameTitle : $partyledgername

    Compute : SVRAmountTitle :$Amount
     


Share This Page