Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Inventory Export into CSV or Excel
01-03-2014, 04:54 AM,
#1
Inventory Export into CSV or Excel
Hello,

I have a few questions.

1) Is there a way to export inventory valuation into CSV or Excel , currently it is in PDF format only.

2) Inventory Quantities list all inventories. Is there to export into CSV, part number, type of inventory and value of the inventory?

3) Is there a way to more than one approved source for a Part Number for the BOM function? I have several alternatives that are approved and would like to be able see them all in the bom, as well as for purchasing purposes.

Thank you



Reply
01-03-2014, 04:51 PM, (This post was last modified: 01-03-2014, 04:53 PM by phil.)
#2
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
Reply
01-03-2014, 08:48 PM, (This post was last modified: 01-04-2014, 08:21 PM by Forums.)
#3
RE: Inventory Export into CSV or Excel
(01-03-2014, 04:54 AM)mhoskins Wrote: 1) Is there a way to export inventory valuation into CSV or Excel , currently it is in PDF format only.

It is actually very easy to change a report to export to csv as well as pdf. Please find attached a version of Inventory valuation report that does just that.

Tim


Attached Files
.php   InventoryValuation.php (Size: 11.44 KB / Downloads: 9)
Reply
01-04-2014, 01:17 AM, (This post was last modified: 01-04-2014, 01:20 AM by Forums.)
#4
RE: Inventory Export into CSV or Excel
I should also have mentioned this script needs write access to the reportwriter directory under your companies directory

Thanks
Tim
(01-03-2014, 04:51 PM)phil Wrote: 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?

Phil, they are only wanting to see one partnumber in the BOM, but to see each supplier for that part.

Tim
Reply
01-04-2014, 08:22 PM,
#5
RE: Inventory Export into CSV or Excel
(01-03-2014, 08:48 PM)Forums Wrote:
(01-03-2014, 04:54 AM)mhoskins Wrote: 1) Is there a way to export inventory valuation into CSV or Excel , currently it is in PDF format only.

It is actually very easy to change a report to export to csv as well as pdf. Please find attached a version of Inventory valuation report that does just that.

Tim

Phil has now updated this to svn. Credited himself with it, but never mind at least its there for people to use!

Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)