Customized SMS | RanceLab Help

Keywords	Meaning
<No-Of-Memo-Yesterday>	Total No of Memo entered yesterday
<No-Of-Memo-Today>	Total No of Memo entered today
<Total-Amount-Today>	Total Bill Amount today
<Total-Amount-Yesterday>	Total Bill Amount yesterday
<Total-Qty-Today>	Total Bill Quantity today
<Total-Qty-Yesterday>	Total Bill Quantity yesterday
<No-Of-Memo-MTD>	Total No of Memo entered month till date
<Total-Amount-MTD>	Total Bill amount month till Date
<Total-Qty-MTD>	Total Bill quantity month till date
<No-Of-Memo-YTD>	Total No of Memo entered year till date
<Total-Amount-YTD>	Total Bill amount year till Date
<Total-Qty-YTD>	Total Bill quantity year till date
<Location>	Location Name

Examples:

Module	Format	Output
Sale	<Location> (Sale -Today): Tot Memo=<No-Of-Memo-Today>, Tot Qty=<Total-Qty-Today>, Tot Amt=Rs. <Total-Amount-Today>	Raipur (Sale -Today): Tot Memo=1458, Tot Qty=12458, Tot Amt=Rs. 128756.00.
Sales Return	<Location> (Sale Return -Yesterday): Tot Memo=<No-Of-Memo-Yesterday>, Tot Qty=<Total-Qty-Yesterday>, Tot Amt=Rs. <Total-Amount-Yesterday>,	Raipur (Sale Return -Yesterday): Tot Memo=1011, Tot Qty=10058, Tot Amt=Rs. 128756.00
Sales Order	<Location> (Sale Order -Today): Tot Memo=<No-Of-Memo-Today>, Tot Qty=<Total-Qty-Today>, Tot Amt=Rs. <Total-Amount-Today>,	Raipur (Sale Order -Today): Tot Memo=1458, Tot Qty=12458, Tot Amt=Rs. 128756.00
Purchase	<Location> (Purchase -Today): Tot Memo=<No-Of-Memo-Today>, Tot Qty=<Total-Qty-Today>, Tot Amt=Rs. <Total-Amount-Today>,	Raipur (Purchase -Today): Tot Memo=1458, Tot Qty=12458, Tot Amt=Rs. 128756.00
Purchase Return	<Location> (Purchase Return -Today): Tot Memo=<No-Of-Memo-Today>, Tot Qty=<Total-Qty-Today>, Tot Amt=Rs. <Total-Amount-Today>,	Raipur (Purchase Return- Today): Tot Memo=1458, Tot Qty=12458, Tot Amt=Rs. 128756.00.
Outstanding Reminder	Dear <Customer-Name>, Thank you for shopping with us. We are pleased to provide you with a summary of outstanding balance. Your Card ID <CardID> Total Due is <Currency> <Amount>. Please ignore if already paid.	Dear Sumit Sharma, Thank you for shopping with us. We are pleased to provide you with a summary of outstanding balance. Your Card ID C00459 Total Due is Rs.12750/-. Please ignore if already paid.

Keyword	Meaning
<Account-Name>	Ledger Name
<Opening-Today>	Today's Opening Balance
<Debit-Today>	Today's Debit
<Credit-Today>	Today's Credit
<Balance-Today>	Today's Closing Balance
<Opening-Yesterday>	Yesterday's Opening Balance
<Debit-Yesterday>	Yesterday's Debit
<Credit-Yesterday>	Yesterday's Credit
<Balance-Yesterday>	Yesterday's Closing Balance
<Location>	Location Name

Examples:

Module	Format	Output
Cash	<Location> (Cash Report- Today) : Ledger=<Account-Name>, Opening =Rs.<Opening-Today>, Debit=Rs. <Debit-Today>, Credit = Rs. <Credit-Today>, Balance=Rs. <Balance-Today>	NewDelhi (Cash Report- Today): Ledger=M/s Suraj Garments, Opening =Rs. 5000.00, Debit=Rs. 55000.00, Credit =Rs. 40000.00, Balance=Rs. 20000.00
Bank	<Location> (Bank Report- Today) : Ledger=<Account-Name>, Opening =<Opening-Today>, Debit=<Debit-Today>, Credit = <Credit-Today>, Balance=<Balance-Today>	NewDelhi (Bank Report- Today): Ledger=HDFC Bank, Opening =Rs. 5000.00, Debit=Rs. 55000.00, Credit =Rs. 40000.00, Balance=Rs. 20000.00

Keyword	Meaning
<Memo-No>	Memo No
<Memo-Date>	Memo Date
<Quantity>	Quantity
<Amount>	Bill Amount
<Customer-Name>	Customer Name
<Balance-Point>	Balance Point
<Location>	Location Name

Example:

Module	Format	Output
Sale	Dear <Customer-Name>, Thank you for your purchase against Memo no =<Memo-No>, of Rs.<Amount>, on <Memo-Date> in our <Location> Location. Your balance point is <Balance-Point>.	Dear Sumit Sharma, Thank you for your purchase against Memo no =10/1028, of Rs.4250.00, on 14-Mar-2010 in our New town Location. Your balance point is 1245.

Keyword	Meaning
<Memo-No>	Memo No
<Memo-Date>	Memo Date
<Amount>	Bill Amount
<Account-Name>	Ledger Name
<Due>	Outstanding
<Narration>	Narration of Voucher
<Reference-Date>	1st Ref Date
<Reference-No>	1st Ref No
<Reference-Amount>	1st Ref Amount
<Location>	Location Name

Example:

Module	Format	Output
Payment	Paid to <Account-Name>, Rs.<Amount>, on <Memo-Date>, against <Memo-No>, Due= Rs. <Due>.	Paid to Flying Kings and Co., Rs.14000.00, on 14-Mar-2010, against 10/124, Due= Rs. 125634.00

Keyword	Meaning
<Memo-No>	Memo No
<Memo-Date>	Memo Date
<Track-Number>	Track Number
<Customer-Name>	Customer Name
<Location>	Location Name

Example:

Module	Format	Output
Recd From Jobber	Dear <Customer-Name>, Please collect your alteration product against Memo = <Memo-No>, created on <Memo-Date>, having Track no = <Track-Number> in our <Location> Location	Dear Sudeshna Reddy, Please collect your alteration product against Memo = 10/458, created on 14-Mar-2010, having Track no = 1245 in our Rourkella Location.

Keyword	Meaning
<Memo-No>	Memo No
<Memo-Date>	Memo Date
<Customer-Name>	Customer Name
<Amount>	Bill Amount
<Prepaid-Balance>	Prepaid Card Balance
<Trans-Type>	Prepaid Transaction Type (Fill, Refill, Refund)
<MOP>	MOP Name
<CardID>	Customer Card ID
<Location>	Location Name

Example:

Module	Format	Output
Prepaid	Dear <Customer-Name>, CardID=<CardID>, your card is successfully <Trans-Type>ed with Rs. <Amount>, against Memo no= <Memo-No>, on <Memo-Date> by <MOP>, in our <Location> Location. Your prepaid balance is Rs.<Prepaid-Balance>.	Dear Reshmi Singh, CardID=100408, your card is successfully Refilled with Rs. 4500.00, against Memo no= 10/1456, on 15-Mar-2010 by Cash, in our Raipur Location. Your prepaid balance is Rs.6500.00.

Keyword	Meaning
<Memo-No>	Memo No
<Memo-Date>	Memo Date
<Customer-Name>	Customer Name
<Quantity>	Quantity
<Amount>	Bill Amount
<CardID>	Customer Card ID
<Memo-Date>	Memo Date
<Prepaid-Amount>	Amount spent in Sale
<Prepaid-Balance>	Prepaid Card Balance
<Location>	Location Name

Example:

Module	Format	Output
Prepaid Sale	Dear <Customer-Name>, CardID=<CardID>, Thank you for your purchase against Memo No=<Memo-No>, of Rs. <Amount>, on <Memo-Date>, in our <Location> Location. Your Prepaid Balance is Rs.<Prepaid-Balance>.	Dear Manoj Tiwari, CardID =104578, Thank you for your Purchase against Memo No=10/4589, of Rs. 2456.00, on 12-Mar-2010, in our Jharsuguda Location. Your Prepaid Balance is Rs.3250.00.

Keyword	Meaning
<Customer-Name>	Customer Name
<CardID>	Customer Card ID
<Customer-Type>	Customer Type
<Card-Type>	Card Type
<Balance-Point>	Balance Point
<Location>	Location Name

Example:

Module	Format	Output
Birthday	Dear <Customer-Name>,CardID=<CardID>, My Company wishes you a Very Happy Birthday	Dear Sumit Sharma,CardID=100245, My Company wishes you a Very Happy Birthday.
AnniversaryDay	Dear <Customer-Name>,CardID=<CardID>, My Company wishes you a very Happy Anniversary and many happy returns of the day.	Dear Ravi Kapur,CardID=100089, My Company wishes you Happy Anniversary and many happy returns of the day.

Keyword	Meaning
<Recipient-Name>	Recipient Name
<Location>	Location Name

Example:

Module	Format	Output
SMS Now	Dear <Recipient-Name>, SMS Tool is now available in RanceLab.	Dear Ritesh Nandi, SMS Tool is now available in RanceLab.

http://bulksmsindia.mobi/sendurlcomma.asp?

user=XXXXXX&

pwd=XXXXXX&

senderid=XXXXXXX&

mobileno=<Mobile-Number>&

msgtext=<Message>

1.Go to Main Menu > Settings > SMS Settings > Business Summary (T >M >S)

2.Alt + L

3.Select location from the list

4.Go to specified Fields (as Sales, Sales Return, Sales Order etc)

5.Create a SMS Format string using the variables mentioned below

6.Save

7.Check the SMS in scheduled time.

For more details please visit:

•http://www.rancelab.com/help/RanceLab-sms-settings.htm