Skip to main content
December 12, 2019
Question

How do we deal with multiple suppliers to create a final product in the online version?eg part 1 from supplier 1, parts 2 & 3 from supplier 2 - combined to make 1 item.

  • December 12, 2019
  • 2 replies
  • 0 views
The final item will have 1 cost price.

2 replies

December 12, 2019

Good day, @specialistsupple.


Combining multiple products from suppliers into one final product is unavailable in QBO. Though here's a workaround that was provided by Rustler, this might help.


You can create a vendor called inhouse, a finished product as an inventory item, and a cash type for a bank account called WIP.


Here’s how:

 

  1. Use an inventory adjustment, set the adjusting account to the WIP bank account and lesser the quantity of all items used.
  2. If this is outside process cost that also paid, use this WIP bank account as the expense for the payment.
  3. Pull up an expense transaction and choose the in house vendor:
  • In item details, choose the finished item. Enter the quantity made and the total amount that is in the WIP bank account.
  • In the account details, select the WIP account and enter the same amount as a negative number.
  • Then save the zero dollar transaction.

 

In this workaround, the cost accumulated in the bank account, the total paid for the inventory item, the stock with the quantity and the WIP bank are zero until you wanted to need it again.

 

Also adding this article here for a reference on how to set-up inventory in QuickBooks: Track your services or non-inventory items.

 

If you have any other questions, please post a comment below. I’ll be right here to help.

 

 

December 14, 2019

Hi,

When you say create a new vendor, do you mean create a new Supplier as I dont see Vendor in the Expenses tab, only Supplier?

AlexV
December 14, 2019

You are correct, specialistsupple.

 

Vendor is just the same as Supplier. Click on New supplier to set up a new one.

 

I want to share something about creating a product. As what Fiat Lux - ASIA said, QuickBooks Online doesn't have an assembly feature. Although, we can set up a bundle item. This is a combination of multiple item. You can read this article for more details: Change Product and Service types. You can follow these steps on how to create a bundle:

  1. Go to Sales and select Products and Services.
  2. Hit the New button.
  3. Click Bundle. Enter all details needed.
  4. Select the inventory items on the Product/Service section.
  5. Click Save and close.

Comment again if you need further assistance.

Fiat Lux - ASIA
December 13, 2019

@specialistsupple 

There is no assembly feature yet in QBO. Consider this app and integrate it with your QBO.

 [removed]

 

Fiat Lux - ASIA
December 15, 2019

@Fiat Lux - ASIA wrote:

@specialistsupple 

There is no assembly feature yet in QBO. Consider this app and integrate it with your QBO.

 [removed]

 


resend the info. Hopefully it is not removed

https://katanamrp.grsm.io/katana

 

December 15, 2019

This app is too big and expensive just for my requirement.

 

Does the workaround you mentioned in your 1st response not suitable foe my requirements?

Is there a workaround to achieve that I need?

 

Thanks