Thank you for this instruction. We are using Enterprise with Advanced Inventory, having assemblies within assemblies and have confusion how inventory is pulling from various sites. It's hard to know whether you are building to a bin or from a bin. Especially when you build "to" a site and bin at the top, and have to break it down per line item within the form.

@HectorGarciaCPA

6 жыл бұрын

Send me a screenshot

Your videos have been very helpful! Thank you! I do have one question though: When you're adding items (which will later be put into an assembly), is it okay to leave the "Sales Price" field blank? I suspect so as they allow you to; however, I cannot find confirmation anywhere. This should not throw something off somewhere down the line since these items are never pieced out individually.... right?? I hope my question makes sense! :) Thank you again!!

@HectorGarciaCPA

5 жыл бұрын

sales price is not a required field.

Hi Hector, I hope you can help me. I am using SKU numbers for my Item numbers in QB. When I "build assemblies" from WIP to Finished Goods. The finished goods asset account on the balance sheet is debited and the WIP account on the balance sheet is credited. That's all good, but the inventory center (where my SKU # (QB Item Number) does not show that the quantity has been updated. On the Inventory Stock Status report, they are shown in the Assembly category. Do I need to do something else after I "build assembly" to get QB to update my quantity in the inventory center showing that I have more products available? Thanks so much! Brenda Wilson

Thank you for all your videos. I have a question on how to assign serial numbers for items at Wip or Finish Good process. I faild in many attempts to assign serial numbers when Build Assembies.

Hi Hector I my company , we have several by-products from the main product. We sell those at a lower value, but still their value is above the materiality threshold of the company. So I want to know how to treat those by-product in assembly or how we should take into account in assembly. Thanks

Hi your videos are very helpful and I learned a lot from them can you please advise "can we prepare build assembly report in quickbooks"

@HectorGarciaCPA

Жыл бұрын

No that report doesnt exisit

I know this is an old video and hopefully someone can answer this question. I have the same sort of setup and at the very end of the video 26:35 you make the build for the chandelier when I do that I have 2 entries in my QBs desktop file and support hasn't been able to answer why or how to fix it. I get a credit to WIP debit to Final and then another entry that credits Final and debits COGS and I am not doing any sort of sale, just building an assembly. Is this how it worked when you did this video, is that normal? Then, just to confuse it further, if I do then make an invoice and complete the sale for the nested build, there is a zero dollar entry between Final and COGS.

How can i track inventory parts separately from a PO that purchased the inventory assembly. Example we can either buy the inventory parts separately and put the assembly together or buy the assembly from the vendor then sell the assembly or just the parts to customers

Can you change an existing Product in inventory to an assembly product without messing any past information?

@HectorGarciaCPA

5 жыл бұрын

If you don’t want to mess with history; just create a new inventory assembly and disable the inv item.

Hi Hector, Am I able to delete 100 pending builds at a same time?

Hi Am using quickbooks pro 2016 .. I can't use build assembly option for manufacturing

Hectór cómo estás? Qué pasa si el inventory assembly lo produce un tercero y no lo hago yo? Es decir, el PO que yo envío son inventory assembly y los componentes de ese inventory assembly se lo doy yo al tercero que los procesa y hace un producto final ?

Hi, Hector, can you please tell me how to add labour and overhead charges in manufacturing???

@sophiestorontolife6566

Жыл бұрын

I want to know about it too😂

@sophiestorontolife6566

Жыл бұрын

Labour can be an item. Overhead can be an item .

Very informative. In Enterprise, I set up a use car dealership using assemblies to add all the cost to the finished product. The non-inventory items such as transport, detailing, mechanical service and body work. The costs of the non-inventory items can change daily depending on the vehicle. What frustrates me is if I enter all the components and build the assembly . Then I find that I have to add an item to the original build. When I delete the assembly build and go to the assembly item all the cost have changed from the original costs entered due to the daily changing costs of the non inventory items being billed and paid. Can you tell me what I am doing wrong.

@HectorGarciaCPA

6 жыл бұрын

Claudia Cox don’t use Assemblies for used cars... use a unique inventory part for each and adjust the value as you go.

@rexespiritu6153

6 жыл бұрын

Hi Claudia, the "Inventory Assembly" Item in the Inventory List pertains to products to be built/produced in a manufacturing type of business. Since you are engaged in a Used Car Dealership, therefore, the Standard Costing procedures in Cost Accounting shall apply. For costing purposes, you can do it first in Excel to arrive at the new cost of a certain car in bringing them into the good shape and/or perfect condition. All these used cars will be part of your Inventory at the Balance Sheet - FG USED CARS and will be entered either individually or by batch in the Item list as "INVENTORY PART".

@rexespiritu6153

6 жыл бұрын

Definitely, if you changed occassionally the cost of the non-inventory items that forms part also of the BOM of your finished goods, therefore, the cost of the Assembly Item will also be affected thru cost updating.

Thank you for the video. I could not find the inventory menu next to employees in order to build assemblies

@HectorGarciaCPA

4 жыл бұрын

Is the edition of QB that you have installed.

@sajithsuhaifdeen932

4 жыл бұрын

@@HectorGarciaCPA it is the Quickbook Enterprise Solutions E18.0

@HectorGarciaCPA

4 жыл бұрын

You must reinstall and select “manufacturing and wholesale” as the version.

@sajithsuhaifdeen932

4 жыл бұрын

@@HectorGarciaCPA Thank you very much

Hi, Hector. I think you missed out to discuss also the site list and the transfer of item here wherein the raw materials and/or sub-assemblies are not stored in the production department. And Pending Builds has to be avoided in the real world because it will give an additional cost/loss and will hamper the production output level of the Company. Since a certain Company has Production Plan for their confirmed orders, therefore, when setting up the Inventory Part, it must have the Reorder Point min/max number of items both in the Production Site and Warehouse Site to comply with the Production Department Production Plan by the Purchasing Department/Warehouse Department, thus, avoiding future overruns of cost and avoidance of losses.

@HectorGarciaCPA

6 жыл бұрын

Good points, is hard to cover it all in every video :)

@rexespiritu6153

6 жыл бұрын

Yes, I agree with you and aside from that, the sample that was presented in this video is a Chandelier Manufacturing that needs not much Inventory Warehousing Management. Mr. Hector, I visited the website for Enterprise Expert and I sent the request in joining. Kindly accept my request. Thank you so much, and best regards.

@HectorGarciaCPA

5 жыл бұрын

REX ESPIRITU you are right... none of that is covered.

Is there a way to charge/build overheads in the cost of the finished inventory item?

@HectorGarciaCPA

6 жыл бұрын

Shahood ul Hassan not really, because overhead comes from multiple accounts... it you can create an Service item that points to an expense account that can be added to the assembly, kind of like the same way you would with payroll

@phoolAlvi

5 жыл бұрын

@@HectorGarciaCPA what about labour cost??

Thank you for the information; it is very helpful. I am using Quickbooks Premier Plus Manufacturing and Wholesale Edition 2023. My "Cost" field shows the drop down menu, but it is not active. I cannot choose a cost like global preference, user defined , or BOM. Why would this menu not be active? I can enter a value manually, but we would like for the BOM to automatically fill this field. Do I need to change to a different Industry Edition?

@HectorGarciaCPA

Жыл бұрын

Do you have multiple currencies turned on?

@gwurd

Жыл бұрын

@@HectorGarciaCPA No, I am set up for one currency. I did try changing editions to retail, general business, and they all leave that drop down menu inactive. I can see the menu, but it will not let me toggle between the choices you show in the video.

Hello Sir, Is there a way that assemblies are auto build if invoice is created ? Thanks for your response.

@HectorGarciaCPA

3 жыл бұрын

No

Hi Hector, I make BOM based on Inventory on hand ( stock) but I faced with does not have enough component in assembly section what should I do . In fact there is enough Inventory part to make it and I do not want to purchase new Inventory.

Do Quickbooks online PLUS have the option of assembly/ manufacturing?

@HectorGarciaCPA

4 жыл бұрын

Ghulam Ali no, only QB Desktop

@4556031

4 жыл бұрын

@@HectorGarciaCPA in fact, our finished goods are Food/ meal, and we want to enter Recipes of dishes. Could you pls share some pricing details of QB desktop with 5 users.

Hey Hector, Is there a way we can import assembly items through excel ?

@HectorGarciaCPA

5 жыл бұрын

Acura Doors the assembly items yes.. but not the BOM’s... you need to use a 3rd party tool for that.

@viviannesegura4601

5 жыл бұрын

Do you know what 3rd party tool to make BOM's? Thanks@@HectorGarciaCPA

I built an assembly and noticed when I ran a report it showed that it was pending. when you look at the items that are pending it shows that there is zero and have already been taken out of inventory on a build. Then why is it showing pending?

@HectorGarciaCPA

6 жыл бұрын

Probably another transaction dated before affected the inventory

Sir, is this function available also at Desktop premier 2020 US Version.

@HectorGarciaCPA

4 жыл бұрын

Rajan Gurung yes

@rajangurung9284

4 жыл бұрын

@@HectorGarciaCPA I have found it. Thank you.

Thank you Hector. I will have a chat with my partner to see if we wanna purchase the Enterprise instead.

@HectorGarciaCPA

4 ай бұрын

Cool. If you buy through us, you get a 20% discount for life.

@freesoul4eva

4 ай бұрын

⁠Ok. And what about the QuickBooks online? How much would that cost with you? Can it be in Portuguese language as my manager doesn’t really understand English properly.

Hector, I have two employees (I'm production supervisor), they work in acct. Dpt. they doesn't speak English, is possible get QuickBooks literature in Spanish for them?

Hi Hector, I want to ask Does the Assembly & Disassembly process change the Inventory Stock Qty ? Sample : BOM Parent Product : Z Component : Product A = Qty 1 and Product B = Qty 2 ASSEMBLY In Inventory Stock I have Product A = Qty 1 , Product B = Qty 2 and then I did Assembly Product Z Whether in the stock inventory will be formed as follows: Product Z = 1 Product A = 0 Product B = 0 DISASSEMBLY In Inventory Stock I have Product Z = Qty 1 and then I did disassembly Product Z Whether in the stock inventory will be formed as follows: Product Z = 0 Product A = 1 Product B = 2 Please your advise, thanks a lot

@HectorGarciaCPA

4 жыл бұрын

Sorry, this is too long to answer in a KZread comment. If you want to hire a consultant from our firm, call 954-414-1524 9a-5p EST

Is there any way to outsource assembly service?, but material is our own, they just assemble it and return to us.

@HectorGarciaCPA

4 жыл бұрын

It would work the same way.. you just need to add the labor cost

Hi Hector. Can I use this quickbooks enterprise for assembled items and ready made items also? Can I put it on the cloud?

@HectorGarciaCPA

4 ай бұрын

Enterprise works with assemblies well. Yes there is an option to host QuickBooks Enterprise

Is there a way to un-assemble an assembled item? Thanks.

@HectorGarciaCPA

6 жыл бұрын

David Saquing no... you need to do an inventory adjustment

@DavidSaquing

6 жыл бұрын

Thanks

@rexespiritu6153

6 жыл бұрын

In reality or in the production process, why you need un-assemble the assembled items? Very costly! Build Assembly or Production Report (Daily) is just the support or recording process in the producing such a Finished Goods and or Sub-Assemblies. I think it is illogical to disassemble it. Therefore, it might be considered as Scrap Materials and needs to make an Adjustment and create an account in the Chart of Account to record these scrap materials.

@jorge-sw3wh

5 жыл бұрын

Hector....from what I understand the enterprise is the top of the line when it comes to assembly right? In qbooks online I don't think we have all that

How do i get cracked verison of QuickBooks Premier and QuickBooks Enterprise ?

@HectorGarciaCPA

3 жыл бұрын

No

Hello Hector, first I want to say I'm so glad to find your videos. We own a manufacturing company and I took over the bookkeeping after outsourcing it. You've cleared up a lot of questions. But, I do have one for you, hoping you can help. We have desktop Premier Plus Mfg. Wondering if I can use assemblies with sub items to have product varieties. Our BOM is large and the only item changing between 4 or so varieties is the color of the molded parts. Could I do one parent assembly and then have a sub item for each color? Would it have just the molded part in it or would I have to have all the BOM on that item too. Thinking it would be easier if an item changes to change in the parent instead of all 4 parts. Also, we have products that are sold to distributors and although they are the same part (sku), we'd like to track them differently than the ones that we sell direct. Since I don't want to "assemble" a dealer version, wondering how to handle that. Your help is greatly appreciated!

@HectorGarciaCPA

4 ай бұрын

There are too many moving parts on those questions. Maybe if we can look at your file, we can give you a better answer

@user-lt7pq1zx4u

4 ай бұрын

@@HectorGarciaCPA I totally get it. To make it simpler, I am trying to find a way to have a sub-item of an assembly that would pull from the inventory without having to do a build. How might I show you our file?

I have a cosmetic Manufacturing factory, We make shampoos and skin creams. We use QuickBooks which is ideal if you buy an item and sell it. And make a profit. But we build a shampoo....which has a bottle, cap, label, box and let's say 15 ingredients. Right now we use excel to keep track of everything and its a headache. I heard there are a Quickbooks specifically fir manufacturers. Is there such a think. Or is there just enterprice and premiere?

@HectorGarciaCPA

4 жыл бұрын

QuickBooks Desktop Premier and Enterprise do manufacturing. QuickBooks Online and Desktop Pro do not.

Q. How to make the multiple assembly? Please guide me!

@HectorGarciaCPA

4 жыл бұрын

One at the time

@mudassirnaeem3447

4 жыл бұрын

@@HectorGarciaCPA yes

Dear sir how to activate cost use global preferences

@HectorGarciaCPA

5 ай бұрын

In the preferences

Hector, Quickbooks online can be used in manafacturing company? I heard about that QBS online is no good for manufacturing company which has many of inventory, is that so? Our new company is a manufacturing company, I don't know how to make a dicision. Thank you so much! your videos are the best !

@HectorGarciaCPA

Жыл бұрын

Yeah QB enterprise Platinum is good for manufacturing

@sophiestorontolife6566

Жыл бұрын

@@HectorGarciaCPA thank you so much! But enterprise platinum is online or desktop?

How can I create a pick list for BOM

@HectorGarciaCPA

2 жыл бұрын

You cant

Hi Hector. I work in manufacturing company that is into water hose production. I use QuickBooks desktop 2014. I find it difficult to build assembly of the hose. Please can you help me on the bill of materials?

@HectorGarciaCPA

2 жыл бұрын

There are several videos that explain it

How to edit or cancel an old build assembly

@HectorGarciaCPA

3 ай бұрын

You need to delete it

I have a production output efficiency of 90%. When I do the build assembly it gives us the cost based on 100% production output efficiency, but in reality, there is some 10% scrap generation which is of no use. How to enter a production efficiency in the system so that my 100% cost spread on 90% of the production output.

@HectorGarciaCPA

3 жыл бұрын

All you do is increase the materials usage be 10% so the costs reflect the yield/scrap variance

Can you assign a class to a build? When your average cost is higher than your new build price it pulls the differences out of COGS it there any way that this will not happen?

@HectorGarciaCPA

4 жыл бұрын

You can’t. It will always avg. cost regardless

@alliewightman

4 жыл бұрын

@@HectorGarciaCPA (ps your videos rock) do you know of a way to assign a class to a build assembly? Or map it to an asset account on the balance sheet to be written off later? thanks

This would be helpful,but words are not visible,and I seriously need this information

Hi Hector, please it is possible to watch this same video in Spanish. Thank you

@HectorGarciaCPA

2 жыл бұрын

This one is not in Spanish

How to xreate an assembly in Desktop Pro

@HectorGarciaCPA

Ай бұрын

You cant.. need Premier

@jamesmares4206

Ай бұрын

@@HectorGarciaCPA thank you I was. Struggling to do the impossible

Please I am making a switch to Accountant Role in a manufacturing concern. I need to get it right from the beginning, I have no prior praxtival knowledge in the sector. The company is into Manufacturing of food ingredients and beverages

@HectorGarciaCPA

4 жыл бұрын

I have a whole training series about this topic. Is $500 Hectorgarcia.teachable.com

Hi, i need to contact you ?

Hello, Im new to Inventory Assemblies. I encountered an issue that i see you didn't cover.. I would love to speak to you actually if you have a chance.. Number is C: 347-256-3530 / Question? : After invoicing the build assembly: i need my warehouse team to see what exactly goes into making that built assembly.. why does my finished invoice not show all items in the finished good... ?? Thank you .. I speak spanish as well if your more comfortable.. Thank you

@HectorGarciaCPA

7 жыл бұрын

Cesar Florez i am not sure exactly what your question is.... however, with item groups it may get u want

All of my problemes are solved