transfer orders pending receipt saved search shows the lines 2 times in negative 1 in positive

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue of seeing transfer orders pending receipt saved search showing the lines 2 times in negative 1 in positive is due to how NetSuite handles inventory transfers. When an inventory transfer is made, it simultaneously reduces stock from one location and receives stock in another location, hence the double entry. To only show the positive values, you can specify a criterion called something like transaction line type and set it to item. This should only show the item quantity on the transfer. If you are seeing an error, it might be because you created this via script. In this case, you can try exporting your search using a Chrome plugin to check how it's done via scripting. If you want to show all these fields in one line: item, quantity, from location, to location, you can use two formula columns to do modular arithmetic on the line ids and show the location for each. For example, you can get the From Location with a formula like

CASE WHEN {quantity} < 0 THEN {locationnohierarchy} ELSE null END

. Then appropriately group your results so you get a single line. Please note that you might need to use Max (or Min) for the Quantity column as Sum 300 + (-300) would give zero. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******