SageForum for UK versions of Sage 50- Help and support.

We have Sage 50 Accounts Pro (v21.0.3.297) and I'm trying to set up some product BOMs.

We have maybe 20 products (each slight variations of each other) made up of about 15 items per product.

I know I can create the BOMs for each product manually, but I'd much rather save a *huge* amount of clicking/typing and work out how to import the BOM info from a CSV file.

As far as I can tell, although I can *export* the BOM info, there's no way to actually *import* it using the Import Wizard

Am I being stupid, or is this not a normal operation that Sage supports ?

If not, is there any way to do this ?

Thanks for any help / advice.

Mark J.

Not with the Standard import on Sage 50.

You can with an add on.

Or you could ask me to do it for you if it is a one off.

What add-on would that be?

It might be worth investigating that option.

Cheers

It is called Import+, I am a reseller if you want more info, current price is £225.

If you contact me I can set you up a trial and a copy of the code needed to import BOMS

Here are the import format specifications:-

Import Line 50 BOMs (Bill of Materials) from a 3 column csv.
The first column is the 'parent' stock code (which should already exist), the second column is a component stock code (which also should already exist), ther third column is the quantity of the component that is used in the BOM, e.g.
"PC002","CAS001",1
"PC002","CDR001",1
"PC002","HAR001",1
"PC001","CAS003",1
"PC001","CDR001",1
"PC001","HAR001",2
"PC001","KEY001",1
"PC001","MEM003",4
"PC001","MON001",1
"PC001","MOTH001",1
"PC001","MOUSE004",1
"PC001","PRC001",1
"PC001","VID001",1