Is it possible to add Item name or Item account column in Sales & Purchase Invoices tab ?
At the bottom of this page select Sales Invoice-Lines. Then you can add or remove columns according to your requirements.
It can be done like that but i want to add it to other column of custom fields not just invoice lines.
Did get what you mean by this. Can you explain?
You can if you follow the above instructions.
I know, but those are invoice lines, it wont show me the custom fields in the columns.
Thats something you have to wait for. As @lubos mentioned he is working on improving the Advance Queries to see data from multiple sources so maybe then it would be possible.
You can see i have all those custom fields in each invoice.
I want to see them with the account that has been recorded on.
I know it is possible with custom report but it would be much more convenient if they could show it in the invoice tabs columns* as well. 
You cannot show accounts on Invoice tab because each line could contain different account. So if there are 20 lines on Sales invoice and each with a different account then it would become a very long list. So its better to show Account on Sales Invoice-Lines only as account belongs to the line. The only thing left is Non-Line custom fields which you cannot select on Sales Invoice-Lines page. It would’ve been better if you could select those fields (And i think previously they were there but removed for some reasons). But lets hope this is improved in future.
Not possible through custom reports as the custom fields can not be selected in Custom reports.
1 Like
@shahabb is correct. Sales Invoices - Lines screen will show you individual accounts, items and custom fields specified on individual lines.
The part that I need to improve is so you can select columns from Sales Invoices screen within Sales Invoices - Lines screen.
Only then you will be able to create a view that can mix columns from both Sales Invoices and Sales Invoice - Lines screen.
4 Likes