Using Assembly Items in Sage 50 Inventory

[@umerdar3389]

If i am using an old version of sage accounts 50 will i be able to amend bill of material at the time of production as this is a big concern for me

[@jacobfisher7119]

I need to associate lot codes with my bill of material items. Those lot codes will change when I receive more of that item. Once they are entered into a build I need to be able to go back and find those specific lot codes. Thank You

[@IQAcctSolutions]

Sage 50 doesn't support lot tracking at all. In theory you could probably build a lot number into your item ID. That would mean creating an entirely new item every time a different lot was received, and creating a new BOM revision. While it may work in theory, in real life I would expect it to be a nightmare to maintain. Have you looked at any of the manufacturing add-ons for Sage 50? Sorry about being so slow to reply.

[@6of7w]

If I build an assembly with sub-assemblies in it how do I get it to show bill of material of sub-assemblies on an invoice?

[@advancedcopy4630]

So how do you set up your assembly items to go through your inventory accounts? Raw Materials, Work and Progress and Finished Goods. I don't see how to do this.

[@IQAcctSolutions]

Sage 50 isn't really designed to track raw materials, WIP, and Finished Goods, but in some cases it can be done. When you build an assembly, the value of the components will be credited to whatever account is designated as the inventory account on each item on the assemblies bill of materials. Based on that you could set up your inventory as follows: For all of the items that are raw materials you would set the inventory account to Raw Materials so that they will post to that account when purchased and removed from that account when used in as assembly. Set your sub-assemblies to use Work In Progress as their inventory accounts. When you build the sub-assemblies the value of the raw materials on the sub-assemblies bill of materials will be relieved from Raw Materials and added to Work In Progress. Set the inventory account on all finished goods to your Finished Goods inventory account. When assembled, the sub-assemblies will be moved out of Work In Progress and into Finished Goods. I realize that real life can be more complex than that, but this method is all Sage 50 offers.

[@cynthiarivera910]

If I'm using unit of measures for one of the components, does the assembly use the sales u/m?

[@IQAcctSolutions]

The quantities on the bill of materials use the stocking unit of measure.

[@ajbpestandtermite1169]

we are a pest control company that uses liquid or granular chemicals. Liquids are diluted. Will Peachtree allow me to set this up using ounces etc.?

[@IQAcctSolutions]

The bill of materials will use whatever measure you stock that item in. So if you haven't set up unit of measure conversions, and you purchase a particular chemical by the gallon, then any assemblies you use it in would use it by the gallon. As long as you can come up with a decimal equivalent for the amount you use (this is the one time I wish the U.S. was on the metric system), it will work. You should probably look into using unit of measure conversions. I don't have a video about them but I have a blog post at www.iqaccountingsolutions.com/blog/unit-of-measure-conversion-sage-50/