how can I add a column in items during inventory transfer to show quantity left after transfer

AI generated answer (using internal Slack threads):

To add a column in items during inventory transfer to show quantity left after transfer, you can create a new column field. Here are the steps: 1. Go to

Customize > New Column Field

. 2. Set the

Source

to

Item

and

Source From

to

On Hand

. However, this will give you the data from all locations, not only the specific location of the current Transfer Order. To get the quantity on hand for a specific location, you might need to use a saved search or a SuiteScript to fetch the data. If you want to show this information on a single screen, you might need to customize your transfer form to include this new column. You can add the native column for

On Hand

to your Transfer Order form. This field should show dynamic values based on the (send) Location. If you're trying to prepare a saved search which shows inventory transfers in one line instead of two, 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. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******