how can I add a column in items during inventory t...
# ask-stanley-ai
a
how can I add a column in items during inventory transfer to show quantity left after transfer
c
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. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847217619
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.843386889
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830946207
Please provide your feedback on this answer.