webERP and Excel

[agaluski]

I created the attached report using PHPExcel and found it easy to use.
I also think the report is pretty good from a business perspective if you have controlled items (Lot / Serial).
The report lists all OH Lots assuming you have applied the SQL below and ages them by date they were created. So you can see old inventory you might need to have a fire sale on or get your salespeople to push. Then it also lists incoming inventory and expected dates. It gives yhou a very nive picture of your inventory

ALTER TABLE `stockserialitems` ADD `createdate` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ,
ADD INDEX ( `createdate` ) ;
UPDATE stockserialitems SET createdate = NULL;

UPDATE stockserialitems as stockserialitems SET createdate=
(SELECT trandate FROM (select trandate, stockserialitems.serialno, stockserialitems.stockid from stockserialitems
LEFT JOIN stockserialmoves ON stockserialitems.serialno=stockserialmoves.serialno
LEFT JOIN stockmoves ON stockserialmoves.stockmoveno=stockmoves.stkmoveno
GROUP BY stockserialitems.stockid, stockserialitems.serialno
ORDER BY trandate) as ssi
WHERE ssi.serialno=stockserialitems.serialno
AND ssi.stockid=stockserialitems.stockid);