HOW TO FETCH LEDGER MOBILE NUMBER

Discussion in 'Free Source Codes' started by ANURAG954245, Sep 17, 2021.

    
  1. ANURAG954245

    ANURAG954245 Member


    This code is working fine but it is not able to fetch the ledger mobile umber for whatsapp web
    below are the code


    Dear Experts help me with this problem
    Thanks in advance


    [#Menu: Gateway of Tally]

    Add : Item : Before : @@locQuit : Company Ledger/Sub Group List : Alter : CAB Ledger List

    [Report: CAB Ledger List]

    Form : CAB Ledger Form
    Title : “Company Ledger List”

    [Form: CAB Ledger Form]


    Parts : CAB Ledger Part
    Height : 100% screen ;;;defining height of form as 100% sccreen
    Width : 100% screen ;;;defining width of form as 100% sccreen
    Add:Button:F12ConfigureButton




    [Part: CAB Ledger Part]

    Lines : CAB Ledger Title, CAB Ledger Line
    Repeat : CAB Ledger Line : CAB My Ledgers ;;;line will repeat on the collection of the ledger
    CommonBorder: Yes
    Scroll : Vertical


    [Line: CAB Ledger Title]

    Use : CAB Ledger Line


    Local : Field : Default : Type : String
    Local : Field : Default : Align : Centre
    Local : Field : Default : Style : Normal Bold

    Local : Field : CAB Led No : Set as : “Sl. No”
    Local : Field : CAB Led Name : Set as : “Ledger Name”
    Local : Field : CAB Led address : Set as : “Address”
    Local : Field : CAB Led PHONE : Set as : “PHONE NUMBER”

    Local : Field : CAB Led CB : Set as : “Closing Balance”

    Border : Thin Top Bottom

    [Line: CAB Ledger Line]
    Border:thin cover

    Fields : CAB Led No, CAB Led Name,CAB Led Address,CAB Led PHONE, CAB Led CB
    Repeat : CAB Led CB
    /*Option : AlterOnEnter ;;;Alter on enter will open the ledger master of the same ledger on which enter was pressed*/

    [#Form: CAB Ledger Form]
    Add : Button : WhatsApp


    [Button: WhatsApp]
    Option : SalesjayA

    [!Button: SalesjayA]
    Key : Alt + W
    Action : Browse URL : "http://web.whatsapp.com/send/?Phone=" + @@GetContacts

    [Field: CAB Led No]

    Set as : $$Line ;;;setting the line number to the field
    Width : 3
    Align : Centre
    Border : Thin Right
    Alter : Ledger
    Skip:Yes

    [Field: CAB Led Name]

    Use : Name Field
    Set as : $Name ;;;set ledger name to field
    Border : Thin Right

    Width:80
    Style:STYLE
    Skip:Yes


    [Field: CAB LedAddress]

    Set as : $STPartyFullAdd ;;;set party address to the field
    Width : 60
    Border : Thin Right
    Use : Name Field
    Style : AltUnitMsgStyle
    Skip:Yes



    [Field: CAB Led PHONE]

    Set as : $LedgerMobile ;;;set state name

    Border : Thin Right
    Use : Name Field
    Width:LARGER
    Style:STYLE
    Width:30
    Align:Right
    Read Only:Yes










    [Field: CAB Led CB]

    Use : Amount Forex Field
    Set as : $ClosingBalance
    Border:Thin Right
    Space Right:10
    Format : "Symbol,DrCr"
    Style : AltUnitMsgStyle
    Width:LARGER
    Skip:Yes


    [Style : AltUnitMsgStyle]

    Height : 15
    Bold : Yes


    [Style : STYLE]

    Height : 25
    Bold : Yes





    [Collection: CAB My Ledgers]

    Type : Ledger
    Child of : $$GroupSundryDebtors
    Belongs to : Yes
    Sort:default :$closingbalance


    Fetch : Name, STPartyFullAdd, StateName, Pincode, LedgerContact, LedgerPhone, LedgerFax, Email, ClosingBalance



    Filter:ZeroClosing

    [System:formula]
    Zeroclosing:$ClosingBalance >0



    [System:Formula]
    GetContacts :$LedgerMobile:Ledger:$PartyLedgerName
     
    Last edited: Sep 17, 2021


  2. Murali.R

    Murali.R Member


    Please Change
    [System:Formula]
    GetContacts :$LedgerMobile:Ledger:#CABLedName
     


  3. ANURAG954245

    ANURAG954245 Member


    Thanks for replying but still its not working
     


  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Set as:$LedgerMobile:Ledger:$Name
     


  5. ANURAG954245

    ANURAG954245 Member


    nope still the whatsapp web is not able to open the link with the mobile number of the ledger
     


  6. Siddharth Agrawal

    Siddharth Agrawal New Member


    Try @@VchContactNo
     


  7. ANURAG954245

    ANURAG954245 Member


    nope still getting upload_2021-9-20_14-56-6.png this only upload_2021-9-20_14-56-48.png
     


  8. Siddharth Agrawal

    Siddharth Agrawal New Member


    What is the objective of your code ?

    Your code creates a list of all debtors.

    What next are you trying to accomplish ??

    Option A : Send the list to a particular person
    Option B : Send a message all the debtors in the list about their Balances/ other details.

    Because, it seems the Whatsapp link is incomplete. The message body is not their.
     


  9. ANURAG954245

    ANURAG954245 Member


    i just want to accomplish that when i open the report and click alt+w the link should open the chat of the respected ledger i am on ,
    i dont want to send any predefined text
    but whenever i am clicking alt+w the link is only opening this [​IMG] whithout the number that i a on the ledger
     


  10. Anil Mishra

    Anil Mishra New Member


    your object is ledger so you can fetch mobile number direct by $LedgerMobile
     


  11. mahbu

    mahbu Member


    I modified your code it is working now

    [#Menu: Gateway of Tally]
    Add : Item : Before : @@locQuit : Company Ledger/Sub Group List : Alter : CAB Ledger List
    [Report: CAB Ledger List]
    Form : CAB Ledger Form
    Title : "Company Ledger List"
    [Form: CAB Ledger Form]
    Parts : CAB Ledger Part
    Height : 100% screen ;;;defining height of form as 100% sccreen
    Width : 100% screen ;;;defining width of form as 100% sccreen
    Add:Button:F12ConfigureButton
    [Part: CAB Ledger Part]
    Lines : CAB Ledger Title, CAB Ledger Line
    Repeat : CAB Ledger Line : CAB My Ledgers ;;;line will repeat on the collection of the ledger
    CommonBorder: Yes
    Scroll : Vertical
    [Line: CAB Ledger Title]
    Use : CAB Ledger Line
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Centre
    Local : Field : Default : Style : Normal Bold
    Local : Field : CAB Led No : Set as : "Sl. No"
    Local : Field : CAB Led Name : Set as : "Ledger Name"
    Local : Field : CAB Led address : Set as : "Address"
    Local : Field : CAB Led PHONE : Set as : "PHONE NUMBER"
    Local : Field : CAB Led CB : Set as : "Closing Balance"
    Border : Thin Top Bottom
    [Line: CAB Ledger Line]
    Border:thin cover
    Fields : CAB Led No, Whatsapplink,CAB Led Name,CAB Led Address,CAB Led PHONE, CAB Led CB
    Repeat : CAB Led CB
    Add: Key : WhatsApp
    Local : Key : WhatsApp: Add: Scope:Selected Lines
    Local : Key : WhatsApp : Delete : Action
    Local : Key : WhatsApp : Add:Action : Browse URL : #Whatsapplink

    /*Option : AlterOnEnter ;;;Alter on enter will open the ledger master of the same ledger on which enter was pressed*/
    [#Form: CAB Ledger Form]
    Add : Button : WhatsApp
    [Button: WhatsApp]
    Option : SalesjayA
    [!Button: SalesjayA]
    Key : Alt + W
    Action : Browse URL : #Whatsapplink
    [Field : Whatsapplink]

    Use : Name Field
    Set as :($$LocaleString:"http://wa.me/+91"+$LedgerMobile) ;;; CHECK COUNTRY CODE
    Invisible : Yes
    Width : 20
    [Field: CAB Led No]
    Set as : $$Line ;;;setting the line number to the field
    Width : 3
    Align : Centre
    Border : Thin Right
    Alter : Ledger
    Skip:Yes
    [Field: CAB Led Name]
    Use : Name Field
    Set as : $Name ;;;set ledger name to field
    Border : Thin Right
    Width:80
    Style:STYLE
    Skip:Yes
    [Field: CAB LedAddress]
    Set as : $STPartyFullAdd ;;;set party address to the field
    Width : 60
    Border : Thin Right
    Use : Name Field
    Style : AltUnitMsgStyle
    Skip:Yes
    [Field: CAB Led PHONE]
    Set as : $LedgerMobile ;;;set state name
    Border : Thin Right
    Use : Name Field
    Width:LARGER
    Style:STYLE
    Width:30
    Align:Right
    Read Only:Yes
    [Field: CAB Led CB]
    Use : Amount Forex Field
    Set as : $ClosingBalance
    Border:Thin Right
    Space Right:10
    Format : "Symbol,DrCr"
    Style : AltUnitMsgStyle
    Width:LARGER
    Skip:Yes
    [Style : AltUnitMsgStyle]
    Height : 15
    Bold : Yes
    [Style : STYLE]
    Height : 25
    Bold : Yes
    [Collection: CAB My Ledgers]
    Type : Ledger
    Child of : $$GroupSundryDebtors
    Belongs to : Yes
    Sort:default :$closingbalance
    Fetch : Name, STPartyFullAdd, StateName, Pincode, LedgerContact, LedgerPhone, LedgerFax, Email, ClosingBalance
    Filter:ZeroClosing
    [System:formula]
    Zeroclosing:$ClosingBalance >0
    [System:Formula]
    GetContacts :$LedgerMobile:Ledger:$PartyLedgerName
     


  12. sandeepbhawsar

    sandeepbhawsar New Member


    wants to add massage with this so how can i add
     


  13. mahbu

    mahbu Member


    Set as :($$LocaleString:"http://wa.me/+91"+$LedgerMobile)+"?text=Your Message"
     


Share This Page