is is the location field from sales order not avai...
# ask-stanley-ai
a
is is the location field from sales order not available on Report builder?
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, it appears that the location field from a sales order is not directly available in the Report Builder. Users have expressed difficulty in isolating locations in reports, as NetSuite tends to aggregate all locations. However, it was suggested that the "Location Available" and "Location on Hand" fields might be accessible in reports, but this is not confirmed. For more granular control over location data, users often resort to using Saved Searches instead of reports. In Saved Searches, you can use the Inventory Location field to see which location the quantities are related to. In terms of making the location field mandatory on a sales order form, it can be done by customizing the form. However, if the field is still mandatory despite being unchecked in the form customization, it could be due to a system setting or a workflow. Lastly, to see an item's location availability on a sales order, you can create a custom field that uses sourcing to get the available quantity. This involves creating a new decimal number transaction line field where the source list is set to item and the source from is set to available. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841674864
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820129514
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819702208
Please provide your feedback on this answer.