Hi
When we invoice we select the relevant item code against each item a customer is ordering. How do we run a report to see which item codes are selling the best please?
Thanks
Jo
There is no report that will currently show the item usage, although I believe there should be. Itās just we were planning to introduce this within the scope of stock control but this keeps getting pushed back due to various technical reasons. Iāll add this to our near-term development list and try to get this prioritised for the next couple of months.
First you need to 'Add New Nominal Accountsā for each sales item.
Now go to the āItem/Inventory Managementā and change the category of each item to the new sales nominal code:
You can now āBuild a Custom Reportā for sales nominal codes.
Hi
Thanks, ok - but the report shows no data and there is no data against each sub category in the chart of accounts either. They are still all lumped under āgeneral salesā. Any ideas please? Thanks
Jo
You need to follow the steps I outlined above and first create a set of sales nominal codes and link them to the inventory item as shown above.
We may seek to add specific inventory reports in the future, I will refer to our development team.
If youāre not in a hurry for this information we will be producing a dedicated report in the next 2 months. Joeās solution works by posting items to distinct nominal codes, and may offer a solution in the mean time.
Hi
Yes I have done that. Each inventory item has a sub code category against it, but still nothing shows in the chart of accounts - just all under āgeneral salesā - unless it only works for invoices I enter from now on, not ones that have already been logged? (Although surely, if the data is in there it should just split it all out in the chart of accounts?)
Thanks
Jo
Hi
Ok, if there is something in the pipeline that will give a breakdown of inventory sales then Iāll hang on as there is no immediate hurry (although it would be nice to know what we are selling)
Thanks
Jo
1 Like
I would also find this useful as have been trying to figure out how to do this all morning
Weāre actually working on this right now. I shall update this thread when it is ready.
We have made some additions to the inventory area that will allow you to obtain information on the quantity of items used over a given period. You will find these additions in the advanced search box.
You can leave the date range empty and this will show the quantities used for all time. Once you submit the search another column will appear in the results set to show the quantity used. This column is also sortable, so you can order your results by the most popular and least popular inventory items.
2 Likes
Hi, Thatās great - thanks for that - but is it possible to see the total amount of the sales for each item, not just the quantity please? For example, one of our items is āCopywritingā, but price varies per job. Thanks, Jo
For this I would recommend you post these specific items to a custom nominal code (category). You can then use the custom reporting tool for a more detailed segmented view of the spend.
We may eventually make these quantities clickable so they drill down to the invoices from which the data has been derived. You can then at a glance see the total value of said invoices.
Hi Glenn,
is there any further progress on a dedicated report for items? I have seen this before in other programmes as a normal breakdown in the P&L report, as it is key to any business to know what stock/ services is selling best. I am currently unable to find a report for this - do I need to update my version or has it not yet been set up?
Many thanks,
Kathryn
You can obtain information on the number of items sold within a date range, it does not output monetary values though. This is accessible in the inventory area advanced search.
If youāre posting your different items to unique nominal codes then you can easily see the amounts sold within the Chart of Accounts.
Hi, a bit disappointing that QF still hasnāt addressed the need to report of sales of inventory items, without assigning each one to its own nominal code. Come on QF team this is basic functionality.
Thanks
Paul
Isnāt that exactly what Glennās post addresses above?
Hi Glen. Iām trying to use this count quantity feature to understand how many times Iāve billed a certain item in a particular time-frame. However, the count isnāt accurate. I canāt work out why, but itās not finding all instances for an itemās sale.
Please could you take a look?
Thanks, Benjamin
@benjamingoodson would you mind dropping a message to @QFSupport (or email support@quickfile.co.uk) with the details and weāll take a look for you.
Nope, Iāved tried it and it doesnāt give currency values.
Glenn why is QF not doing this. Itās pretty important reporting basics.
Thanks
Paul