Default quantity when adding new Product lines

[radu]

Hello,
When you add a new product/service on a Purchase Order the default quantity is 1. Also if you generate a PO from a product. What is the proper procedure for giving it another value, a numeric field on the product item?
I noticed the quantity value is saved in vtiger_inventoryproductrel table, but how do I set that field? I tried with a field set mapping Products2PurchaseOrder with 'quantity' as fieldname and the custom field in products as OrgfieldName but it does not seem to work. I checked the wiki and the forum but it is still unclear to me how can that field be controlled.
I can easily set the quantity in the releted InventoryDetails but that does not reflect in the quantity on the PO.
Thanks

[joebordes]

Try with the Inventory_Product_Default_Units global variable

[radu]

(11-18-2020, 09:17 AM)joebordes Wrote: Try with the Inventory_Product_Default_Units global variable

Got it . Thanks. I did check the GV's but was looking for 'quantity' so i overlooked that one. That works for a given number. How would one pick the value of a specific numeric field in products? Do I have to use a business map in that GV to somehow retrieve the value of that field?

[joebordes]

I don't think we have support for that. There may be (should be) a hook to plugin your functionality but I don't remember right now.

[radu]

(11-18-2020, 10:47 AM)joebordes Wrote: I don't think we have support for that. There may be (should be) a hook to plugin your functionality but I don't remember right now.

My thoughts exactly . Initially I figured it's more obvious, then I thought about a hook to get that data from popup but it was not clear to me how to work with that quantity field, how to address it. I still don't know but I will play with it now that i know the general direction.
As a faster but not complete way to get that info displayed was to get it in a custom field in InventoryDetails and display it in Information column on the PO's detail lines.

Thanks!