Closing Balance of Customer

[Akshay Mehta]

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

[Rushabh Mehta]

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-fo...@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.

[Akshay Mehta]

Hi,

On Sun, Jul 6, 2014 at 9:59 AM, Rushabh Mehta <rme...@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=

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

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-fo...@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-fo...@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

[Rushabh Mehta]

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

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