Page 1 of 1

Sage Line 50 auto allocation of BOM components

Posted: 09 Jul 2008, 13:32
by paiger
Hi, first post here. A bit of background. We run a company which sells on an Actinic website, ebay and amazon. Our website has a built in sage link to pass orders and data to and from sage. We can also use Tradebox to automate ebay and amazon orders into sage.

Now, our accounts system is Iris Accounts Office and it's a bit of a pig getting all the data in there to create orders. The one big bonus is that we sell a lot of bundled products as BOMs and do not wish to pre-allocate the component items to them until they sell. Iris does this automatically. So, say you have an item called 'Box of 50 Widgets' and that's a BOM with a make up of 50 'Widgets' you can set the BOM stock level to zero and it will take 50 from 'Widgets' when an order comes in for the BOM. If you had 0 of the BOM and 150 of the Widget, you would be left with 100 of the Widget once processed.

I was told in Sage that you would have to manually allocate items to the BOM to do this. Is this true or is there a check box somewhere to change to auto? I ask because we rejected Sage on these grounds even though it seemed to have everything else we wanted. As Sage won't let me have a demo to play around with, I gave up on it.

I also feel a bit annoyed about the support I have recieved from Iris who tild me me it would all go swimmingly and it turns out that I have personally had to a lot of legwork with csv's and macro's to get the raw data to import in the correct way. Also, the order processing side of it is clunky and badly thought out, even if it looks good in the surface. In use, it's not so friendly.

Is there a solution to these issues within Sage Line 50 as I am quite prepared to dump Iris for a better solution. Thanks in advance.

Posted: 18 Jul 2008, 15:23
by brucedenney
By design the BOM system transfers items of stock from one set of product codes to another.

It does not do this automatically. You have to manually tell it how many you want to create.

The integration kit we use with sage, could possibly do it, I guess it would have to be done as a batch process once a day though. You then have to consider how you want to handle things if there is not enough stock.

Sage normally provide a download trial version of Sage 50, unfortunately the link is broken as sage are updating the website. There is also a copy on runaware.com that you can try out.

Of course there are other ways, You could "explode" the BOM in the Sales Order when you import it from the Website Sage. Yuo could then have a layout that only prints the BOM details rather than all the components.

This would enable you to part ship part of a BOM if you wanted to. I guess it all depends on your application.