Anyone know what filter I would need for a transac...
# suitescriptt
Terry M
05/15/2019, 7:04 PMAnyone know what filter I would need for a transaction search to not show quantified member items of kits? Or a way to display the name of a transaction line? I have a kit that has 6 items in it, and if I do a transaction search I get both my 6 pack kit with a quantity of 1 as well as a line with the member item and a quantity of 6. I need to just get the kit. Wondering what the name of this line or if there is a way to find it so I can filter it out. Currently have COGS line, Tax Line, Shipping Line to false for reference.
m
Martin Horacek
05/15/2019, 7:07 PMitem.type != kit, group etc ?
t
Terry M
05/15/2019, 7:09 PMWell I need to fetch the kit and not the item. I was doing item.type == kit at first, but now I have some transactions that are kit and some that are inventory item in the search.
m
Martin Horacek
05/15/2019, 7:14 PMWhat transaction type are we talking about?
t
Terry M
05/15/2019, 7:15 PMLooking on an item fulfillment
m
Martin Horacek
05/15/2019, 7:16 PMSo on there it's actually breaking the kit into components. So not showing items that are of type kit should do the trick, right?
Maybe I'm missing something...
t
Terry M
05/15/2019, 7:18 PMRight that's what I was doing except now I also have other inventory items I need to retrieve. An order might have a kit as well as an inventory item, so I lose this if I filter by item type
Terry M
05/15/2019, 7:19 PMSo that's why I was trying to find what line that is that splits out the kit into items
m
Martin Horacek
05/15/2019, 7:20 PMFilter it by - If NOT itemtype KIT/PACKAGE
Martin Horacek
05/15/2019, 7:22 PM+KIT
--kit inv item 1
--kit inv item 2
+STANDALONE INV ITEM 1
+STANDALONE INV ITEM 2
-->
+kit inv item 1
+kit inv item 2
+STANDALONE INV ITEM 1
+STANDALONE INV ITEM 2
==
That's what I believe should be the result
t
Terry M
05/15/2019, 7:27 PMRight and that would work except I need the kit SKU and quantity to show up in my search result alongside the non-kit inventory items
Terry M
05/15/2019, 7:32 PMRight now it is:
ABC12345-6PACK [1] [kit]
ABC12345 [6] [item]
DEF6789 [3] [item]
I need it to be:
ABC12345-6PACK [1] [kit]
DEF6789 [3] [item]
Terry M
05/15/2019, 8:00 PMI found a workaround. The kits and member items are all one class, the other items I need to return are not, so I am just saying if class=a and type=kit OR class != a
Terry M
05/15/2019, 8:01 PMWould have been nice to find how to filter that line, but I searched all of the available "line" related filters and didn't see anything that would work
m
michoel
05/15/2019, 8:49 PMOn a pdf picking ticket I had to filter kit components by looking at the tax code (absent if it is a member of a kit). You might be able to do the same in a saved search.
t
Terry M
05/15/2019, 9:09 PMGood suggestion, thanks michoel
b
battk
05/15/2019, 10:29 PMalthough it sounds like you found an alternative
battk
05/15/2019, 10:29 PMyou could use
Applied to Link Typeis notKit Shipment11 Views