I need to make special query to display the warehouse and the actual_qty of the choosen item in all warehouses so the user can choose which warehouse to issue from it.
I need to make this query :
“select tabBin.warehouse, tabBin.actual_qty from tabBin where tabBin.item_code='”+d.item_code +“’ and tabBin.actual_qty>0 order by actual_qty”
How can I do that, so the user can see the actual_qty in each warehouse when he chooses the warehouse.
This was available in old versions but in version 6 I don’t know how to do it ?
@hfarid sorry to hijack your topic in some way. I am trying to get a little more attention to a funding campaign some community members are trying to get off the ground which aims at adding a sub/parent-warehouse feature to ERPNext.
As you are currently dealing with warehouse functionality you will benefit from such a feature greatly I am convinced. Please feel free to check the related topic and add some funds on this from your side here. Minimum contribution is as low as $15
Or maybe you are a talented developer and want to code this