In a transaction saved search, we're trying to add...
# generalj
jackie.marler
08/26/2019, 8:44 PMIn a transaction saved search, we're trying to add a column for the Bin Location. Simply adding the field results in a line item for every bin where that item is stocked, regardless of location. I'm trying to come up with a formula that will only display the bin location of the item at the "from location". This is on a search for transfer order details.
e
Edward McGuire
08/27/2019, 12:33 PMAdd a result column Inventory Detail Fields : Bin Number.
j
jackie.marler
08/27/2019, 5:59 PM@Edward McGuire That field returns empty for me. 😞
jackie.marler
08/27/2019, 6:02 PM@KevinJ of Kansas do you know if NS has a records browser for SuiteAnalytics? I thought the "Connect Browser" tab was supposed to reflect that dataset, but SuiteAnalytics definitely does not have all of the fields available through the UI that are shown there. https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/odbc/record/item.html
k
KevinJ of Kansas
08/27/2019, 6:03 PMI'm not well versed in suiteanalytics yet, so unfortunately I can't point you in the right direction there
e
Edward McGuire
08/27/2019, 6:14 PM@jackie.marler ouch. Its crazy that it should work here and not there.
j
jackie.marler
08/27/2019, 6:14 PM@Edward McGuire are you starting from a transaction search?
e
Edward McGuire
08/27/2019, 6:25 PM@jackie.marler It's a Transaction saved search with one criterion: Formula (text) starts with, formula is {inventorydetail.inventorynumber}
j
jackie.marler
08/27/2019, 6:29 PM@Edward McGuire we're using the advanced bins - is that what you have? I tried the field both through the UI and as a formula - both come back empty.
jackie.marler
08/27/2019, 6:30 PMmessage has been deleted
jackie.marler
08/27/2019, 6:48 PMJust tried a new transaction search with the one criteria matching yours and it returned zero results. I'm not sure why our instance isn't using that field, unless it's due to using advanced bins.
e
Edward McGuire
08/27/2019, 7:01 PM@jackie.marler We are definitely using Advanced Bin/Numbered Inventory Management.
5 Views