RE: Inventory Export into CSV or Excel
Hi
1) You would need phpMyAdmin and run a query like:
SELECT stockmaster.stockid, categoryid, materialcost+labourcost+overheadcost AS cost, sum(locstock.quantity) FROM stockmaster INNER JOIN locstock ON stockmaster.stockid=locstock.stockid GROUP BY stockmaster.stockid, stockmaster.categoryid
you would then be able to export the results to excel from phpMyAdmin
It would be easy enough to automate this as we have with
webERP/StockQties_csv.php
2). You can use phpMyAdmin to export any combination of inventory fields - see example above
3) No - the BOM must be unique - at any point in time. How would you decide which ones to purchase if any of them could be used in the BOM?
You can certainly set up muliple supplier purchasing data for a single item - so that the same item could be purchased from several different sources/vendors - each with a different cost and lead time - only one of them is allowed to be the preferred supplier (vendor). The vendor item code may be set up in the purchasing data as different and all these different items may be referred to as the same item in the item master (stock master).
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
|