Hi all, How to get Virtual Stock and Real Stock in Report, I want list products and available quantity and virtual quantity, cost price report, i create a function for this my doubt is how can i put in rml.
def demo_product(self,form):
vals={}
pro=self.pool.get('product.product')
ids=pro.search(self.cr,self.uid,[])
pro_len=pro.browse(self.cr,self.uid,ids)
qty_available = 0.0
for line in pro_len:
vals={'name':line.name_template,
'code':line.default_code,
'availqty':line.qty_available,
'onhand':line.virtual_available,
'virtualqty':line.incoming_qty,
'outgoqty':line.outgoing_qty,
}
return vals
in my rml
<section>
<para style="terp_default_9">[[ repeatIn(asimo_product('form'), 'vals') ]]</para>
<blockTable colWidths="75.71,75.71,75.71,75.71,75.71,75.71,75.71" style="Table1">
<tr>
<td>
<para style="terp_tblheader_Details">[[ vals ['name_template'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details"> [[ vals ['default_code'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details">[[ vals ['incoming_qty'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details">[[ vals ['outgoing_qty'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details">[[ vals ['qty_available'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details">[[ vals ['standard_price'] ]]</para>
</td>
<td>
<para style="terp_tblheader_Details">[[ vals ['virtual_available'] ]]</para>
</td>
</tr>
</blockTable>
</section>