BOM in sage anyone?

arfur · 15 Nov 2007 at 16:00

Does anyone know who to use the BOM in sage line 50? I've made a product and it contains many parts using the BOM feature, however when I sell the product the indervidual amounts for the subcomponents are not being reduced, any ideas?

Sone · 15 Nov 2007 at 16:10

why would sub components be lowered? If you could explain what you are trying to day i amy be able to help as we use BOM quite extensibly (although with syspro).

arfur · 15 Nov 2007 at 16:17

basically I run a buisiness, and for agruments sake (and not to get me banned ) we build mmmm car engines....

OK I buy in all the sprockets and springs from suppliers which I can sell as indervidual items, however when I build an engine I go into the BOM and add all the sprockets and springs that make up the engine. Lets say there are 100 sprockets in stock when I do the BOM, when I create my new engine as a product (each engine is a new product as they are all different, it works like a serial number), when I add 1 engine into stock and then sell it I would expect the number of sprockets left in stock to drop as I have used them for this engine, does this make sense?

Ukadder · 15 Nov 2007 at 16:54

Still not 100% sure what the problem is.

Is it the amount of items left in stock not going down after the major item has been put into stock?

The stock levels are not adjusted until the actual item is invoiced, i.e. after the major item had been added to an order, allocated and then dispatched. So the items used on a BOM will not be taken out of stock till they have been dispatched on an order.

What version of Line 50?

arfur · 15 Nov 2007 at 16:57

its version 7, and yes thats exactly the problem, when I sell the main item the sub levels do not appear to be dropping,

Sone · 15 Nov 2007 at 17:37

in syspro you create an event, either a milestone event if you are measuring for loss or a non milestone event if you don't measure. At this stage the sub item comes out of stock.

Is there an "event" system in sage?

Ukadder · 16 Nov 2007 at 15:41

Version 7, are you sure! I remember using that back in the stone ages, Sage Line 50 is up to version 14 now. You really should upgrade (just don't use version 13!)

Wouldn't like to comment on how the BOM works for version 7, it would'nt supprise me if the feature was broken knowing how sage release software.

arfur · 16 Nov 2007 at 15:53

Ukadder said:
Version 7, are you sure! I remember using that back in the stone ages, Sage Line 50 is up to version 14 now. You really should upgrade (just don't use version 13!)

Wouldn't like to comment on how the BOM works for version 7, it would'nt supprise me if the feature was broken knowing how sage release software.

Yep version 7, we dont pay for support as its stupidly expensive so we dont get updates, however I have now worked it out. What I have to do is build up the engine by using BOM, then click on the TRANSFER button, enter the engine number and there you go, the stock goes down.

thanks for you inputs though

Ukadder · 16 Nov 2007 at 15:59

You don't have to pay for support to get updates, just go and buy a copy higher than the version you're using and upgrade it you're self. I agree the support costs are stupid.

nightmare99 · 17 Nov 2007 at 17:16

You have to do a stock transfer,

Go into the products module and click transfer, select the BOM item you want to transfer into stock and select a qty, if you have enough components the BOM item will now appear in stock (the qty you put in) and the component qty's will be reduced.

xirokx · 17 Nov 2007 at 17:28

Does anyone know who to use the BOM in sage line 50? I've made a product and it contains many parts using the BOM feature, however when I sell the product the indervidual amounts for the subcomponents are not being reduced, any ideas?

Have you linked that 1 (final product) to the sub components (B.O.M)??? so that when some creates a sales order for that 1 product made up of sub components , the sub components are reduced?

You may have missed some minor checkbox you have to tick for the 1 (made up) item which will open up a B.O.M window that links sub components to that item??

Alternatively, if I am right, In SAGE, doesnt the stock only decrease once you have invoiced? or Allocated...I think it may be the later, as you have to allocate to an order so to speak otherwise companies stock count would be all over the place if they waited for invoicing at end of month because only then would they get a true stock count...unless they invoiced immediately after allocating stock... I might be wrong...

Good Luck..

Countcussy · 18 Nov 2007 at 00:31

nightmare99 said:
You have to do a stock transfer,

Go into the products module and click transfer, select the BOM item you want to transfer into stock and select a qty, if you have enough components the BOM item will now appear in stock (the qty you put in) and the component qty's will be reduced.

This is correct. SAGE works funny at times when it comes to stock. Some early versions did not allow negative stock, which could be a pain if we got something shipped direct to a customer from a manufacturer.

When you sell an item with a BOM, it will only book that item out of stock.
The items needed to "build" the engine on the BOM list are unaffected by this.

So, you would have to "build" your engine by booking one into stock. This will then book the items on the BOM, out of stock, as they have been used to "build" the engine.

From experience, the best way is to book the item(engine) into stock first. Then invoice it out. This helps keep stock levels correct, especially if you also sell the parts individually, and avoids negative stock levels.