Hell Sir I am trying to fetch ledger balance of customer, but it’s showing Zero balance, so from where i can increase ledger balance of a customer. Thanx & Regards Rohit
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/qSA-MD_BD1YJ .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit 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
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com .
To post to this group, send email to er…@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com .
To post to this group, send email to er...@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out .