# Custom Reports - inventory items not linked to sale invoice transactions **URL:** \ **Category:** Uncategorized\ **Created:** [October 24, 2018, 9:22pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786 "2018-10-24T21:22:35Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 24, 2018, 9:22pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/1 "2018-10-24T21:22:35Z")
while the inventory items’ HSN code shows up if the tax amount is more than zero, but if it is kept at less than zero- (i need only sales invoices)- it doesn’t show. ![2018-10-25-02-47-38_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/a/ba94b2fae1fb7e50039086dcac40654c0a052811.png) ![2018-10-25-02-47-53_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/3/937d0d47e97eb3ffdc55ace0d0ee50f21e31a0f0.png) ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 24, 2018, 9:32pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/2 "2018-10-24T21:32:42Z")
here is the report when tax amount is kept at “not zero” ![2018-10-25-03-00-10_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/a/9a0c4e8d3d4f8548c5f7ea2e1f5475c878a8a252.png) ---
**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 25, 2018, 5:08am UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/3 "2018-10-25T05:08:28Z")
It is not clear what you are asking. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:26am UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/4 "2018-10-25T10:26:19Z")
I want a report that shows me HSN inventory details for sales invoices. As you can see in the third screenshot, Details dont show up for all the items. It is only being shown for purchase transactions. Hope you could understand. ---
**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 25, 2018, 1:08pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/5 "2018-10-25T13:08:19Z")
This is not enough information to tell if anything is wrong. You need to provide: - The entire custom report Edit screen, not just part of it. - The Edit screen for a sales transaction that is not displaying what you think it should. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 2:11pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/6 "2018-10-25T14:11:46Z")
![2018-10-25-19-35-47_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/d/0d00566dbab73fbf642ffd47a7a53b963a67ba45.png) ![2018-10-25-19-35-53_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/1/71b967c3f99ad3a9e1ea109218fb325a38c9fd5e.png) ![2018-10-25-19-36-14_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/0/309804a2aee059dbf1abf268be25a981adb138b8.png) ![2018-10-25-19-37-12_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/5/c5b96d50208aca99ededfe472ecd5cec26e55358.png) ![2018-10-25-19-38-12_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/4/0400b18771116f4231b8e97c64f867270f313dfc.png) ---
**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 25, 2018, 2:54pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/7 "2018-10-25T14:54:13Z")
Without having modeled this, I offer the following observations: 1. You defined your HSN/SAC custom field as an inventory item custom field, not a sales invoice line item custom field. This may be why the HSN/SAC field on the sales invoice is blank. As a result of that, there is no content to show from general ledger transactions. 2. `Inventory Item | Tax Code | Name` is not part of the general ledger transaction either. It is used to set the `Tax Code | Name` variable. Only the second one should be expected to show, and it does. Your report definition was asking for redundant content anyway. You should probably just eliminate that first column. 3. The sales invoice line item `Description` is not exposed. The variable you selected is relevant to reports on inventory items, not sales invoice line items. Remember, custom reports are still a work in progress. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 4:05pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/8 "2018-10-25T16:05:44Z")
1. the sales invoice line item custom field is not currently in use, and i use the Inventory Item Custom Field. 2. i removed `Inventory Item | Tax Code | Name` 3. i removed `Inventory Item | Description` only transactions which are purchases are getting mapped with inventory items. sale transactions are somehow not mapped with the respective items. maybe @lubos can shed light on this? ![2018-10-25-21-24-37_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/b/abe1a15d29445ce7045a89715de336a8f9c22823.png) ![2018-10-25-21-24-42_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/f/efe06e5767197061498cefdf8b6bbd385e30756e.png) ![2018-10-25-21-24-24_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/1/d14f302431a5384ac0b9325ddb0a72bf18e06fb4.png) ---
**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 25, 2018, 5:01pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/9 "2018-10-25T17:01:23Z")
> [@spandan888](#): > > - the sales invoice line item custom field is not currently in use, and i use the Inventory Item Custom Field. This was exactly my first point. I see no reason a custom field that comes from the inventory item would appear in a report drawn from general ledger transactions, especially when such a field is blank on the sales invoice. Before you say, “Yes, but it shows for purchase invoices,” show the same screens for a purchase invoice. You may have defined them differently. So there may be content to show. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:09pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/10 "2018-10-25T22:09:27Z")
here is a purchase ![2018-10-26-03-31-52_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/0/302ee2d9fc79167240cfc715b60696cf82d7cc31.png) ![2018-10-26-03-32-56_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/9/8950295abfa0e1c28dc5e96e5a1a895f5150d492.png) ---
**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 25, 2018, 10:25pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/11 "2018-10-25T22:25:19Z")
What puzzles me is the fact that anything shows for HSN/SAC for either sales or purchase invoices, because that field is blank on all your line items. For curiosity’s sake, can you show the View screen for either the sales or purchase invoice you already showed the Edit screen for? Also, if this is related to the sign of numbers, it might reverse if you substitute `Amount (sign reversed)` for `Amount` in your list of selection criteria. If so, that will definitely point to the cause. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:29pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/12 "2018-10-25T22:29:35Z")
i have used the inventory custom field. so that shows up. ![2018-10-26-03-56-22_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/6/361d1b7b5abc761c011fce53e5c14f573cfea822.png) ![2018-10-26-03-57-37_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/b/4b5dfe2ecf9f94985b08b48f0120f81eb58c8610.png) ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:32pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/13 "2018-10-25T22:32:43Z")
![2018-10-26-03-59-43_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/1/f1ec41042b93e670c63720aeb69d01c9de1174c0.png) ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:34pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/14 "2018-10-25T22:34:58Z")
the purchase invoice line item was set to show in printed docs. but sale invoice line item was not set to show in printed docs. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:41pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/15 "2018-10-25T22:41:13Z")
but that doesnt cause any difference , i tried it out on a demo business without the sale invoce, purchase invoice line items, and it has the same consequence. > [@spandan888](#): > > he purchase invoice line item was set to show in printed docs. > but sale invoice line item was not set to show in printed docs. ---
**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 25, 2018, 10:43pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/16 "2018-10-25T22:43:54Z")
So it looks like themes will pick up inventory item custom fields, at least when the Indian tax scheme is implemented. (This works somewhat differently than for other tax codes, I know.) But custom reports apparently will not. Now I’m curious about two more things: 1. Can you confirm that setting the custom field to show on printed documents has no effect? Your wording was a little bit unclear. 2. If not, what happens if you manually fill in the HSN/SAC field on a sales invoice? And I still have the question about substituting `Amount (sign reversed)`. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 10:53pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/17 "2018-10-25T22:53:41Z")
1. here is a demo report from a demo business which has just the inventory item custom field. (no other custom fields except sales invoice notes have been defined) ![2018-10-26-04-11-42_001](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/a/4acfad194d89a71f23460e2738c042b049c76cf2.png) 1. NA 2. using `tax amount sign reversed` there is the same problem. only that i have to change the criteria. ---
**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 25, 2018, 11:06pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/18 "2018-10-25T23:06:11Z")
Well, thanks for trying all those things. I can’t put this into the bugs category because @lubos has said he is still working on custom reports. And the program does nothing wrong; it just doesn’t yet do what you want. But he will see this forum thread. It sounds like your workaround for now is to use the “amount not zero” criterion. Your report will have information you don’t need, but apparently includes what you do need. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [October 25, 2018, 11:09pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/19 "2018-10-25T23:09:39Z")
not really. it does not include the HSN CODE, UNIT NAME s… those are the things i require, i already filed last quarter’s GSTR1 return, so there is no immediate need, but i would appreciate if it gets done soon. ---
**Author:** ![spandan888](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/spandan888/32/10146_2.png) [@spandan888](https://forum.manager.io/u/spandan888)\ **Post date:** [November 1, 2018, 6:04pm UTC](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786/20 "2018-11-01T18:04:41Z")
hey @lubos any idea what may be causing this? [Next page](https://forum.manager.io/t/custom-reports-inventory-items-not-linked-to-sale-invoice-transactions/18786.md?page=2)