1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

add a TRN details in address book to this code please help me

Discussion in 'Requests' started by shihab21, Mar 23, 2022.

    
  1. shihab21

    shihab21 New Member


    [#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
     
    shihab21, Mar 23, 2022
    #1


Share This Page