Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
phatbob
Level 1

making 2 different items out of common assembly items

Hi

 

we use a "roll" or sheet of multiple materials, sold in bulk by length (m). This roll gets consumed by cutting it into 2m pieces. The pieces themselves are then used to make multiple items, depending on the exact final product. Thats all good, I have my roll inventory in m and then I have an assembly which uses up 2m of the roll to make a 'blank'. We have different types of rolls, so we have different types of blanks. For this example lets pretend I have a roll of BLUE and a roll of RED, so I have BLUE and RED blanks.

 

Here is the harder part. We sometimes need 50 blanks, which is fine. We sometimes need 50 cut blanks, where we cut a pattern out of the blank. That is also fine, I can create an assembly called "cut BLUE blank" from the BLUE blank. and then we have the leftover from the cut, the "negative BLUE"...

 

But this is the hard part: we use the leftover from the cut BLUE blank, which I will call the 'reverse cut BLUE blank' (think of it as a negative), and will combine it with the same original cut pattern, but on a RED blank. So to keep things simple, a BLUE + invBLUE = a BLUE blank. And if we cut the exact same pattern in RED, a RED + invRED = a RED blank. But we also can combine BLUE + invRED = BLUERED and the similar leftover pieces, a RED + invBLUE = a REDBLUE. And  qe use all 4 in our production. So BLUE, RED, BLUERED and REDBLUE. They all come from the roll, in 2m chunks. I am having a hard time trying to figure out how to make 2 items at the same time, from given inventory in m. Its made harder by fact we have 8 colour combinations and 8 cut patterns...

 

So for example, with 4m of RED, and 4m of blue, I can make 1 pc 2m BLUE blank, 1 pc 2m RED blank, 1pc BLUERED and 1 pc REDBLUE. But the BLUERED and the REDBLUE get made at the same time, and are seperate inventory items after combining, but I need to track the halves seperately as there are many colours and multiple patterns. (i.e. after cutting BLUE I can combine with YELLOW, ORANGE etc). So I want to track the resultant cut halves, which all stem from the original 2m pieces. So when we do a 'build', we need to actually have it build 2 items.

 

Is there a way to have a group of 2 items created at same time, from an assembly ? or better way to do this ? I cant define the blue blank as an assembly of a BLUE+invBLUE as there is more than 1 type of cut pattern, so there might be like 4 ways to cut the BLUE...

 

 

1 Comment 1
Rea_M
Moderator

making 2 different items out of common assembly items

Hello there, @phatbob and @Ingram548.

 

Yes, there's a way to make or group 2 different items out of common assembly items in QuickBooks Desktop (QBDT). I'll gladly share details about this and route you to the best support who can provide expert advice in managing your inventories.

 

You can have a group of 2 items created at the same time from an assembly by using item codes. To do this, you'll have to turn on Advanced Inventory. Then, utilize barcodes and serial numbers to make data entry faster and easier in QBDT.

 

On the other hand, I would encourage you to consult your accountant for any other inventory tracking options. They can also give expert advice and direction tailored to your business needs.

 

Also, you may want to check out one of our Help pages as your reference to guide you in managing your inventory and products and services in QBDT: Inventory help for QuickBooks Desktop.

 

Let me know if you have other inventory concerns or questions about building assemblies in QBDT. I'm always ready to help. Take care, and I wish you continued success, @phatbob, and @Ingram548.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us