Ron
11/22/2024, 2:26 PMCeligo AI
11/22/2024, 2:26 PMAI generated answer (using internal Slack threads):Based on the provided Slack threads, here are the responses: 1. For the first thread, the user is trying to find an ODBC table that shows the current ON HAND values for items. The suggested table is the Item_Location_Map. The user also inquires about the map between support case and transaction, and it's suggested to create a custom field and source from transactions to create the join. The user also asks about the "Committed" field in the ITEM_LOCATION_MAP, and it's clarified that if the user needs to filter on committed or available or shipped, they need to sum transaction lines. 2. In the second thread, the user asks if it's possible to run an inventory item CSV import without including Item name or Item internal id, and wants to use custom fields only. The response is that without record reference keys (name, internal or external ID), it's not possible to associate updates to the record. 3. In the third thread, the user is confused about the difference between the Inventory Detail tab and the Inventory Statuses tab on the Item record. The user finds that the Inventory Detail tab is missing multiple item locations when compared to Inventory Statuses. The user is advised to add a location to the filter and then remove it, and to verify if the customized view isn’t limiting anything. The user also finds that if they add the committedperlocation field in a SuiteQL Query on the inventoryBalance table, it removes the 'extra' locations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
11/22/2024, 2:26 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.794146836
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.789099932
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.788320661
Celigo AI
11/22/2024, 2:26 PM