sale report me sale bill payment history not showing

Discussion in 'Tally Developer' started by Hems, Aug 23, 2022.

    
  1. Hems

    Hems Member


    please help
    maine sale report banai hai
    lekin explode karne par sale bill ki payment history nahi aa rahi hai,
    plese help


    [#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
    Button:explode flag
    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
    border : thin top
    Explode:inventory: ##explodeflag or $$KeyExplode


    [Field: SVR SnoTitle]

    Use:Number Field

    Style:Normal Bold

    Width:5% page

    ;Border:thin Left

    Align:Center

    Set as:$$Line


    [Field: SVR DateTitle]

    Use : Short Date Field

    Style:Normal Bold

    Width:8% page

    ;Border: thin Left

    Align:Center

    Set as:$date


    [Field: SVR VchNoTitle]

    Use:Number Field
    Style:Normal Bold

    Width: 5% page

    ;Border: thin Left

    Align:Center

    Set as:$vouchernumber


    [Field: SVR PartyNameTitle]

    Use: Name Field

    Style: Normal Bold

    Width: 25% page

    ;Border: thin Left

    Align:Center

    Set as:$partyledgername



    [Field: SVR RefrenceTitle]

    Use:Name Field

    Style:Normal Bold

    Width:15% page

    ;Border: thin Left

    Align:Center

    Set as:$BasicOrderRef


    [Field: SVR AmountTitle]

    Use: Amount Field

    Style:Normal Bold

    Width: 10% page

    ;Border: thin Left

    Align: Center

    Set as:$$CollAmtTotal:allinventoryEntries:$Amount


    ;$Amount

    ;$$CollAmtTotal:allinventoryEntries:$Amount



    [Field: SVR NarationTitle]

    Use:Name Field

    Style:Normal Bold

    Width: 12% page

    ;Border: thin Left

    Align:Center

    Set as:$Naration




    [Part:inventory]
    Line:inv
    Repeat:inv: RecColl


    [Line:inv]
    Field:date,vchnmber,amt

    [Field:date]
    Use : Short Date Field
    Set as: $date
    indent : 2

    [Field:vchnmber]
    Use:number field
    Set as:$vouchernumber
    indent : 2

    [Field:amt]
    Use:amount field
    Set as: $amount
    indent : 2



    /*======-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 AllSalesVch]

    Type : Vouchers: VoucherType

    Child of : $$VchTypeSales

    Belongs To: Yes

    Fetch:partyledgername, amount, vouchernumber,BasicOrderRef, ledger



    [Collection:RecColl]
    Type:vouchers:vouchertype
    Child Of:$$VchTypeReceipt
    Belongs To:Yes
    Fetch:date, partyledgername, vouchertype, vouchernumber, amount
    Filter: RecFilter
    ;;================================================================

    [System:Formula]
    RecFilter: $vouchernumber = #SVRVchNoTitle
     


Share This Page