How to create a more advanced report

1

P.S: I’m using the desktop version

I want to create a report based on sales order or sales invoice with the field below:

  1. Reference
  2. Item name
  3. Item Quantity
  4. Customer Name

Group By Driver(custom field) and Customer Name

Then later, find the total for each item.

I’m a developer, so If I can code the report or access the DB

I don’t mind switching to the cloud version also if I can access the API there.

Thanks

2

Check ‘Custom Reports’ under the ‘Reports’ tab.
Search the forum for ideas to implement the same. Many users have already provided working examples.