1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

address book with closing bal & Credit limit

Discussion in 'Free Source Codes' started by laxman, Dec 5, 2013.

    
  1. laxman

    laxman Member


    Dear expert please find code & solution in total ...

    [#Menu: GatewayOfTally]
    Add : Item : Before : @@locQuit : Address Book: Menu: MyMenu


    [Menu: MyMenu]
    Title: Address Book
    Add: Item: Sundry Debtors Details: Display : SD Address Book
    Add: Item: Sundry Creditors Details: Display: SC Address book

    [Report: SD Address Book]
    Use: DSP Template
    Form: SD Address Book
    Title: Sundry Debtors Address Book

    [Report: SC Address Book]
    Use: SD Address Book
    Local: Collection: My Sundry Debtors: Child Of: $$GroupSundryCreditors
    Title: Sundry Creditors Address Book

    [Form: SD Address Book]
    Use: DSP Template
    Part: SD Address Book Title, SD Address Book
    Delete: Page Break
    Bottom Part:gtotal

    [Part: SD Address Book Title]
    Line: SD Address Book Title

    [Line: SD Address Book title]
    Use: SD Address Book
    Local: Field: SD Sr no: Set as: "Sr"
    Local: Field: SD Name: Set as: "Name"
    Local: Field: SD Contact No: Set as: "Contact Person"
    Local: Field: SD Mobile: Set as: "Mobile"
    Local: Field: SD Address: Set as: "Address"
    Local: Field: SDCrLimit: Set as: "Credit Limit"
    Local: Field: SD PrLevel: Set as: "Price Level"
    Local: Field: SDClBal: Set as: "Closing Balance"
    Local: Field: SD DrCr: Set as: "Debit/Credit"
    Local : Field : Default : Style : Small Bold
    Local : Field : Default : Align: Center
    Border: Flush Totals

    [Part: SD Address Book]
    Line: SD Address Book
    Repeat: SD Address Book: My Sundry Debtors
    Total: SDCrLimit,SDClBal
    Scroll: Vertical
    Common Border: Yes

    [Line: SD Address Book]
    Field: SD Sr No,SD Name
    Right Field: SD Contact No, SD Mobile, SD Address, SDCrLimit, SDClBal, SD PrLevel;;, SD DrCr
    Option : alter on enter
    Local : field : SD Name: alter : Ledger : $$isLedger
    Border : Thin Bottom

    [Field: SD Sr No]
    Use: Short Name Field
    Set as: $$Line
    Style: Normal
    Width: 4
    Align: Centre

    [Field: SD Name]
    Use: Name Field
    Set as: $Name
    Full Width: Yes
    Border: Thin Left

    [Field: SD Contact No]
    USe: Short Name Field
    Set As: $LEdgerContact
    Style: Normal
    Border: Thin Left
    Align: Left

    [Field: SD Mobile]
    Use: Short Name Field
    Set As: $LedgerMobile
    Style: Normal
    Border: Thin Left
    Align: Left

    [Field: SD Address]
    Use: Short Name Field
    Set As: $$FullList:Address:$Address
    Full Width: Yes
    Style: Normal
    Border: Thin Left

    [Field: SDCrLimit]
    Use: Short Name Field
    Set As:$CreditLimit:Ledger:$Name
    Format: "CrDr"
    Style: Normal
    Border: Thin Left
    Align: Right

    [Field: SD PrLevel]
    Use: Short Name Field
    Set As:$PriceLevel:Ledger:$Name
    Style: Normal
    Border: Thin Left
    Align: Centre

    [Field: SDClBal]
    Use :Short Name Field
    Set As:If $$IsDr:$_ClosingBalance then $$String:$_ClosingBalance + " Dr" else $$String:$_ClosingBalance + " Cr"
    Format : "CrDr"
    Style: Normal
    Border: Thin Left
    Align: Right


    [Part:gtotal]

    Use : SD Address Book
    Delete : Repeat
    Delete : Scroll
    Delete : Total
    Border : Totals
    Local : Field : Default: Type : string
    Local : Field : SDCrLimit : Set As : $$Total:SDCrLimit
    Local : Field : SDClBal : Set As : $$Total:SDClBal

    Local : Field : Default : Style : Small Bold

    ;[Field: SD DrCr]
    ;Use :Short Name Field
    ;Style: Normal
    ;Border: Thin Left
    ;Align: Centre

    ;;Define Collection
    [Collection: My Sundry Debtors]
    Type: Ledger
    Child of: $$GroupSundryDebtors
    Belongs To: Yes

    ;;;;;=========
     
    laxman, Dec 5, 2013
    #1
    Vibhav likes this.


  2. Vibhav

    Vibhav New Member


    GREAT SHARING....
     
    Vibhav, Feb 7, 2014
    #2


  3. Anthony dinakaran

    Anthony dinakaran New Member


    Good.
     
    Anthony dinakaran, Feb 15, 2014
    #3


  4. Varaprasad

    Varaprasad New Member


    Sir,

    We need the age wise analysis of closing balance and total instead to gross figure of closing balance in the report please end the Code and again upload or u r requested to mail me on varaprasad 21410@gmail.com
     
    Varaprasad, Feb 21, 2014
    #4


  5. mpal2311

    mpal2311 Active Member


    @Varaprasad this is not a marketing site.
     
    mpal2311, Feb 27, 2014
    #5


  6. Pupesh Arora

    Pupesh Arora Member


    Brother,

    Can we have filter in the address book i.e option to select ledger to get particular pary address and closing balance.
     
    Pupesh Arora, Apr 28, 2014
    #6


  7. laxman

    laxman Member


    add Line in Form:-
    BottomButton: FilterButton, ValueButton
     
    laxman, Apr 29, 2014
    #7


  8. laxman

    laxman Member


    add Line in Form:-
    BottomButton: FilterButton, ValueButton
     
    laxman, Apr 29, 2014
    #8


  9. Pupesh Arora

    Pupesh Arora Member


    Sir , I have added the above button but still not working.
     
    Pupesh Arora, May 7, 2014
    #9


  10. laxman

    laxman Member


    Try This....

    [#Menu: GatewayOfTally]
    Add : Item : Before : @@locQuit : Address Book: Menu: MyMenu


    [Menu: MyMenu]
    Title: Address Book
    Add: Item: Sundry Debtors Details: Display : SD Address Book
    Add: Item: Sundry Creditors Details: Display: SC Address book

    [Report: SD Address Book]
    Use: DSP Template
    Form: SD Address Book
    Title: Sundry Debtors Address Book

    [Report: SC Address Book]
    Use: SD Address Book
    Local: Collection: My Sundry Debtors: Child Of: $$GroupSundryCreditors
    Title: Sundry Creditors Address Book

    [Form: SD Address Book]
    Use: DSP Template
    BottomButton: BlankButton,InvReports, AcctReports, Report Operations,FilterButton, ValueButton
    Part: SD Address Book Title, SD Address Book
    Delete: Page Break
    Bottom Part:gtotal

    [Part: SD Address Book Title]
    Line: SD Address Book Title

    [Line: SD Address Book title]
    Use: SD Address Book
    Local: Field: SD Sr no: Set as: "Sr"
    Local: Field: SD Name: Set as: "Name"
    Local: Field: SD Contact No: Set as: "Contact Person"
    Local: Field: SD Mobile: Set as: "Mobile"
    Local: Field: SD Address: Set as: "Address"
    Local: Field: SDCrLimit: Set as: "Credit Limit"
    Local: Field: SD PrLevel: Set as: "Price Level"
    Local: Field: SDClBal: Set as: "Closing Balance"
    Local: Field: SD DrCr: Set as: "Debit/Credit"
    Local : Field : Default : Style : Small Bold
    Local : Field : Default : Align: Center
    Border: Flush Totals

    [Part: SD Address Book]
    Line: SD Address Book
    Repeat: SD Address Book: My Sundry Debtors
    Total: SDCrLimit,SDClBal
    Scroll: Vertical
    Common Border: Yes

    [Line: SD Address Book]
    Field: SD Sr No,SD Name
    Right Field: SD Contact No, SD Mobile, SD Address, SDCrLimit, SDClBal, SD PrLevel;;, SD DrCr
    Option : alter on enter
    Local : field : SD Name: alter : Ledger : $$isLedger
    Border : Thin Bottom

    [Field: SD Sr No]
    Use: Short Name Field
    Set as: $$Line
    Style: Normal
    Width: 4
    Align: Centre

    [Field: SD Name]
    Use: Name Field
    Set as: $Name
    Full Width: Yes
    Border: Thin Left

    [Field: SD Contact No]
    USe: Short Name Field
    Set As: $LEdgerContact
    Style: Normal
    Border: Thin Left
    Align: Left

    [Field: SD Mobile]
    Use: Short Name Field
    Set As: $LedgerMobile
    Style: Normal
    Border: Thin Left
    Align: Left

    [Field: SD Address]
    Use: Short Name Field
    Set As: $$FullList:Address:$Address
    Full Width: Yes
    Style: Normal
    Border: Thin Left

    [Field: SDCrLimit]
    Use: Short Name Field
    Set As:$CreditLimit:Ledger:$Name
    Format: "CrDr"
    Style: Normal
    Border: Thin Left
    Align: Right

    [Field: SD PrLevel]
    Use: Short Name Field
    Set As:$PriceLevel:Ledger:$Name
    Style: Normal
    Border: Thin Left
    Align: Centre

    [Field: SDClBal]
    Use :Short Name Field
    Set As:If $$IsDr:$_ClosingBalance then $$String:$_ClosingBalance + " Dr" else $$String:$_ClosingBalance + " Cr"
    Format : "CrDr"
    Style: Normal
    Border: Thin Left
    Align: Right


    [Part:gtotal]

    Use : SD Address Book
    Delete : Repeat
    Delete : Scroll
    Delete : Total
    Border : Totals
    Local : Field : Default: Type : string
    Local : Field : SDCrLimit : Set As : $$Total:SDCrLimit
    Local : Field : SDClBal : Set As : $$Total:SDClBal

    Local : Field : Default : Style : Small Bold

    ;[Field: SD DrCr]
    ;Use :Short Name Field
    ;Style: Normal
    ;Border: Thin Left
    ;Align: Centre

    ;;Define Collection
    [Collection: My Sundry Debtors]
    Type: Ledger
    Child of: $$GroupSundryDebtors
    Belongs To: Yes
     
    laxman, May 7, 2014
    #10


  11. Pupesh Arora

    Pupesh Arora Member


    Thanks Laxman Sir, but I have already added the abvoe buttons and tryied but no change is there. Unable to filter the ledger nor display any filter button
     
    Pupesh Arora, May 7, 2014
    #11


  12. Pupesh Arora

    Pupesh Arora Member


    Thanks Laxman Sir, but I have already added the abvoe buttons and tryied but no change is there. Unable to filter the ledger nor display any filter button
     
    Pupesh Arora, May 7, 2014
    #12


  13. laxman

    laxman Member


    i checked this fill working with filter Button.
     
    laxman, May 7, 2014
    #13


  14. Pupesh Arora

    Pupesh Arora Member


    Dear Sir,

    Can you provide Screen Shot please. Its not working. I am not getting any button with the abvoe code. Just want to see from where it is working
     
    Pupesh Arora, May 8, 2014
    #14


  15. Asifraza1

    Asifraza1 New Member


    Give Error ... Not Working
     
    Asifraza1, Dec 19, 2014
    #15


  16. Amit Sony

    Amit Sony New Member


    can we combine All Debtors and Creditors in one list????
     
    Amit Sony, Jan 6, 2015
    #16


  17. Ankur Tiwari

    Ankur Tiwari Member


    [Collection: My Sundry Debtors]
    Type: Ledger
    Child of: $$GroupSundryDebtors Or $$GroupSundryCreditors
    Belongs To: Yes
     
    Ankur Tiwari, Jan 6, 2017
    #17


Share This Page