ERPNext Conference 2019* ERPNext.com Blog

Deleting column in reports


#1
To whom it may concern,

Would you know if it is possible to delete columns in

Query Report: Stock Ledger

Query Report: Warehouse-Wise Stock Balance

Stock Balance

In all these reports, the column I need the most (actual stock Quantity) is at the far right (not easily viewable)
I don't need any of the column, brand, description, Item Group, Item UoM, etc.
Any way I could not display these column (or displace them to the right).
For quite a few reports, one can edit the type of column we want and then save the report as a custom report.  Could we do that with these query report?  
I'm on frappecloud.
Thanks in advance for your help.
Best,
François

–

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/a795a02b-9f20-45e1-8cc8-cb604db5b278%40googlegroups.com.

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


#2
Francois, 

No it's not directly possible. But we can move the columns around. Please raise a ticket if its really urgent or add it to GitHub issues if it can wait a bit.

@rushabh_mehta
via mobile

On 12-Sep-2014, at 5:43 PM, François de Ryckel <f....@gmail.com> wrote:

To whom it may concern,

Would you know if it is possible to delete columns in

Query Report: Stock Ledger

Query Report: Warehouse-Wise Stock Balance

Stock Balance

In all these reports, the column I need the most (actual stock Quantity) is at the far right (not easily viewable)
I don't need any of the column, brand, description, Item Group, Item UoM, etc.
Any way I could not display these column (or displace them to the right).
For quite a few reports, one can edit the type of column we want and then save the report as a custom report.  Could we do that with these query report?  
I'm on frappecloud.
Thanks in advance for your help.
Best,
François

–

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/a795a02b-9f20-45e1-8cc8-cb604db5b278%40googlegroups.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/D633D8A0-0EA2-4B22-8B3B-0399AE040FC8%40gmail.com.

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


#3
Good evening Rubash,
Thanks a lot for your quick response. 
It is not totally urgent, I will try to raise a ticket on GitHub, I have never done that before, any guidance on how to do it?
Thanks

François

Le vendredi 12 septembre 2014 18:27:23 UTC+2, Rushabh Mehta a écrit :
Francois, 

No it's not directly possible. But we can move the columns around. Please raise a ticket if its really urgent or add it to GitHub issues if it can wait a bit.

@rushabh_mehta
via mobile

On 12-Sep-2014, at 5:43 PM, François de Ryckel <f....@gmail.com> wrote:

To whom it may concern,

Would you know if it is possible to delete columns in

Query Report: Stock Ledger

Query Report: Warehouse-Wise Stock Balance

Stock Balance

In all these reports, the column I need the most (actual stock Quantity) is at the far right (not easily viewable)
I don't need any of the column, brand, description, Item Group, Item UoM, etc.
Any way I could not display these column (or displace them to the right).
For quite a few reports, one can edit the type of column we want and then save the report as a custom report.  Could we do that with these query report?  
I'm on frappecloud.
Thanks in advance for your help.
Best,
François

–

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/a795a02b-9f20-45e1-8cc8-cb604db5b278%40googlegroups.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/db1e1f80-aa6c-4be3-a50b-66f5fc560d42%40googlegroups.com.

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


#4
Just go to

https://GitHub.com/frappe/erpnext/issues

You will have to login though.

@rushabh_mehta
via mobile

On 12-Sep-2014, at 10:23 PM, François de Ryckel <f....@gmail.com> wrote:

Good evening Rubash,
Thanks a lot for your quick response. 
It is not totally urgent, I will try to raise a ticket on GitHub, I have never done that before, any guidance on how to do it?
Thanks

François

Le vendredi 12 septembre 2014 18:27:23 UTC+2, Rushabh Mehta a écrit :
Francois, 

No it's not directly possible. But we can move the columns around. Please raise a ticket if its really urgent or add it to GitHub issues if it can wait a bit.

@rushabh_mehta
via mobile

On 12-Sep-2014, at 5:43 PM, François de Ryckel <f....@gmail.com> wrote:

To whom it may concern,

Would you know if it is possible to delete columns in

Query Report: Stock Ledger

Query Report: Warehouse-Wise Stock Balance

Stock Balance

In all these reports, the column I need the most (actual stock Quantity) is at the far right (not easily viewable)
I don't need any of the column, brand, description, Item Group, Item UoM, etc.
Any way I could not display these column (or displace them to the right).
For quite a few reports, one can edit the type of column we want and then save the report as a custom report.  Could we do that with these query report?  
I'm on frappecloud.
Thanks in advance for your help.
Best,
François

–

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/a795a02b-9f20-45e1-8cc8-cb604db5b278%40googlegroups.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/db1e1f80-aa6c-4be3-a50b-66f5fc560d42%40googlegroups.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/976A8935-DFEE-46DC-8EAF-E322AB73353F%40gmail.com.

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


#5

Hello,

Has this feature been implemented? I am trying to find a way to remove columns from the stock ledger in order to:

  • make the report clearer
  • make sure it fit when printing it

Thanks,
Max


#6

Hello @MaxenceD.

Maybe the “Report Builder” can help you.

https://frappe.github.io/erpnext/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext.html


#7

Hi @MaxenceD,
You need Script Report (not report builder)


#8

Why not just make a duplicate of the old stock balance report, call it “Simplified Stock Balance” and just have a couple rows on there.


#9

I didn’t realize this is such an old topic. But heres a simple stock balance mockup

Current Report:


Simple Report:

EDIT: @rmehta I have sent a pull request your way. I’m still shaky with GitHub, so if I haven’t done something properly, I apologize.


#10

If feature to remove/customise unwanted columns in report is implemented, please guide us how to do that.


#11

Is this available now? this was supposed to be a feature in version 12, for e.g., I use Accounts Receivable/Payable Summary and want to get rid of invoiced amount, paid amount etc columns. What is the work around otherwise?