Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowHi
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...
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here