Ledger balance

Hello All,

   I have to fetch ledger balance in sales invoice. Is there any function exists for this?

Thank you 

Regards,
Gangadhar kadam



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/-/PJbgFqIoMIsJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Hi Gangadhar,

Check "get_balance_on" function in accounts/utils.py. The function returns account balance on any given date.
If you want to call from client side use wn.call method. For example, you can check accounts/doctype/journal_voucher/journal_voucher.js

Regards,
Nabin Hait

On 05-Mar-2013, at 8:01 PM, gangadhar kadam wrote:

Hello All,
   I have to fetch ledger balance in sales invoice. Is there any function exists for this?

Thank you 

Regards,
Gangadhar kadam



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/-/PJbgFqIoMIsJ.

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.

 

 

Thank you Nabin Sir,

I have gone through the code ,for get_balance_on function we pass account and it returns the amount for that account. I have to implement this logic on selection of customer in sales invoice. I have check the customer and Account doctype these dont have any direct relation between them. How can i implement this logic.

Regards,
Gangadhar kadam

On 6 March 2013 10:27, Nabin Hait <na...@gmail.com> wrote:
Hi Gangadhar,

Check "get_balance_on" function in accounts/utils.py. The function returns account balance on any given date.
If you want to call from client side use wn.call method. For example, you can check accounts/doctype/journal_voucher/journal_voucher.js

Regards,
Nabin Hait

On 05-Mar-2013, at 8:01 PM, gangadhar kadam wrote:

Hello All,
I have to fetch ledger balance in sales invoice. Is there any function exists for this?

Thank you

Regards,
Gangadhar kadam



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/-/PJbgFqIoMIsJ.

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.







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

 

 

Hi Gangadhar,

Account that is of Master Type "Customer" has a link to the Customer.

Thanks,
Anand.

On 06-Mar-2013, at 2:45 PM, गंगाधर कदम <em...@gmail.com> wrote:

Thank you Nabin Sir,
    I have gone through the code ,for get_balance_on function we pass account and it returns the amount for that account. I have to implement this logic on selection of customer  in sales invoice. I have check the customer and Account doctype these dont have any direct relation between them. How can i implement this logic.

Regards,
Gangadhar kadam

On 6 March 2013 10:27, Nabin Hait <na...@gmail.com> wrote:
Hi Gangadhar,

Check "get_balance_on" function in accounts/utils.py. The function returns account balance on any given date.
If you want to call from client side use wn.call method. For example, you can check accounts/doctype/journal_voucher/journal_voucher.js

Regards,
Nabin Hait

On 05-Mar-2013, at 8:01 PM, gangadhar kadam wrote:

Hello All,
   I have to fetch ledger balance in sales invoice. Is there any function exists for this?

Thank you 

Regards,
Gangadhar kadam



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/-/PJbgFqIoMIsJ.

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.

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

 

 

Hello,

This statement is quite ambiguous:

Can you explain just a bit more, please?

Thanks.

@ugommirikwe This is a very old post and many changes have happened on the G/L and account front on erpnext after that and hence I would request you to kindly ask a new question if you are unable to understand something.