Hell Sir
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/d/msg/erpnext-developer-forum/-/qSA-MD_BD1YJ .https://groups.google.com/groups/opt_out .
rmehta
March 11, 2013, 4:24am
#2
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .
Hello sir
I used following query for accessing a ledger balance
function sd(ff)
{
wn.call({
method: "accounts.utils.get_balance_on",
args: {account: ff, date: doc.posting_date},
callback: function(r) {
doc.customer_balance = format_currency(r.message, erpnext.get_currency(doc.company));
refresh_field('customer_balance');
// msgprint(customer_balance);
}
})
}
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 9:54 AM, Rushabh Mehta
<rm...@gmail.com > wrote:
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .
Code looking correct.
Check whether "GL Entry" for that customer account exists. "GL Entry" records are created for each account entry.
On 11-Mar-2013, at 2:42 PM, Rohit Waghchaure wrote:
Hello sir
I used following query for accessing a ledger balance
function sd(ff)
{
wn.call({
method: "accounts.utils.get_balance_on",
args: {account: ff, date: doc.posting_date},
callback: function(r) {
doc.customer_balance = format_currency(r.message, erpnext.get_currency(doc.company));
refresh_field('customer_balance');
// msgprint(customer_balance);
}
})
}
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 9:54 AM, Rushabh Mehta
<rm...@gmail.com > wrote:
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un…@googlegroups.com .er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .
Hell sir
I have successfully retrieve ledger balance in sales invoice but when i create new sales invoice for that customer it shows same amount as it show previous. I want to reduce the balance when new sales invoice generate for that customer. When ledger balance increases or decreases for particular customer
How to check current ledger balance of customer
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 2:51 PM, Nabin Hait
<na...@gmail.com > wrote:
Code looking correct.
Check whether "GL Entry" for that customer account exists. "GL Entry" records are created for each account entry.
On 11-Mar-2013, at 2:42 PM, Rohit Waghchaure wrote:
Hello sir
I used following query for accessing a ledger balance
function sd(ff)
{
wn.call({
method: "accounts.utils.get_balance_on",
args: {account: ff, date: doc.posting_date},
callback: function(r) {
doc.customer_balance = format_currency(r.message, erpnext.get_currency(doc.company));
refresh_field('customer_balance');
// msgprint(customer_balance);<br> <br> }<br><br>})<br>}<br><br></div>Thanx & Regards<br></div>Rohit<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Mar 11, 2013 at 9:54 AM, Rushabh Mehta <span dir="ltr"><<a href="mailto:rm...@gmail.com" target="_blank">rm...@gmail.com</a>></span> wrote:<br>
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .
system
March 12, 2013, 6:22am
#6
Hi Rohit,
Make the field as allow on submit.
Then call the calculate function in the event:
cur_frm.cscript.custom_on_submit = function() {
}
if you want to save the value in the current doc, then in the callback of get balance call, run:
cur_frm.save("Update");
Thanks,
Anand.
Hell sir
I have successfully retrieve ledger balance in sales invoice but when i create new sales invoice for that customer it shows same amount as it show previous. I want to reduce the balance when new sales invoice generate for that customer. When ledger balance increases or decreases for particular customer
How to check current ledger balance of customer
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 2:51 PM, Nabin Hait
<na...@gmail.com > wrote:
Code looking correct.
Check whether "GL Entry" for that customer account exists. "GL Entry" records are created for each account entry.
On 11-Mar-2013, at 2:42 PM, Rohit Waghchaure wrote:
Hello sir
I used following query for accessing a ledger balance
function sd(ff)
{
wn.call({
method: "accounts.utils.get_balance_on",
args: {account: ff, date: doc.posting_date},
callback: function(r) {
doc.customer_balance = format_currency(r.message, erpnext.get_currency(doc.company));
refresh_field('customer_balance');
// msgprint(customer_balance);
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 9:54 AM, Rushabh Mehta
<rm…@gmail.com > wrote:
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un…@googlegroups.com .er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .
system
March 12, 2013, 6:23am
#7
Hi Rohit,
Sorry. This will also work without making the field allow on submit. Ignore that part. Keep the field as read only.
-Anand.
Hi Rohit,
Make the field as allow on submit.
Then call the calculate function in the event:
cur_frm.cscript.custom_on_submit = function() {
}
if you want to save the value in the current doc, then in the callback of get balance call, run:
cur_frm.save("Update");
Thanks,
Anand.
Hell sir
I have successfully retrieve ledger balance in sales invoice but when i create new sales invoice for that customer it shows same amount as it show previous. I want to reduce the balance when new sales invoice generate for that customer. When ledger balance increases or decreases for particular customer
How to check current ledger balance of customer
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 2:51 PM, Nabin Hait
<na...@gmail.com > wrote:
Code looking correct.
Check whether "GL Entry" for that customer account exists. "GL Entry" records are created for each account entry.
On 11-Mar-2013, at 2:42 PM, Rohit Waghchaure wrote:
Hello sir
I used following query for accessing a ledger balance
function sd(ff)
{
wn.call({
method: "accounts.utils.get_balance_on",
args: {account: ff, date: doc.posting_date},
callback: function(r) {
doc.customer_balance = format_currency(r.message, erpnext.get_currency(doc.company));
refresh_field('customer_balance');
// msgprint(customer_balance);
Thanx & Regards
Rohit
On Mon, Mar 11, 2013 at 9:54 AM, Rushabh Mehta
<rm…@gmail.com > wrote:
Rohit,
Can you tell us how are you accessing the ledger balance? Preferably using gist / pastebin.
thanks,
Rushabh
– erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un…@googlegroups.com .er…@googlegroups.com .https://groups.google.com/groups/opt_out .
– erpnext-developer-forum+un...@googlegroups.com .er...@googlegroups.com .https://groups.google.com/groups/opt_out .