Hello,
Pls guide me to make bill of materials software.
It should import multiple excel sheet & should be able to compare those sheet & should give me lowest price of the materials which is being compared.
Some reference below :
https://ciiva.com/bill-of-materials-software/overview
https://www.youtube.com/watch?v=Siw3unvzTMQ
Can we make software like ciiva in scriptcase?
Any examples if there pls help me out.
Regards,
Dev
Hi dev,
You can certainly create the BOM in SC.
This is not a Technical answer but more of a general guidance only.
To replicate the existing reference software you need to understand the business processes first.
Any BOM should start of with a good inventory management (there is an Inventory example in SC).
The BOM is just a mixture of different inventory items which when combined make a full product.
Herer is an example for a basic bom setup with tables
Inventory Table:
inv_code
inv_type <<= Type of the inventory item, stocked, special, Bom Header etc
inv_name
inv_description
Bom Table:
bom_header <<= inv_code from inventory table where inv_type = Bom Header
bom_component <<= inv_code from inventory table where inv_type != bom header
You can then create your applications based on the above and start entering teh data.
However you will need to add a lot of business logic to get your product working similar to the reference site.
Regards and best of luck in your work
Anil
Check out here: https://github.com/PHPOffice/PHPExcel
A complete way to read/create excel files…
Maybe this will give you more usefull links : http://stackoverflow.com/questions/3930975/alternative-for-php-excel