Hi, i added a custom “Order” field on Purchase Invoice - Lines. Now i want to create an overview, similar like the bank transactions, of all the purchase invoice lines and search/filter them to get an overview off all the purchased items for a particular order. Does anyone know how this can be done. …

Line item custom fields are not exposed for custom reports. Regular custom fields are, however, exposed. So you can only do what you ask at the purchase invoice level, not the line level.

It would be very handy when custom reports could also be used on line-level custom fields. Maybe @lubos can consider to add this possibility. Can and will you please put this in the ideas category.

I don’t know if this is technically feasible, so I won’t put it in the ideas category. But @lubos will see this thread, so he can decide. I know he favors adding custom fields, and already did so for transaction-level ones.

Custom reports will definitely support this.

Thanks, do you know approximately when this is possible.

Hello! I’m also looking for this feature, it’s like additional column on line invoice would be a waste if we can’t summarize all entries in one report.

It can’t even show those invoice-line custom field on the Purchase Invoice List.

Hi @lubos , if i may ask is there any progress on my request? This feature would be very usefull for many users to have. [image] Frankie: Hi, i added a custom “Order” field on Purchase Invoice - Lines. Now i want to create an overview, similar like the bank transactions, of all the purchase invo…

Hi @Frankie . I run a trading company and all my purchases I do are bound to an offer I made. All offers I make do get a 5 digit number (yyxxx) as a running number and when I get a PO for an offer then I create a tracking code for that offer and a project is made, using the yyxxx number throughout a…

Thanks for the reply but when i order multiple items at once from my supplier for different sales orders, lets say, 1 piece product A for sales order 1 and 1 piece product B for sales order 2 how can i filter or make a report of te purchases per sales order.

Create a overview from purchase invoice lines

lubos April 20, 2023, 12:34am 19

This has been implemented in the latest version (23.4.20.796)

Topic		Replies	Views
Creating a custom report for all po lines i have created	16	1429	April 2, 2021
Added ability to see invoice lines across all invoices	13	2762	July 27, 2023
New custom reports for sales and purchase offers and quotes	2	270	January 18, 2023
Request: How to create reports	21	890	April 27, 2023
Tracking Codes for whole invoice instead of rows	6	464	January 18, 2023

Create a overview from purchase invoice lines

Related topics