How do I get the location subtab field from the it...
# generals
Suitestallion
03/23/2020, 5:09 PMHow do I get the location subtab field from the item record on the saved search.
k
KevinJ of Kansas
03/23/2020, 5:09 PMLocation On Hand is the most reliable join for me.
KevinJ of Kansas
03/23/2020, 5:09 PMThat said - trying to grab standard cost by location might be ... different.
s
Suitestallion
03/23/2020, 5:13 PMI thought of location or location on hand but i don't see that in field joins
k
KevinJ of Kansas
03/23/2020, 5:19 PMInventory Detail?
KevinJ of Kansas
03/23/2020, 5:20 PMInventory Number/Bin On Hand Fields might work.
s
Suitestallion
03/23/2020, 5:21 PMit only has bin number information, No Standard cost information
Suitestallion
03/23/2020, 5:22 PMBin on hand is same
Suitestallion
03/23/2020, 5:23 PMmessage has been deleted
Suitestallion
03/23/2020, 5:24 PMI am doing the Item Search. I need Item values so I am doing Item search 😉, I don't know if there is any other way to get this join value
k
KevinJ of Kansas
03/23/2020, 5:25 PMI haven't played much with standard cost
KevinJ of Kansas
03/23/2020, 5:25 PMbut isn't it it's own record? Maybe start with a standard cost search joined to the item record?
KevinJ of Kansas
03/23/2020, 5:25 PMto pull in whatever fields you need from the item
s
Suitestallion
03/23/2020, 5:27 PMthere is planned standard cost record search but not the standard cost record, I have tried planned standard cost search before it doesn't join with item record.
r
Ryan
03/23/2020, 6:12 PM@Suitestallion, have you tried Location Standard Cost?
s
Suitestallion
03/23/2020, 6:19 PMYes I just found out about that, but it’s showing blank values or 0 I tried expressions but no success
Suitestallion
03/23/2020, 6:21 PMI got better results when I filtered by type
Suitestallion
03/23/2020, 6:28 PMBut I only see the results for one location, we have six and on item record all six has values
4 Views