Closing Balance of Customer

Hi,

I am trying to build a custom sales invoice report, using the report button under sales invoice, wherein I require a column of customer's "closing balance" (/may be "current balance as on date") to be shown. Is there a column available with the information?

The sales register report shows an outstanding amount of a single invoice. Just thinking of a remote possibility where the payment of customer is not adjusted against the invoice by the user.

regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdWo_dGO7RpjE_JDx94%3D67c4F13e-dYnP4cqxqMY4uv0Q%40mail.gmail.com.

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


Hi,

I am trying to build a custom sales invoice report, using the report button under sales invoice, wherein I require a column of customer's "closing balance" (/may be "current balance as on date") to be shown. Is there a column available with the information?

Try this

/api/method/erpnext.accounts.utils.get_balance_on?account=&date=

https://github.com/frappe/erpnext/blob/develop/erpnext/accounts/utils.py#L43


The sales register report shows an outstanding amount of a single invoice. Just thinking of a remote possibility where the payment of customer is not adjusted against the invoice by the user.

You can add it later. Payment Reconciliation Tool is due redesign (got nixed between versions 3 and 4)


regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdWo_dGO7RpjE_JDx94%3D67c4F13e-dYnP4cqxqMY4uv0Q%40mail.gmail.com.

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




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/8C5C38C7-AA78-4CFC-856E-6B27053AD6D6%40gmail.com.

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

Hi,


On Sun, Jul 6, 2014 at 9:59 AM, Rushabh Mehta <rm...@gmail.com> wrote:

Hi,

I am trying to build a custom sales invoice report, using the report button under sales invoice, wherein I require a column of customer's "closing balance" (/may be "current balance as on date") to be shown. Is there a column available with the information?

Try this

/api/method/erpnext.accounts.utils.get_balance_on?account=&date=



I was referring to a Database Column, here. Is there any possibility on getting the same. ??





The sales register report shows an outstanding amount of a single invoice. Just thinking of a remote possibility where the payment of customer is not adjusted against the invoice by the user.

You can add it later. Payment Reconciliation Tool is due redesign (got nixed between versions 3 and 4)


will wait for the tool....




regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdWo_dGO7RpjE_JDx94%3D67c4F13e-dYnP4cqxqMY4uv0Q%40mail.gmail.com.

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




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/8C5C38C7-AA78-4CFC-856E-6B27053AD6D6%40gmail.com.

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


thanks & regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdKF6FfObZPVugk2p8JQgjGb%3D0cmK0TEiqnOaZu1sy1hA%40mail.gmail.com.

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

Unable to understand what are you trying to do, can you be more specific


On 10-Jul-2014, at 12:35 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,


On Sun, Jul 6, 2014 at 9:59 AM, Rushabh Mehta <rm...@gmail.com> wrote:

Hi,

I am trying to build a custom sales invoice report, using the report button under sales invoice, wherein I require a column of customer's "closing balance" (/may be "current balance as on date") to be shown. Is there a column available with the information?

Try this

/api/method/erpnext.accounts.utils.get_balance_on?account=&date=



I was referring to a Database Column, here. Is there any possibility on getting the same. ??


 


The sales register report shows an outstanding amount of a single invoice. Just thinking of a remote possibility where the payment of customer is not adjusted against the invoice by the user.

You can add it later. Payment Reconciliation Tool is due redesign (got nixed between versions 3 and 4)


will wait for the tool....

 
 
 
 


regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdWo_dGO7RpjE_JDx94%3D67c4F13e-dYnP4cqxqMY4uv0Q%40mail.gmail.com.

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





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/8C5C38C7-AA78-4CFC-856E-6B27053AD6D6%40gmail.com.

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


thanks & regards
Akshay



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdKF6FfObZPVugk2p8JQgjGb%3D0cmK0TEiqnOaZu1sy1hA%40mail.gmail.com.

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




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/74530F5E-84C4-4EF7-AE2D-6B36E6EAC805%40gmail.com.

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