Erp Forum: The Sage Forum Site

Is it easy to import BOM's

A recent aquisition needs to be imported to sage.

It is reasonably easy. There are a few things to watch out for:
- Unless you're importing alternatives and supersessions on the line items, ensure that your sequence numbers end zero.
- Watch the expiry date. You want this set to the 2099-12-31 if you're on SQL Server.
- Spare and circuit number tend to go hand in hand except one is a string with leading zeros and the other an integer. Do this in Excel
- The header holds next circuit number. I've found that rather than trying to do this in Excel, use SQL script to update it once you've loaded the detail lines.

That should get you going.

Good luck.
Pierre

Cheers Pierre

I will try this and let you know how I get on

Hi blogan

Defacto solutions have a BOM import module, which allows you import bom from a csv, excel or sql table.

http://www.defactosolutions.co.uk/

Regards

Steve

Thanks Steve but even though I am struggling a bit with doing this in sequel, this is a one off and doesn't really warrant buying a module.

If you are still having problems with this import please send me the data and I will send you back the load files for bmasshm and bmassdm.

All I need is Main assembly_warehouse, assembly_product, component_warehouse, component_product, usage_qty and unit of measure.

I have scripts to do the rest.

If it is something you haven't undertaken before then try downloading your tables first (Or an extract of a similar product to the one you want to upload if the tables are too big)
I generally use MS Access combined with MS Excel but for BOM's I tend to use DTS in SQL 2000 as it is more intuitive if an error occurs - it tells you which row and why it errors out.

Also:-
Take copies of the tables BEFORE upload.
Try this in DEMO first.

If you are happy with the outcome go ahead.

I realise this reply is old but just in case people are wondering whether this can be achieved. The answer is simply yes but you do need to ensure it's accurate. Your job or lack thereof will probably depend on it. Imagine misplacing the stock unit or the decimal place and consuming a factor of 100 more than you needed to. We have both the Sage expertise and routines to do this quickly as a one of exercise.

We've done this several times for electronics companies even where circuit references and through several layers are required.

You can reach us at : http://www.golddiskcomputers.co.uk

vzone288 wrote:I really enjoyed all the great information in your article!

I think she only wants you for your body Anthony, or maybe your money.
But that's OK!