Combining an Inventory & Service Item

Setting up our company file.  We are not live yet (January 2015) so I have an opportunity to set things up correctly from the beginning.  I want to make an inventory item that is a combination of an inventory item (product) and service item (labour).  We sell this product and service as a combined service/fee to customers and do not want them to see the breakdown on the invoice.  The combined service/fee is $199.99.  Right now, if I create an invoice I have to choose the inventory item which our pricing is set at $50.00 and the service item which is set at $149.99.  We do not sell the inventory items individually.  Our cost on the items is $13.03 per unit.  All of my inventory is posted correctly based on our costs and our pricing tables reflect our mark-up.  So as it is, it's correct, I simply don't want our customers to see two separate items on the invoice. 

I've tried the Build from Item Assembly module but it only allows me to choose the inventory item and pulls our cost of $13.03.  If I manually plug in the difference of $189.96 in the Additional Cost field in order to make the combined item $199.99, it codes that as an expense which it isn't, it's revenue.

Maybe this isn't possible?

  • 0

    You can apply costs from a G/L account using the 'bill of materials' functionality combined with information in the 'Build' tab of a part item, to apply labour cost + inventory items into a new inventory item.

    This can't be made automatic, so if you have negative inventory disallowed (which is preferable, for several reasons), you will have to 'build' them in advance of invoicing them out.  

    There is no direct equivalent to Quickbooks' "kitting' function in Sage 50.   You can sort of do common sales packages with a sales invoice "recurring transaction" template, but your customer will see all the details printed out.  

    Sage 50 "bill of materials" is more of a 'manufacturing a wall mount bracket' thing than a 'Sell a home entertainment package' type of thing.

    I hope that helps, please post back.