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] [2018-10-25-02-47-53_001]

the sales invoice line item custom field is not currently in use, and i use the Inventory Item Custom Field. i removed Inventory Item | Tax Code | Name i removed Inventory Item | Description only transactions which are purchases are getting mapped with inventory items. sale transaction…

[image] 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,…

here is a purchase [2018-10-26-03-31-52_001] [2018-10-26-03-32-56_001]

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…

i have used the inventory custom field. so that shows up. [2018-10-26-03-56-22_001] [2018-10-26-03-57-37_001]

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.

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. [image] spandan888: he purchase invoice line item was set to show in printed docs. but sale invoice line item was not set to show in p…

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: Can you confirm that setting th…

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] NA using tax amount sign reversed there is the same problem. only that i have to change the criteria. …

Custom Reports - inventory items not linked to sale invoice transactions

lubos May 31, 2020, 11:10pm 26

This has been implemented now as part of the new custom report implementation.

Topic		Replies	Views
Sales invoice totals by custom field is not showing accurate data	4	697	April 15, 2018
HSN Code Not Displayed in Sales/Purchase Invoices & Reports	5	378	March 22, 2025
Inventory Kits in Custom Reports	9	585	June 27, 2020
How to automatically get HSN/SAC from Inventory in Invoice Line Item	45	3255	March 20, 2025
HSN/SAC Not link with Inventory item selected in Sales/Purchase Invoice	2	164	February 7, 2024

Custom Reports - inventory items not linked to sale invoice transactions

Related topics