Hello all! We currently have 2 warehouses with inventory and going on to adding a 3rd location. This 3rd location will be an interesting addition since the inventory in the warehouse will be owned by HQ, and the retail store will be operating as a separate company, yet nesting inside the same netsuite(Yes lots of accounting work to be done, but it's the simplest way).
Regardless, from what I know, Celigo pulls inventory from the “Purchasing/Inventory Subtab” for our 2 locations. For our 3rd location, is there anyway to specify that the inventory gets pulled from a specific bin location?
Bump, any ideas, trying to finalize our 3rd locations bins
Hey Calvin, great topic! I’m currently looking into your question and finding someone to give you an answer. I appreciate your patience!
1 Like
Hi Calvin. What integration is this for? Where are you sending inventory quantities to? You can probably modify the saved search to specify the bin location for the 3rd location, but it might be a little tricky. Can you post a screen shot of your saved search results tab?
1 Like
Hey There Cory! Thanks for the reply! This is integrating Netsuite with Shopify. Sending inventory from Netsuite to shopify. Currently we're running a negative 10 buffer for all locations(3rd one isn't fully live yet), however I'd like to get more granular, specifying bin locations on 3rd location, and 2nd location, and just running a buffer for our Main HQ location. If that is even possible at all, im sure its a huge formula.
Calvin - I would start by seeing if you can restrict the quantities with the criteria of the search. So you would 'Use Expressions' and try to group the location with the bin that you would want the quantities to come from.
1 Like
May you be more specific on setting the criteria with the "Use expression"?
Tried to use specific " bins not including" and it doesn't reflect. it still grabs the entire inventory.
Calvin - I was thinking something like this:
1 Like
Brilliant, let me try that out.
Doesn't seem to drop out the inventory from that specific bin unfortuntely.
Calvin - depending on the configuration of NetSuite, you might need to do something like this instead:
I recommend restricting the search to just one item and using the bin that you know has available qty for that item. In this example the results would look this:
1 Like
@calvinlee936 where you able to get this going? What does your current search look like and what output are you getting?
1 Like
No I wasnt able to get this going Attached is how I did my new saved search for specific bins. However I am returning multiple results per location with same inventory numbers. See attached my criteria tab, results tab, and my inventory detail tab for this one specific test item.
Bump on this, need more visibility
1 Like
You should add more inventory detail fields to the output of your saved search to figure out what needs to be filtered. Like you first want the output there to not have duplicates and then after that you would need to add summary types to the outputs so that they sum up to the same location vs having a row per bin.
1 Like
I've gotten this far by grouping the results. But I cant seem to find a way to display the internal ID per line. If I group the Location internal ID, it creates the duplicates again. See attached.
Yeah, this is where NetSuite gets tricky and has limitations. You would need to use the "Bin On Hand: Location" field, but that gives you the location name and not the location internal ID. When you use "Location," NetSuite makes two joins to the item table, one join to locations and another to bins, which is why you end up with duplicated rows. This is just a saved search limitation. If the location name is fine for you, then maybe that would suffice?
1 Like
Hmm that's curious. might work for me. I think I'll just have to remap the Celigo lookup for the locations. Is that simple to do?
Are you in a custom flow or IA? You could output the location id by using a formula field where "case when bin location = 'Austin' then 1 when ... end". As you add new locations you would just need to update this.
1 Like
