Solved Need some advice for the design of Products table (1 Viewer)

MsAccessNL

Member
Local time
Today, 17:39
Joined
Aug 27, 2022
Messages
185
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

Registered User.
Local time
Today, 08:39
Joined
Jul 30, 2014
Messages
297
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

Member
Local time
Today, 17:39
Joined
Aug 27, 2022
Messages
185
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).
 
Last edited:

KitaYama

Well-known member
Local time
Tomorrow, 00:39
Joined
Jan 6, 2022
Messages
1,634
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?
 
Last edited:

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 16:39
Joined
Sep 12, 2006
Messages
15,758
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.
 

Users who are viewing this thread

Top Bottom