BOM is where i'm stuck, every book i've read so far has nothing on this. Any sharing would be appreciated. Local time Today, Joined May 3, Messages 1, Having participated in various MRP system programming projects, I salute you for your courage, for I can tell you that you have undertaken no lightweight project.
You will get a far better and quicker ROI than you will by spending time re-designing the wheel. If, however, you still wish to pursue this project, I recommend searching Google with "MRP design", for a plethera of research material. From this you can decide how best to scale your solution based on the relevant requirements for your business. You can also search this site for excellent advice and examples on Visual Basic programming for MS Access.
With this information, and with the information on the MRP design concepts, you can then decide how best to write the code for your particular solution. If, after all of this, you make progress on your project, but have questions on specific issues with the development, feel free to post them here, and we will answer your questions to the best of our ability. Thanks for your input ByteMyzer. This is indeed an ambitious project. I would love to just purchase an MRP system but money is tight and we have to use what we have.
I have an extensive planning background and have worked with several MRP systems at previous jobs so I do understand the complexity of such a system.
This started out as just a way to track orders than I added shipping details and shop orders and inspection forms etc. It has grown to be a useful tool and I am slowly expanding it. The first big hurdle was how to explode a multi level BOM which I was able to create a work around with a union query but it is not as versatile as I would like.
I am sure I will be posting specific questions as I start creating code to solve my issues. Again thanks for your input and any other comments or suggestions are welcome. Colt45 Registered User. Local time Today, Joined Jul 21, Messages I don't yet know enough VBA to try and programme the algorithm, but the approach I have taken for multi-level BOM explosion is to start from the absolute top or bottom of the BOM and run sequential queries to identify all the intermediate level.
So if QueryA gives all the components of the top level, then query B will find the components of Query A. Query C will find the components of query B etc. Continue that until no more BOM levels are found i.
Query X contains no records , then add a few extra query levels to ensure you know if more levels get added. I tend to append the query results to a table which builds up level by level as I've found that subsequent performance is much faster from a table than by constantly requerying.
This brute force approach has been quite effective for me, and thought I would share it. Thanks for your response Mr. Cool name. I think we are taking similar approaches however your idea to use an append query to a temporary table is a good one. My objective is to get a material requirement report based on the open orders from the top level product finished goods. Currently I am using multiple queries all stacked up in one big union query.
It does have a finite number of levels it will go, which is ok for now but i would like to make it more versital as you suggest with some sort of if statement.
I think my union query uses a lot of system resource and writing it in vba might help that. I get can't open another database errors sometimes. I am reading VBA for dummies and hope to write something that will be more versatile and more efficient. Thanks again for your input and please share anything else you think of. Hi Ashley, unfortunately I am not yet in any way proficient in VBA - but if I could write, the algorithm would work like this: 1.
Start with list of top-level finished goods in my environment they are independently identifiable, so no need to query the BOM to identify them. Use the BOM table to identify the first next level subordinates and the draw quantity from the FG at that level 3. Append the level's information to the multi-level BOM table 4. Repeat 2 until no more subordinates are found a null recordset being returned would identify that 5. Another query will aggregate up the demand for each component as a given component could be a component of many FG.
Hope this helps! Local time Today, Joined Feb 28, Messages 1. Ashley: Make or buy? Here's an MRP system all done in Access. Make a product so it has a bill of material, or buy so it has a vendor. Thanks Rock I will check that e z mrp out. Thanks for the response. Navigate by project, deliverables, and employees, keep an eye on budgets, owners, costs, and status, and generate focused reports such as Project Balance Sheet and Deliverables by Assigned.
Create a project tracking database to track multiple projects, including time-sensitive deliverables, owners, and budgets, using this popular Access template. Navigate by projects, tasks, and employees, keep an eye on costs, priorities, and status.
Create a personal account transaction database to track income and payments across domestic categories from groceries to healthcare to charitable donations using this Access template. Search and view income and expenses by category and view tax reports. A field for memos helps you remember handy details for every transaction. Create a customer service database to manage multiple issues tracking assignments, priority, status, customer, and resolution using this Access template.
Navigate by open cases using multiple criteria, create and manage knowledge base articles, and manage customer details while producing useful reports such as Open Cases by Assigned To and Overdue Cases. Create and maintain an up-to-the-minute database of your business contacts and call history using this simple yet effective Access template. In addition to maintaining details on company, job title, and contact information, you can navigate and search by contacts, calls by contact or subject, as well as add contacts from Outlook.
Assign and track status of customer calls using this dynamic Access template. Navigate by customers, employees, and calls, as well as track by priority, status, and assignment. And you can generate useful reports in real time such as Open Calls by Assigned To that can give you the extra edge you need when things get busy. Create and manage a home inventory database to retain and manage vital data on your personal belongings using this Access template.
Search by item name, category, or location, while retaining important details for insurance purposes, such as condition, acquired date, and value. Attach photos of items to each entry to help ensure reimbursement in the case of loss or damage. Manage your organization's client cases and projects, including billing, invoices and balance sheets using this robust Project time and billing Access template.
Fields for owner, workcode, and status help you track progress, time worked, and costs while you generate instant reports on everything from Billing by Workcode to Employee Time. Manage your accounting books with this business account ledger template. This database can track income and expenses by category and generate financial reports. Manage your entire workforce's hours worked using this robust time card Access database template.
Fields for workcode and description help you keep track of costs and work areas while you generate instant reports on everything from Billable hours by Employee to Billable Hours by Project.
Manage your project's open issues with this popular Access database template. Maintain details about issues and issue assignments, as well as track opened dates and deadlines. Fields for status, category, and priority help keep things moving forward and powerful navigation allows you to instantly get a handle on what's happening and continuously up your game. Create and manage a vehicle maintenance database for your organization's fleet, tracking servicing, shops, dates, and mileage, as well as costs, using this popular Access template.
You can create reports on estimates of future expenses on each vehicle and for the entire fleet and attach invoices and image files to each record, documenting vehicle appearance and condition. Manage all your organization's fundraising campaigns, maintaining current data on contributors, donations, events, and tasks across multiple campaigns using this robust Access database template. Track fundraising goals, generate reports on ongoing campaigns, and maintain details on contributors while instantly being able to see the extent of unpaid pledges, and view pending tasks as well as upcoming events.
TubeMate 3. Google Play. Microsoft is done with Xbox One. N95, KN95, KF94 face masks. Apple pulls Wordle clones. Windows Windows. Most Popular. New Releases. Desktop Enhancements. Networking Software. Trending from CNET. Download Now. Developer's Description By Aksa Networks. Microsoft Access Inventory Management Control Templates will help you to track and evaluate your warehouse or store inventory database.
This ms access template has these features: 1. Full Specifications. What's new in version 1. Release September 15,
0コメント