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
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.
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 whithout the number that i a on the ledger
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