Multi-item report by division - is this possible?

[2020Hindsight]

Hi all,

Is it technically possible currently to create a report which has Divisions down the side, then a count of each of the items sold along the top ?

I know I can do it by creating a report by division for a single item count (so could do this and copy into a spreadsheet) - but if it’s technically possible to do it in Manager that would more efficient.

The fields are Division, then across the top Inventory Item / Item Code / QtyMultipliedByNegativeOne for each item.

Hope that makes sense ! Thanks.

[lubos]

Let’s figure out how to do this in the context of advanced queries. Custom reports will be eventually replaced by advanced queries.

What is your source of data? Sales invoice lines?

[2020Hindsight]

Thank you Lubos. These are all receipts (NB I’m not an accountant, just a volunteer so the chances of me using Manager in a technically correct way are remote But it works for us. )

[2020Hindsight]

This is the Custom Report I run currently for the single item…

[lubos]

I suggest go to Receipts - Lines screen.

See: https://www.manager.io/guides?receipt-lines

Then use advanced queries so group your receipt lines by item and division.

[2020Hindsight]

Thank you. I will give that a go. Much appreciated.