Solved Need some advice for the design of Products table

[MsAccessNL]

I am working on a similiar project. I am building a serialized bom structure for a Dutch company building solar cell calibration equipment.. I started with searching for examples. Here are some links of software sites with info about Bom inventory and MRP (Material Resource Planning). I am following your posts. These are the links i found interesting:

https://support.axolt.com/docs/erp-documentation/manufacturing-service/work-order/

https://support.accountingseed.com/...4-Kit-Products-with-Sales-Orders-and-Billings

https://www.inflowinventory.com/sup...kits-out-of-raw-materials-using-a-work-order/

https://learn.erpag.com/project/manufacturing/work-order/bom-based-work-order

https://realtrac.com/our-solution/purchasing-and-inventory/bill-of-material/

Bom en Mrp (Material resource planning) software

 

[RogerCooper]

I am the VP of MIS for a manufacturing firm. I would strongly suggest you get an ERP designed for a manufacturing company rather than try to recreate it piecemeal in Access. (We use Visual Manufacturing from Infor). You need do a lot more than track the parts that are used to make a product. There are purchase orders, work orders and customer orders. You need to track inventory and labor operations. In Access is a very useful tool, but you can't expect it to do everything.

 

[MsAccessNL]

I am the VP of MIS for a manufacturing firm. I would strongly suggest you get an ERP designed for a manufacturing company rather than try to recreate it piecemeal in Access. (We use Visual Manufacturing from Infor). You need do a lot more than track the parts that are used to make a product. There are purchase orders, work orders and customer orders. You need to track inventory and labor operations. In Access is a very useful tool, but you can't expect it to do everything.

I agree with you in terms of investement and time. I already proposed to my client to look at already available systems. I think, in my case, that they are looking for a tailor made solution (they are producing 6 specialized products). I think it can be done in Access, but it will be a big project and in KitaYama case, he has already made an application and is looking how to extend it with more functionality (if a understand the post correctly).

 

[KitaYama]

but you can't expect it to do everything.

Though I don't know what VP of Mis means, but thanks for the advice, but we're doing great. An out of box ERP, is an out of box and is designed in a way to cover an average requirement for an average company. It's not meant to be customized to a particular need and we have to use it As-Is.

But with an in-house application, the case is different. We need to implement a new rule? The next week, the new rule is in place and running.
You may be surprised by what Access is doing for us? Which ERP can read data from PDM and send it to a target CNC machine?
Which ERP can be customized per individual users' need?

 

[gemma-the-husky]

VP is vice president. Not sure about mis.

That's the benefit of choosing bespoke development. You get what you want. You don't have to make compromises. Improvements are quicker. It's free (apart from the internal costs, which might not be a saving, as the development is not shared). It might give you a competitive advantage.

I wouldn't be surprised if your system is better than your competitors. It can happen when you really understand both development and your own requirements.

 

[Pat Hartman]

MIS = Management Information Systems