HOW TO - Print labels with X products quantity?

[Alejandro Guerra]

Hi all,

how do I generate a report that will print out the amount of barcodes for the amount of items in stock for each product?

Regards,

Alejandro

[Anozi Mada]

Hi Alejandro

You can try something like this

SELECT p.UPC, s.QtyOnHand, generate_series(1,s.QtyOnHand::int)
FROM M_StorageOnHand s
INNER JOIN M_Product p ON (p.M_Product_ID = s.M_Product_ID)
WHERE s.QtyOnHand > 0
AND p.UPC IS NOT NULL

Regards,
Anozi Mada

[redhuan d. oon]

Very good idea you given me Anozi. I will incorporate this as a config setter for http://wiki.idempiere.org/en/Plugin:_Alternative_Output

[Alejandro Guerra]

Hi Anozi,

thank you 

regards