Home Page link  

Splitting inventory assemblies into components

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Splitting inventory assemblies into components RobertM 07-31-2007
Posted by RobertM on July 31, 2007, 10:21 am
Please log in for more thread options
I have a hundred sets of guitar strings that aren't selling
well. Musicians are religious about buying their brand of
strings but no one gives a hoot what brand it is if they buy
a single replacement string. So, I'm splitting up the sets
into individual strings. Is there a way in QB 2007 Premier
to remove a single set from inventory and convert it to six
individual items? Sort of like a reverse build.

Bob

Posted by Laura on July 31, 2007, 10:45 am
Please log in for more thread options
>I have a hundred sets of guitar strings that aren't selling well. Musicians
>are religious about buying their brand of strings but no one gives a hoot
>what brand it is if they buy a single replacement string. So, I'm splitting
>up the sets into individual strings. Is there a way in QB 2007 Premier to
>remove a single set from inventory and convert it to six individual items?
>Sort of like a reverse build.

You need to use Inventory adjustments to accomplish this. Setup a new item
for the single strings. Reduce the original 6-string item by 1 and increase
the newly created one by 6. Click on the Value adjustment box so that you
can adjust the $ amount in both adjustments. I would think that you would
want a net zero $ impact to inventory when you do these adjustments.


Posted by RobertM on July 31, 2007, 3:35 pm
Please log in for more thread options
Laura wrote:
>> I have a hundred sets of guitar strings that aren't selling well.
>> Musicians are religious about buying their brand of strings but no one
>> gives a hoot what brand it is if they buy a single replacement string.
>> So, I'm splitting up the sets into individual strings. Is there a way
>> in QB 2007 Premier to remove a single set from inventory and convert
>> it to six individual items? Sort of like a reverse build.
>
> You need to use Inventory adjustments to accomplish this. Setup a new
> item for the single strings. Reduce the original 6-string item by 1 and
> increase the newly created one by 6. Click on the Value adjustment box
> so that you can adjust the $ amount in both adjustments. I would think
> that you would want a net zero $ impact to inventory when you do these
> adjustments.

        The problem is that it requires an adjustment account.
Since no value is lost nor gained, what is there to adjust?
Do I create a bogus temporary account and then delete it
afterward?

        Bob

Posted by Laura on July 31, 2007, 3:46 pm
Please log in for more thread options

> Laura wrote:
>>> I have a hundred sets of guitar strings that aren't selling well.
>>> Musicians are religious about buying their brand of strings but no one
>>> gives a hoot what brand it is if they buy a single replacement string.
>>> So, I'm splitting up the sets into individual strings. Is there a way in
>>> QB 2007 Premier to remove a single set from inventory and convert it to
>>> six individual items? Sort of like a reverse build.
>>
>> You need to use Inventory adjustments to accomplish this. Setup a new
>> item for the single strings. Reduce the original 6-string item by 1 and
>> increase the newly created one by 6. Click on the Value adjustment box so
>> that you can adjust the $ amount in both adjustments. I would think that
>> you would want a net zero $ impact to inventory when you do these
>> adjustments.
>
> The problem is that it requires an adjustment account. Since no value is
> lost nor gained, what is there to adjust? Do I create a bogus temporary
> account and then delete it afterward?

No, don't create a bogus account. Since there will be multiple transactions
posted to the account, you won't be able to delete it. Hide, yes. Delete,
no.

Most inventory adjustments are posted to the Cost Of Goods sold (COGS)
account so I would just use that account in this case. Keeps it consistant
with other inventory adjustments you might do.


Posted by RobertM on July 31, 2007, 3:55 pm
Please log in for more thread options
Laura wrote:
>
>> Laura wrote:
>>>> I have a hundred sets of guitar strings that aren't selling well.
>>>> Musicians are religious about buying their brand of strings but no
>>>> one gives a hoot what brand it is if they buy a single replacement
>>>> string. So, I'm splitting up the sets into individual strings. Is
>>>> there a way in QB 2007 Premier to remove a single set from inventory
>>>> and convert it to six individual items? Sort of like a reverse build.
>>>
>>> You need to use Inventory adjustments to accomplish this. Setup a new
>>> item for the single strings. Reduce the original 6-string item by 1
>>> and increase the newly created one by 6. Click on the Value
>>> adjustment box so that you can adjust the $ amount in both
>>> adjustments. I would think that you would want a net zero $ impact to
>>> inventory when you do these adjustments.
>>
>> The problem is that it requires an adjustment account. Since no value
>> is lost nor gained, what is there to adjust? Do I create a bogus
>> temporary account and then delete it afterward?
>
> No, don't create a bogus account. Since there will be multiple
> transactions posted to the account, you won't be able to delete it.
> Hide, yes. Delete, no.
>
> Most inventory adjustments are posted to the Cost Of Goods sold (COGS)
> account so I would just use that account in this case. Keeps it
> consistant with other inventory adjustments you might do.

        OK, I've never done an inventory adjustment in QB because
the help files don't clearly indicate how to do it. Time for
some trial and error education.

        Bob

Similar ThreadsPosted
Another question - how to change Inventory Part to Non-Inventory Part August 31, 2008, 10:51 am
Inventory or non-Inventory? December 9, 2006, 12:25 pm
inventory July 26, 2007, 6:22 pm
Should I maintain inventory in QB? July 4, 2006, 10:23 pm
Inventory Puzzlement December 28, 2006, 7:53 pm
Inventory tracking May 12, 2008, 7:28 am
Customer Inventory Management September 22, 2006, 11:54 am
Reimbursement for Inventory Items October 26, 2006, 10:04 am
QB 2006 Premier Inventory February 1, 2007, 4:14 am
Balance Sheet Inventory Asset July 13, 2006, 10:39 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap