Hi all,
We are running a transaction saved search ...
# suitescripts
Shubham
09/14/2022, 4:02 PMHi all,
We are running a transaction saved search for item fulfilment and item receipt records. But in the results, the first line item on the item fulfillments is coming as the mainline whereas we are seeing correct result for item receipts (no line item is coming as mainline). Due to this, we are not able to use the mainline filter properly on our search.
Any ideas on the different behaviour for item fulfillment records and how should we search so that we can only get unique fulfillment and receipt lines.
Thanks in advance!
s
Sandii
09/14/2022, 4:13 PMDid you try to just set mainline = F?
s
Shubham
09/14/2022, 4:19 PMYes @Sandii, when we setting mainline = F then the first line item of the fulfilment is not even coming in the result
Shubham
09/14/2022, 4:20 PMWhen we remove the mainline filter and add mainline as column, then against the first line we are getting mainline as true for fulfilment. While for item receipt, its coming expected as false for all the lines
s
Sciuridae54696d
09/14/2022, 5:30 PMjust ideas, line sequence number not equal to 0?
s
Shubham
09/14/2022, 5:35 PMyes @Sciuridae54696d, it is coming as 0
b
battk
09/14/2022, 9:29 PMusually you worry less about the mainline and more about the number of rows per fulfillment line
s
Shubham
09/15/2022, 5:47 AMwe want to add the mainline=F filter to make sure that we don't get any extra item receipt lines due to mainline, but that is removing the first line item from the fulfillment.
we are seeing this behaviour for the first time.
so we are not sure if we leave out the mainline=F filter, then we would always get the correct results for item receipts as well
b
battk
09/15/2022, 6:14 AMthe traditional way to filter out the extra lines on the item fulfillment is to add the cogs line filter
battk
09/15/2022, 6:15 AMit doesnt work for all types of fulfillments, so i favor the applied to transaction filter instead. Only one of the search results will have the applied to transaction filled in
battk
09/15/2022, 6:17 AMalthough not really why i do it, applied to transaction should also work for the item receipt
battk
09/15/2022, 6:18 AMthough the more normal solution is to use a filter expression so that you can use the OR operator to have different filters for item fulfillments and item receipts
s
Shubham
09/16/2022, 4:24 PMHi @battk are you suggesting something like this?
Shubham
09/16/2022, 4:27 PMAlso, unable to understand what exactly can we do using the applied to transaction filter. We tried to add it but it is coming on all line items for both item fulfillment and item receipts
b
battk
09/16/2022, 10:05 PMyou need to learn how to get unique lines from an item fulfillment search before doing your task
battk
09/16/2022, 10:06 PMmake an item fulfillment search first and learn how to get the unique lines before continuing on your current task
battk
09/16/2022, 10:06 PMi offered two different solutions you could try
battk
09/16/2022, 10:07 PMone uses the cogs filter, the other uses the applied to transaction filter
battk
09/16/2022, 10:07 PMpick whichever one works best for you, i would not try using both
s
Shubham
09/21/2022, 11:19 AMHi @battk, thanks. We went with the conditional filters and tested it. Wanted to share the filters here as well once, can you please take a loot at the screenshot once and check if it looks fine to you
b
battk
09/21/2022, 3:15 PMlooks okay
battk
09/21/2022, 3:15 PMi dont know what the last formula criteria adds
battk
09/21/2022, 3:15 PMnor why it has to be a formula