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.
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.
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.
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?
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.
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?
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.