Hi All.
I have an item search which is doubling th...
# administrationn
NickSuite
10/26/2023, 11:39 AMHi All.
I have an item search which is doubling the location quantity available if I use group and sum summary. If I remove the grouping, the quantity shows up fine. I have checked suite answers, but nothing helpful.
p
PWN
10/26/2023, 12:38 PMI guess it is some form of lines + header inclusion that is not straight forward to get rid off - may I suggest you just 50% it with a formula if you know its exactly double?
n
NickSuite
10/26/2023, 1:30 PMIt's not exactly doubling. For one item, it is double, for the other one is 10x.
NickSuite
10/26/2023, 1:31 PMIt is not transaction based search, it is the item search. Sorry about the confusion in the first post. I have edited it and corrected it.
p
PWN
10/26/2023, 5:20 PMah no worries, well even stranger then, I would log a support issue tbh
n
NickSuite
10/26/2023, 5:27 PMCould bin cause this issue?
p
PWN
10/26/2023, 5:31 PMYea, that would be a good place to start looking actually
PWN
10/26/2023, 5:34 PMUsually you cant get multi-level sublist data in your search without intricate joins to save your life but maybe this is by design đ
s
Sam-I-Am
10/26/2023, 5:59 PMtry out the analytics workbook might solve this issue
n
NickSuite
10/26/2023, 7:29 PMOkay thanks @PWN and @Sam-I-Am
d
David B
10/26/2023, 8:43 PMjust putting it out there that I have encountered this issue when using Item Name in the available filters.
Probably time I recreated that issue and log a NS case...
đ 1
David B
10/26/2023, 9:35 PMp
PWN
10/26/2023, 9:39 PMnice catch
thanks 1
d
David B
10/26/2023, 9:40 PMm
MGBC
10/27/2023, 3:14 AMYea I have experienced this as well. It was more around the fact of using contains in a criteria. Try using âhas keywordsâ instead
MGBC
10/27/2023, 3:15 AMLike name âhas keywordsâ xxxx instead of
Name contains xxxx
MGBC
10/27/2023, 3:15 AMAt least thatâs what support told
Me
d
David B
10/27/2023, 3:16 AMcan replicate on a search without any criteria or filters, see above. Haven't seen that documented yet.
I found SA #86143 "Transaction Saved Search to Match Sum of Amount of Specific Item" which describes your example
m
MGBC
10/27/2023, 3:16 AMIt really screwed with all my Celigo integrations because they rely on summary searches for inventory feeds so all marketplaces got doubled inventory numbers or more
đŹ 1
n
NickSuite
10/27/2023, 3:44 AMThanks @David B for confirming that I wasn't doing something wrong. Was this filed as the defect or enhancement?
2 Views