1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

part wise sales value without taxes

Discussion in 'Free Source Codes' started by Ruwan, Oct 1, 2019.

    
  1. Ruwan

    Ruwan New Member


    Dear Sir,
    i was copied this TDL Source code from this forum can help to resolve this below requirement.

    i want to part wise sales value without taxes & previous year amount not view can help to resolve this issue .

    [#Menu: Account Books]
    Add: Item: After: @@locLedger : Party Wise Turnover Report : Display: Party Wise Turnover Report : NOT $$IsEmpty:$$SelectedCmps

    [Report: Party Wise Turnover Report]
    Title: $$LocaleString:"Turn Over Report"
    Use : DSP Template
    Form : Party Wise Turnover Report

    [Form: Party Wise Turnover Report]
    Use : DSP Template
    Width : 100% Page
    Height: 100% Page
    Part: TurnOver
    ;;FetchObject : Ledger: @@AllLedEntryList : PrevYearTurnover, CurrentTurnover, CreditLimit

    [Part: TurnOver]
    Line: TurnOverTitles, TurnOverDetails
    Repeat: TurnOverDetails : TurnOverColl
    Scroll: Vertical

    [Line: TurnOverTitles]
    Use: TurnOverDetails
    Local: Field: PartyName : Info: $$LocaleString:"Customer Name"
    Local: Field: PartyName : Full Width: Yes
    Local: Field: PrevYrTurnOver:Info: $$LocaleString:"Prev. Year TurnOver"
    Local: Field: CurrYrTurnOver:Info: $$LocaleString:"Curr. Year TurnOver"
    Local: Field: PartyCreditLimit:Info: $$LocaleString:"Credit Limit"
    Local: Field: Default: Type: String
    Local: Field: Default: Align: Center
    Local: Field: Default: Style: Normal Bold
    Border: Column Titles

    [Line: TurnOverDetails]
    Field: PartyName
    Right Fields: PrevYrTurnOver, CurrYrTurnOver, PartyCreditLimit

    [Field: PartyName]
    Use: Name Field
    Set as: $Name
    Border: Thin Right
    Full Width: Yes

    [Field: PrevYrTurnOver]
    Use: Amount Forex Field
    Set as: $$FromValue:mad:@PrevYearStart:$$ToValue:mad:@PrevYearEnd:$DebitTotals
    Border: Thin Right

    [Field: CurrYrTurnOver]
    Use: Amount Forex Field
    Set as: $$ToValue:##SVCurrentDate:$DebitTotals
    Border: Thin Right

    [Field: PartyCreditLimit]
    Use: Amount Forex Field
    Set as: $CreditLimit
    Format : ("AllSymbols,NoZero,DrCr")


    [Collection: TurnOverColl]
    Type : Ledger
    Child Of: $$GroupSundryDebtors
    Belongs To: Yes
    Fetch: PrevYearTurnover, CurrentTurnover, CreditLimit

    ;;End of File
     

    Attached Files:

    Ruwan, Oct 1, 2019
    #1


  2. Bidyut Banerjee

    Bidyut Banerjee Member



    Previous yer data are showing in below updated code along with total.
     

    Attached Files:

    Bidyut Banerjee, Oct 1, 2019
    #2


  3. Bipin Damania

    Bipin Damania Active Member


    Bidyutji

    This report shows Total Debit Amount i.e. includes other item also other than Sales...

    Please check & reply.
     
    Bipin Damania, Oct 2, 2019
    #3


Share This Page