# Itemwise Sales Report **URL:** \ **Category:** Uncategorized\ **Created:** [April 28, 2016, 1:52am UTC](https://forum.manager.io/t/itemwise-sales-report/5593 "2016-04-28T01:52:09Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![AnilM](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@AnilM](https://forum.manager.io/u/AnilM)\ **Post date:** [April 28, 2016, 1:52am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/1 "2016-04-28T01:52:09Z")
I am trying out this software and would like to generate an item wise sales report. I am trying out a service item and therefore do not have any inventory purchase. These are training sales. I have added items as Item Codes in Sales invoice item. I was able to generate invoices and receive payments but unable to generate a separate report of items sold. Can anyone help me out with this? Thank you! ---
**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\ **Post date:** [April 28, 2016, 10:45am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/2 "2016-04-28T10:45:26Z")
I don’t think item wise sales report is available for now but sure to come in the future. The last time I checked reports for created items are not available now ( Purchase invoice items, Sales invoice items, Inventory Kits). When the report finally comes, it will be very nice to have the option of selecting a Tracking code for the report, e.g. how many items have been sold by Tracking Code A and Tracking Code B. Or maybe a different group of reports can be invoked when a user activates tracking codes. These reports can be used to monitor sales invoice items, purchase invoice items, and inventory kits transacted by the various tracking codes. It may as well show tracking code reports for inventory items, expense claims and payslips. ---
**Author:** ![AnilM](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@AnilM](https://forum.manager.io/u/AnilM)\ **Post date:** [April 30, 2016, 12:35pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/3 "2016-04-30T12:35:31Z")
Thanks Abeiku, I think so too.I could not find any straight forward way to get a report of the sales. The only roundabout way appears to be to put the items into the inventory and then put in the sales invoice from inventory and get the inventory movement reports. However since what I do is training courses/ lectures, I don’t have any inventory. So waiting for a sales reports to be added. This is necessary to update pricing for slow moving items and fast moving items. ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [April 30, 2016, 1:45pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/4 "2016-04-30T13:45:15Z")
Here is a way you might–with emphasis on might–more easily get what you want than looking at individual sales invoices, @AnilM. It isn’t perfect, and it requires a little more work when you create invoices, but depending on your volume you might find it acceptable. 1. Create a custom field for sales invoices. Tick the box to show as a column, but do not tick the box to include on invoices. 2. When you create an invoice, enter into the custom field the item codes (or even the item names–the codes are not strictly necessary) you have already created. This is a redundant step, since you must already enter the sales invoice item name/code when you enter the line item, but if the codes are short, it won’t be much effort. 3. When viewing the Sales Invoice tab’s register, search for the desired item code. Manager will show you all invoices with custom fields containing that code. 4. Export the sorted register, import into a spreadsheet, and create whatever report you want. The drawback of this approach is that you only will see the invoice total, not individual line items. If your training sales include only one thing on an invoice, this could work for you. If you sell multiple items at a time, you won’t have the necessary visibility. I agree that a report for sales or purchase invoice items would be useful. ---
**Author:** ![AnilM](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@AnilM](https://forum.manager.io/u/AnilM)\ **Post date:** [April 30, 2016, 4:37pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/5 "2016-04-30T16:37:12Z")
Thanks **@Tut** for your direction, I have tried what you have suggested and ran into two problems. 1. As you have anticipated multiple items in one invoice will have visibility problems. 2. The newly added field cannot be linked to the sales invoice items, hence no drop down menu. I even tried the same name for the field hoping to get the drop down menu, No luck… Any errors in the item code like additional spaces, change of case, additional characters will again require more work on the report after export.I believe that data should be entered only once and redundant entry is a point for errors to get in. However as all the data is already entered into the database, a report would have been useful. So will have to go the long way. ---
**Author:** ![irfankhatri](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/irfankhatri/32/18907_2.png) [@irfankhatri](https://forum.manager.io/u/irfankhatri)\ **Post date:** [October 8, 2017, 5:15pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/6 "2017-10-08T17:15:57Z")
Sales and purchase register ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [October 8, 2017, 7:32pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/7 "2017-10-08T19:32:14Z")
Is this a question? If so, you need to elaborate. ---
**Author:** ![irfankhatri](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/irfankhatri/32/18907_2.png) [@irfankhatri](https://forum.manager.io/u/irfankhatri)\ **Post date:** [October 9, 2017, 5:36am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/8 "2017-10-09T05:36:41Z")
![a0004 sales-return-report](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/dd5245daba52882e7f5421e77de2c5722941d335.gif) ![a0006 bill-wise-gross-pl](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/9/9e36a6ffcabecbbd79762f8bed2d0734692c3793.gif) ![a0002 purchase-return-report](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/6/67290d215e15845bbe97e7b702207aed88a6a941.gif) ![a0001 purchase-report](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/b/b064898c52c9f39741a8c572edcb69e7881a80f1.gif) ![a0010 Reg_tax_sales_excise](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/a/ada4a8961a005b4f60539f2d77bb52591d6cf5f0.gif) ![a0003 Reg_sales_return](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/d/d0fbaad7e5f36b25afce597dd4f69b03ef65ba99.gif) ![a0009 Reg_tax_sales_reg](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/4/4312bcea2f80a90a61b9a6b3572fba0201f6854c.gif) ![a0006 Reg_daily_purchase](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7c84d1debafea51271ac30c6d1c6075a3ab03791.gif) ![a0004 Reg_pur_return](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/5/599eec86172488ccaf419afc1877db6bca709dca.gif) ![a0002 Reg_purchase](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7117cc97ddd4f5cd93d4541daf8921762724ccf2.gif) ![a0005 Reg_daily_sales](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/2/296e448a12d7e3dfe90a4f05989218b9c815563f.gif) ![a0003 sales-report](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/f0b31516684f3bfada48da129353d94700a744ea.gif) ![a001 Reg_sales](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/a/a36e42ae02ca1c0276a666e03814c8a44c04476f.gif) ![a0008 Reg_purinv_trans](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/8/872e38ee5b62c509e9020143e445bab84d5edcd3.gif) ![a0007 Reg_salesinv_trans](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/6/6f0efa703ca3f1e611b43877fc8cfef0efdd614c.gif) ![asales-tax-output-register](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/c3a7139548f997b0629edde155d0722a1ef22dd3.gif) ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [October 9, 2017, 5:46am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/9 "2017-10-09T05:46:34Z")
we still do not see a question. ---
**Author:** ![irfankhatri](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/irfankhatri/32/18907_2.png) [@irfankhatri](https://forum.manager.io/u/irfankhatri)\ **Post date:** [October 9, 2017, 5:50am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/10 "2017-10-09T05:50:56Z")
Dear sir, it is report. kindly advice for it. Register means into column form. all above taken from other software. i found in manager io no register. i am going to implement into our company. i need custom reporting tool for custom reporting and data extraction from software. Below is detail format of it. ![a0006 bill-wise-gross-pl](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/9/9e36a6ffcabecbbd79762f8bed2d0734692c3793.gif) ---
**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\ **Post date:** [October 9, 2017, 5:54am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/11 "2017-10-09T05:54:14Z")
read the Reports section in the guides for available reports in Manager. [https://www.manager.io/guides/](https://www.manager.io/guides/) as informed to you many times earlier, custom reports is only a work in progress and there is no documentation for it yet. ---
**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\ **Post date:** [October 9, 2017, 11:08am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/13 "2017-10-09T11:08:29Z")
> [@irfankhatri](#): > > kindly advice for the following report format No, that format is not available ---
**Author:** ![irfankhatri](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/irfankhatri/32/18907_2.png) [@irfankhatri](https://forum.manager.io/u/irfankhatri)\ **Post date:** [October 9, 2018, 9:36am UTC](https://forum.manager.io/t/itemwise-sales-report/5593/14 "2018-10-09T09:36:19Z")
Dear sir Any update for item wise report. > [@\[18.9.60\] Improved custom reports (added visual query builder)](https://forum.manager.io/t/18-9-60-improved-custom-reports-added-visual-query-builder/18065): > > The latest version (18.9.60) is greatly improving custom reports functionality. Most notably, it’s no longer required to write SQL. Instead of SQL, there is visual query builder. For example, to generate report which lists your customers with their email address and billing address, you’d set it up like this: [[image] ](https://i.imgur.com/OiaFmZH.png) Or you can generate custom report which shows your general ledger transactions grouped by account for specific period. [[…](https://i.imgur.com/2VnWRHt.png) [18.9.60] Improved custom reports (added visual query builder) Best regards ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [October 9, 2018, 1:22pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/15 "2018-10-09T13:22:09Z")
What are you asking? The visual query builder was added to the program since your previous , as you seem to know already. Read the Guide: [Create custom reports | Manager](https://www.manager.io/guides/18075) ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 3:08pm UTC](https://forum.manager.io/t/itemwise-sales-report/5593/16 "2023-01-18T15:08:47Z")
Closed on January 18, 2023, 3:08pm UTC