Account transactions report - Include item code as a column
Add item code as a column option in the account transactions report
-
Amy Redman
commented
We are just migrating to Xero and this lack of function is really surprising and already very frustrating! the main reason we moved to Xero was for greater reporting flexibility and less reliance on spreadsheet manipulation. Not being able to see the product code in the account transactions means we will still have to be merging reports externally to get the full picture.
Are there any plans to make this happen?
-
Amelia Kennedy
commented
PLEASE can you add the Item Code to the Account Transactions report. Unable to track Bills and Spend Money items in one place without doing some sort of cross matching. PLEASE!
-
Viona Gunawan
commented
Yes, this should be easy for Xero to implement. We need it for reporting in my workplace, and I believe many others would find it useful too
-
Julie Cooper
commented
without this item code being included everything is manual and who has that time!
-
Nadine Hyslop
commented
Yes! I've just been directed to the 'receivable invoice detail' report, however for a year of transactions I can see that being a big job to sift through everything.
Basically we are not a retail business but use untracked item codes for pricing reasons on our services for easy adjustment (and some line items have set line info which saves time). We cant use the tracking categories as that is used to track which truck was used.
We are only human - so we need to be able to run a report to see a certain range of our sales accounts have been mistakenly left out being assigned to these items as it will affect the overall pricing at EOY. -
Daryl Carver
commented
Essential - i really dont understand how anyone can easily analsye their transactions to be honest? Surely in a relational database this must be a '5 second' fix?
-
Jennifer Tryggvason
commented
Yes! As it stands I can't see item by tracking category, but if the item code were on the transaction list, I could filter the transactions report by tracking category, then export and sort by item.
It's a major shortcoming that I can't find any way to sort the item report by tracking category. -
Barbara Fusco
commented
Yes, please add a column to the Account Transactions report to see the related product/service code - this is crucial for reporting on direct costs and revenue. And it is important to include both purchase invoices and spend money items, as the Payable Invoice Detail report does not include Spend Money items. So it is essential to be able to see it all in one single report instead of having to run several reports each time - really time consuming!
-
Shimas Jiffry
commented
Sales transaction report - we are unable to find a separate column for item code, it will be helpful if its available as we can extract the sales report with item code to do Vlookup workings to find out if the goods are invoiced / sold as per the instructed prices. at the moment it reflects only the description and it will be helpful if the item code can be added.