Unfortunately, I can not use any 3rd party add-on's.
At least I can stop looking for find a way that isn't there now, thank you.
Is there a way check multiple BOMs together to account for common parts across products. Example, I've received a sales order for product A and B, product A uses components 1-5 and product B uses components 3-8, so they both use components 3, 4 and 5.
I want to check everything I need to build these products but I can only check 1 BOM at a time so each time I run the "Check bill of materials" it will only account for parts to build one product at a time, ignoring anything else I might want to build along with it.
This produces 2 lists of parts which I then need to manually cross reference for common parts.
If all my products had 5 components it wouldn't be too bad, but my products have 50-150 components.
So can I essentially run off a consolidated shopping list against a sales order?
There is nothing within standard Sage 50. There may very well be 3rd Party Add-ons out there; Adept have a BOM tool but you might want to talk to them about it to see if it does exactly what you want.
Unfortunately, I can not use any 3rd party add-on's.
At least I can stop looking for find a way that isn't there now, thank you.
I dump my product lists out to Excel and each product with a BOM to different excel sheets as a list of parts. Then I have another sheet that can aggregate various build quantities for the various parts. To maintain this I just re-do the export all products and save it over the master all products spreadsheet. My BOMs are electronic products, the parts being the components to make them, so the BOMs can be large. It took a little while to set up but works quite well.
I wouldn't know where to start in order to set that up, if you can provide any further info or an example excel file to help understand the process, that would be appreciated.
Thanks.
I'll give it a go! I have a bit of time today so I'll have a go at writing up what works for me. Probably should document it anyway.
Hmm, well it's 'easy' to do but a pain to write up without sending you a load of data. I'll drop you a PM
Hi Ross
An Excel report using the data from Sage 50 could be built to give you this information. We'd suggest it's an ODBC report from Sage 50 into Excel that refreshes automatically to give up-to-date details. It could also be used by non-Sage users depending on your setup.
If you want to have a chat about it and see something in action, feel free to get in touch.
Kind regards
Bec
Managing Director
Sage Accounts Solutions Limited
Hi Ross
It's a bit rough and ready, but the resulting ODBC report could look something like this.
The data could be sliced a variety of ways depending on what you prefer:
Kind regards
Bec
Managing Director
Sage Accounts Solutions Limited
Training | Consultancy | Support | Software
www.sageaccountssolutions.co.uk
Join our free Facebook support group for Sage 50 Accounts
*Community Hub is the new name for Sage City