Multiple Customer Account Statements

You cannot do custom reports on ERPNext Cloud. I have already built a custom workaround for this -
New doctype and child table. We input the due date and it shows all outstanding invoices and then I can print them all at once to PDF. I then use Acrobat to split the PDF and we email them.

That sounds like a lot of work for something that should be a click of a button

It is!! I want it be as easy as clicking a button and emailing them!

I refuse to give up

So many basic features that are missing. No one seem to be listening

1 Like

it is a lot of work for them too. if you could do it and share… :slight_smile: everyone could benefit too. i really wish know Python + GIT + linux. My three Achilles heel.

Good Day

Could you email me: albertusgeyser@gmail.com

To discuss ERPNext Reports.

Thank You
Albertus Geyser

Yes would be awesome if you could share how you achieved this
even with jasper reports

Good Day

My new Jasper Reports Statement promised to post:

Please show me how many interested then i will upload Jasper Reports file to use on your ERPNext Database.

Thank You

Albertus Geyser

i am very very very interested

2 Likes

Count me in. Thanks.

1 Like

I think this will be very helpful.
I am in.

1 Like

Good Day All

I saw this from a link i received and like this approach of System 1A:

This could help allot.

Thank You

Albertus Geyser

Good Day

Herewith Link to updated Jasper Reports Customer Statement:

1 Like

Check out feat(AR/AP): Group By, Cost Center, Mark Overdue by SaiFi0102 · Pull Request #17668 · frappe/erpnext · GitHub

1 Like

It’s a pity that this important feature is not done yet as part of core. Please look at it.

yes i second that sad

For people finding this, this last post may also help

2 Likes

@dirkvdl16 This is a brilliant app! Well done! however, it has a few drawbacks. First and most important, doesn’t take into account multi-company instances. There should be a filter to pull customers based on properties such as company.

Also, i get this error when i try to preview a statement. I assume this is also related to the fact that my instance has multiple companies:

This is a fantastic effort though. Thank you!

Thanks for your feedback! The issue has been fixed.
All the best

2 Likes