is there a way to get the QTY avilbile on invenetroy transfer not just QTY on hand

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that getting the quantity available on inventory transfer, not just the quantity on hand, is not directly available on the line item level on the transfer order. However, there are a few workarounds that you can try: 1. You can create a new line field with the sourcing from Item:Location On Hand. This was done on a Sales Order (SO) but it might work the same for Transfer Order (TO). 2. If you have a limited number of locations, you can display the receiving location's current quantity using a formula like this:

NVL({custcol_company_on_hand},0)-NVL({quantityonhand},0)

. This formula subtracts the quantity on hand from the company's on-hand quantity. 3. If you are comfortable with SuiteQL, you can use a Suitelet to get a report of the quantity on hand per lot number per item as of any date selected. You can refer to this [link](https://timdietrich.me/blog/netsuite-inventory-balance-history-suitelet/) for more information. 4. Quantity on hand is not the same as quantity available. Quantity available considers other transactions that might be consuming the stock. You can check the transactions for that item that are open to see if they are consuming the stock. Remember to always check the reallocate items screen as it may provide more information. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******