Statement of Account report

[lxnow]

Is there a Statement of Account report for a customer that is readily available for printing?

[Nabin Hait]

You can use General Ledger report, filter based on customer account and then export to excel and print.

On 11 Sep 2013 20:06, "lxnow" <laur...@union.ph> wrote:

Is there a Statement of Account report for a customer that is readily available for printing?

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

[lxnow]

Thanks for the response, though I was hoping for something more HTML-based that can be readily printed.

On Thursday, September 12, 2013 12:15:28 AM UTC+8, Nabin Hait wrote:

You can use General Ledger report, filter based on customer account and then export to excel and print.

On 11 Sep 2013 20:06, "lxnow" <laur...@union.ph> wrote:

Is there a Statement of Account report for a customer that is readily available for printing?

--
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+unsub...@googlegroups.com.

[Addy]

Once again I agree with you Laurence.

Currently to send a statement from erpnext is a long process if which includes an extra step of exporting the statement from G/L to csv first and then we need to format that CSV file and then print.

Alas if this process could be shortened ( We really do demand a lot from you guys).

[lxnow]

So it isn't just me :-)

[Rajendren Subramaniam]

Please please please do something about reporting. Exporting to excel and printing from there defeats the purpose of having an automated system.

On Thursday, September 12, 2013 5:12:07 PM UTC+8, Addy wrote:

[furniture.elegance]

Hi guys.
If there is anything we feel should be tops on the programmers list, it should be the statements.
We thought we were the only ones in dire need of this!
A fully automated statements is a must have..any one out there who has cracked it?
Firoze

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

[lxnow]

Please add idea contributions on how else this can be implemented to GitHub. There's already an issue for this (https://github.com/webnotes/erpnext/issues/847). This way, Webnotes can stay organized with priorities. 

On Thursday, November 21, 2013 12:16:27 PM UTC+8, Furniture Elegance wrote:

Hi guys.
If there is anything we feel should be tops on the programmers list, it should be the statements.
We thought we were the only ones in dire need of this!
A fully automated statements is a must have..any one out there who has cracked it?
Firoze

On Nov 21, 2013 6:54 AM, "Rajendren Subramaniam" <ra...@nk.com.my> wrote:

Please please please do something about reporting. Exporting to excel and printing from there defeats the purpose of having an automated system.

On Thursday, September 12, 2013 5:12:07 PM UTC+8, Addy wrote:

Once again I agree with you Laurence.

Currently to send a statement from erpnext is a long process if which includes an extra step of exporting the statement from G/L to csv first and then we need to format that CSV file and then print.

Alas if this process could be shortened ( We really do demand a lot from you guys).

On Thursday, September 12, 2013 5:09:41 AM UTC+5:30, lxnow wrote:

Thanks for the response, though I was hoping for something more HTML-based that can be readily printed.

On Thursday, September 12, 2013 12:15:28 AM UTC+8, Nabin Hait wrote:

You can use General Ledger report, filter based on customer account and then export to excel and print.

On 11 Sep 2013 20:06, "lxnow" <laur...@union.ph> wrote:

Is there a Statement of Account report for a customer that is readily available for printing?

--
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+unsubscribe@googlegroups.com.

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

[Rushabh Mehta]

Yeah - this should certainly be priority.!

Any references (sample formats?)

[Mahesh]

I too am in need of statements And various types of these.

Going to General Report / filter customer / export to csv is a bit tedius process and should be shortened.

I would suggest, a "form" that captures a customer or supplier id, then filters list of records ( sales, item report, purchase vouchers, list goes on and on ) can be worked out with.

So it will have fetched tabular data into the form which will have a one or multiple print format and the statements can be EMAILED / PRINTED / just like any other doc

A simillar process like creating Invoice, or Sales Order ( except putting values in item table, a filter query fetches values of List-of-Invoices-or-vouchers-based-on more criteria )

a suggestion that just came to my mind.

Regards,
Mahesh

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

[Rajesh Sadashiven]

Hi Rushabh

Can you do something on reports as it is really time consuming to export reports as CSV format then editing it and then creating a PDF. Please do something for the same as it is really time consuming. This is the only aspect which ERPnext is lacking

Please do update 

Rajesh

[Rushabh Mehta]

Thanks for reminding. Is this format okay?

https://github.com/frappe/erpnext/issues/847


@rushabh_mehta

https://erpnext.org

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/9ccb7c01-9dc8-42c2-903b-e859d47286f8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Rajendren Subramaniam]

As mentioned in this mail trail on 21/11/2013 that “Exporting to excel and printing from there defeats the purpose of having an automated system.” Lack of proper reporting has caused me to start evaluating other system to rollout for our clients. Hence ERPnext has potential of losing rollout to few thousand clients.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@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 User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-fo...@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 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/9ccb7c01-9dc8-42c2-903b-e859d47286f8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

 

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/PHv8aYWY87o/unsubscribe.
To unsubscribe from this group and all its topics, 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/428F2A54-38D8-49F8-8AB0-45A10926F980%40gmail.com.

[furniture.elegance]

hi guys...

this is one issue i wish the team would give priority?

firoze

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/037b01cf861a%243b2a18c0%24b17e4a40%24%40gmail.com.

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

--
- - -
Furniture Elegance Ltd.
Paramount Plaza
P.O. Box 8776-00200
NAIROBI

Tel: 0702-842500 / 0722-206060
Web: www.elegance.co.ke

[Dimeji]

I lend my voice to this also . Its always a pain exporting first to excel then using pivot tables etc.

A dynamic and robust reporting system will add immense value to an already fantastic application .

I do hope the team will prioritize this .

Rgds

---

From: "furniture.elegance" <furniture...@gmail.com>

Sender: erpnext-u...@googlegroups.com

Date: Thu, 12 Jun 2014 12:15:04 +0300

To: <erpnext-u...@googlegroups.com>

ReplyTo: erpnext-u...@googlegroups.com

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

[Rajesh Sadashiven]

Hi Rushabh

The format seems good as long as the details are available for all ledger accounts. Also appreciate if you could extend the same to all the reports where the present reporting is in CSV Format.

Appreciate if you could please do implement it ASAP since many of my business associates in Sri lanka who are using Tally ERP had found your cloud software better and more useful and I have already recommended to them since they  also find your software economical , user friendly and more informative when compared to the present expenditure they are incurring

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

[Rushabh Mehta]

Rajesh,

This feature has been built and will be released next week. Thanks for the feedback and recommending ERPNext :)

best,

Rushabh

@rushabh_mehta

https://erpnext.org

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/3c445ba1-35d7-400d-ae0a-b1432c1e4725%40googlegroups.com.

[Rajesh]

Thanks for your quick response. Please do inform me once it is implemented and also the procedure to get the reports in the format you had mentioned. I am not a software professional. Therefore kindly update me on the same.

One more point is there a possibility to record the Over Time and Special Over time in projects since my factory runs all 365 days and I need to batch the Time Log through Projects which I am trying to do . This will also help me to ascertain the costing on product wise manufacture for better MIS and Cost Control

Please do advise

--
You received this message because you are subscribed to a topic in the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-user-forum/PHv8aYWY87o/unsubscribe.
To unsubscribe from this group and all its topics, 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/87A58F4E-948E-427B-AF30-5D7D166B033F%40gmail.com.

[Rushabh Mehta]

On 12-Jun-2014, at 9:00 pm, Rajesh <roc...@gmail.com> wrote:

Thanks for your quick response. Please do inform me once it is implemented and also the procedure to get the reports in the format you had mentioned. I am not a software professional. Therefore kindly update me on the same.

They will be updated in the product itself.

One more point is there a possibility to record the Over Time and Special Over time in projects since my factory runs all 365 days and I need to batch the Time Log through Projects which I am trying to do . This will also help me to ascertain the costing on product wise manufacture for better MIS and Cost Control

Please do advise

If you can detail down the requirement, there could be many ways to get this done. Maybe one of our partners can help you.

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