Reports - Add quantity column to reports
It isn't possible to add a quantity column to a report, nor is it possible to pull through Qty data entered in Xero or create a cell the Qty can be manually typed into.
You can add a note column but this would be to link to a section of the report pack, not a quantity loaded into Xero or a box we could manually type the quantity into. Further the notes section functionality is unable to be renamed and can only be linked to other reports in the report pack. It does not work to bring through Qty data.
Lastly, it is not possible to add a column to a single section of a report without adding it to the entire report. Even if there was a Qty column to add, this would add it to every note which we don't want.
Example of where we need the above functionality is the standard investments note in the notes to the financial statements section of annual accounts. This needs to show the Qty of shares held or if the client has term deposits the interest rates.
![](https://secure.gravatar.com/avatar/2dcef420fa7a92c33a0962cf42922c2c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Susan Squire commented
Reports which have quantity, average price, and total:
Payable invoice details (has every transaction and hard to sort into individual items).
Accounts Transition can be sorted to individual accounts, if they had quantity and individual prices it would be easy to see at a glance, total number descriptions items sold ie tons sand, litres of fuel, easy to breakdown into individual accounts add two columns quantity and individual price to the 9 column from Invoices/bills which can already be added to reports.
Individual item sales/purchases. Total sold not really relevant if you cannot breakdown into fine detail.
This would be helpful for filling in carbon footprint forms ie cu/ton concrete used, litres fuel, fertilzer purchased, feed used, and stock sold etc.
-
Carrie Sherlock commented
Being able to report on the total price and quantity would allow us to figure out the average price per unit which is required when creating budgets. The information is in the database so why isn't it easily accessible? Please add quantity to the available fields list for reports.