Inventory parts, inventory and ordering

Bought as Pack and Resold As Pieces

Bought as Pack and Resold As Pieces

Postby madmoneymike5 » Fri Apr 22, 2016 6:22 am

Please forgive me if this has been addressed previously...

I'm trying to handle a situation where I buy items that come in a pack of 10 or 12, but then are sold as individual pieces. For example, oil filters and light bulbs are often bought as a wholesale package, and yet, I resell them as individual pieces.

The problem lies in the inventory count vs amount to order. I track my inventory count on a per-piece basis; this way, I can know when I'm running low and need to reorder. Let's say I want to keep at least one 1057 light bulb onhand. With my stocking level set to 10 and my reorder point set to 1, when I go to reorder, the purchase order sets an amount to order equal to 9. If I push the order through, the net effect will be an order to my supplier for 9 boxes of 1057 light bulbs, all of which contain 10 bulbs each. I will end up receiving 90 light bulbs. This also creates a problem with tracking average costs, sale prices, etc.

I have not found a way to address this within the software. How are you guys handling this? Is there something I'm missing?
(Using Version 7.0.11 as of June 2016)
madmoneymike5
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 90
Joined: Mon Feb 09, 2015 6:17 pm

Re: Bought as Pack and Resold As Pieces

Postby madmoneymike5 » Fri Apr 22, 2016 6:29 am

Please ignore the above post. I finally found a similar question that has a useable, if not ideal, answer. (viewtopic.php?f=208&t=11089&p=85911&hilit=pack#p85911)

Is there a feature enhancement already listed to better handle this situation?
(Using Version 7.0.11 as of June 2016)
madmoneymike5
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 90
Joined: Mon Feb 09, 2015 6:17 pm

Re: Bought as Pack and Resold As Pieces

Postby ricmorin » Fri Apr 22, 2016 6:46 am

Yes.

part.PNG
 
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5159
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Bought as Pack and Resold As Pieces

Postby madmoneymike5 » Fri Apr 22, 2016 6:53 am

Good. :)
(Using Version 7.0.11 as of June 2016)
madmoneymike5
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 90
Joined: Mon Feb 09, 2015 6:17 pm

Return to Inventory / Purchase Orders

Who is online

Users browsing this forum: No registered users and 2 guests