On the line item level on transfer order, I am abl...
# administrationr
Richard Liu
02/24/2021, 9:57 PMOn the line item level on transfer order, I am able to see quantity on hand specified on the line item field for each item, but is there a way to get the quantity on hand for each warehouse/location?
n
Netsuite Tragic
02/25/2021, 12:23 AM@Richard Liu I’ve done this with a new line field with the sourcing from Item:Location On Hand. Was on an SO but I would expect it’s the same for TO.
r
Richard Liu
02/25/2021, 12:26 AM@Netsuite Tragic I can’t seem to find the line field you mentioned for Location On Hand field. I did find the one you specified can be utilized in the saved search, but it does not have Location On Hand at sourcing list from transaction line field.
n
Netsuite Tragic
02/25/2021, 1:22 AMJust checking in, when entering a TO, the "On Hand" line figure is the 'location' quantity.
Netsuite Tragic
02/25/2021, 1:25 AMLooking back at the work I did my requirement was to display the receiving location's current qty, which I did as follows: NVL({custcol_company_on_hand},0)-NVL({quantityonhand},0). As this customer only had two locations, the receiving location always had the balance of inventory.
r
Richard Liu
02/25/2021, 4:56 PM@Netsuite Tragic Thanks for the input and I will try digging more fields that might show the info I need.
4 Views