Can anyone point me in direction of running a sear...
# inventorys
Suitestallion
08/02/2021, 8:23 PMCan anyone point me in direction of running a search/report for items that have no related records, we use standard cost so I did this SA but then I excluded Inventory cost revalution and Inventory Adjustment, but this search is not working for me. Its showing Items that has related records.
k
KevinJ of Kansas
08/02/2021, 8:26 PMAre you familiar with summary criteria?
KevinJ of Kansas
08/02/2021, 8:26 PMCould use "Count of" on transaction fields and require a count of less than 1.
s
Suitestallion
08/02/2021, 8:28 PMhmm good point but like i said we use standard cost so it would have at least 1 transaction, so i guess i can do less than 2 maybe?
Suitestallion
08/02/2021, 8:31 PMthis did reduce the number of items but it still didn't fix the issue at hand
k
KevinJ of Kansas
08/02/2021, 10:29 PMI'd do a decode statement rather than the transaction join
KevinJ of Kansas
08/02/2021, 10:31 PMdecode({transaction.type},'transction 1 I don't want included,'',''transaction type 2 I don't want','','{transaction.internalid})
2 Views