I am using custome field line in sales invoice. but when i go to get repor choosing custom field, i can not find that field

i am using text custom field in sales invoice - line and sales order - line. but when i go to get report choosing custom field, i can not find that field. i can not get any report on that custom field
please advice

Hi @Mohsin_Bhurani,

Where are you trying to generate this report from? Is it Custom Reports or Advanced Queries?

I am trying in sales invoice totals by custom field

That only works for Custom Fields placed at Sales Invoice level not on the lines.

Have you tried Advanced Queries on Sales Invoices - Lines?

See if it works for you

Yes it worked. but for specific date and item report i can not generate through advance queries. - will we be able to get reports according to date and items ? @Roel_Developer

You can use the Where filter to set dates and item

2 Likes