anyone know how to get Location Average Cost on a ...
# suiteanalyticss
Stephan Vagner
09/13/2023, 8:46 PManyone know how to get Location Average Cost on a Workbook?
d
David B
09/13/2023, 9:04 PMthis is on a dataset with item as the root record type:
s
Stephan Vagner
09/13/2023, 9:06 PM@David B Thanks but I'm missing 'Locactions'
I only have "Location"
Stephan Vagner
09/13/2023, 9:06 PMDataset is 'Item'
d
David B
09/13/2023, 9:07 PMyeah, don't know what's going on there, I have both (I believe "location" is just the classification location for the item record)
David B
09/13/2023, 9:08 PMhave you tried creating a new dataset to see if "locations" is available
s
Stephan Vagner
09/13/2023, 9:08 PMI can get it on a saved search for item
Stephan Vagner
09/13/2023, 9:08 PMYes I created item dataset
d
David B
09/13/2023, 9:09 PMjust thinking if there's some issue with the particular dataset you're working with. could you try with a brand new dataset and see if "locations" is available?
s
Stephan Vagner
09/13/2023, 9:10 PMYep. Brand new standard Item dataset
🫤 1
Stephan Vagner
09/13/2023, 9:11 PMWeird...
d
David B
09/13/2023, 9:12 PMdo you have advanced location management enabled?
I do not, and maybe that changes where inventory location fields appear on datasets
David B
09/13/2023, 9:13 PMsorry "Advanced Item Location Configuration"
s
Stephan Vagner
09/14/2023, 7:53 AMYes I do. That must be it. Thanks!
2 Views