joining to transferlocation

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the 'To Location' and 'From Location' fields in NetSuite can sometimes be confusing when creating Saved Searches or Workbooks, especially for Transfer Orders and Inventory Transfers. In the first conversation, the user is trying to create a Saved Search to find Open Transfer Orders. They are able to pull the 'To Location' information at the line level but are having trouble with the 'From Location'. One suggestion given is to make the Saved Search with 'Main Line = T' and add grouping. However, it's noted that this won't provide line level data. It's also mentioned that transfer orders usually have multiple lines that return in a saved search for a single line in the UI. In the second conversation, a user is having trouble showing the 'To Location' on a saved search for inventory transfer. It's clarified that 'To Location' is related to transfer orders and that inventory transfers represent different locations on different lines. The 'From' and 'To' fields on the inventory transfer form are header level fields. It's also mentioned that field names and columns may not match between searches and records, and that in this case, the 'location' column represents both 'from' and 'to' locations. In the third conversation, a user is trying to merge a transaction line (PO) to current on-hand inventory for a specific location using a Workbook. They are having trouble locating the appropriate field to join to the transaction line attributes. A suggestion is given to join to the location lines on the item record and add a criteria to remove line duplication. The 'Quantity on Hand' value is found on the 'locations' field, not 'location'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******