Peachtree and Sage 50 Forums      

Go Back   Peachtree and Sage 50 Forums > Peachtree and Sage 50 software > Peachtree / Sage 50 Accounting forum

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2003, 07:44 PM
chay chay is offline
Junior Member
 
Join Date: Sep 2003
Posts: 5
Assembly w/Insufficient Inventory Items

Hi all-

I'm using Peachtree Complete 2003 along with PeachBOM from Invertech, and the one inventory problem that I really have is that PeachTree will not allow me to perform an assembly when I don't have enough of a component item to do so. Why won't PeachTree just let the component item go negative just as it would if I were to sell the component on an invoice? If I could eliminate this one thorn in my side, then I'd be a very happy camper.

Does anybody know if there is there a behind-the-scenes setting to enable this functionality, perhaps a 3rd party utility, or am I just stuck with it the way it is?

TIA-

Chay Wesley
Reply With Quote
  #2  
Old 09-28-2003, 06:54 AM
TheWolf TheWolf is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 2,535
Selling into the negatives can often have an adverse effect on the COGS so I recommend you do not sell into the negatives. I actually wish Peachtree would disallow even selling into the negatives as it causes syscost adjustments and often the inventory reports will be incorrect when trying to calculate cost.
__________________
Tom Sechler
www.software-link.com
Sage Certified Consultant
Reply With Quote
  #3  
Old 09-28-2003, 08:09 AM
SK Wong SK Wong is offline
Member
 
Join Date: Sep 2003
Location: Hong Kong
Posts: 66
Dear Chay

I do agree with Tom's comment. It is logical to stop you from selling the negative stock due to the calculation of cost of sales.
You have to follow the proper way to carry out your task.

Good Luck to you
Bye
SK Wong
Sept 28 2003

Last edited by SK Wong; 10-12-2003 at 09:09 AM.
Reply With Quote
  #4  
Old 09-28-2003, 08:45 AM
chay chay is offline
Junior Member
 
Join Date: Sep 2003
Posts: 5
Our numbers are typically only negative for a time period spanning from a few hours to not more than a few days.

In order to overcome PeachTree's limited inventory abilities, we have setup 3 phases of inventory numbers that our products transition through on their way from raw components to finished goods. First, they start as Raw Components, then when we commence to assemble an item (physically), we build an assembly in PeachTree that represents a Work In Progress. This correctly reduces all of the individual component items that make up the finished good. As our assembly process varies typically from 1 day to 2 weeks on our items, this allows us to view actual inventory counts, including those items that are currently allocated to builds. After the assembly is complete, we build an assembly in PeachTree for the Finished Goods part number, which consists of 1 of the WIP, and the labor.

A lot of our assemblies are based on subassemblies. For example, some of our products have enclosures. Those enclosures have to be milled a certain way to fit the product in question. Resultantly, we have the enclosure setup as a subassembly requiring 1 enclosure, and some unit of labor to mill it. If, when we start to physically build a widget, even if we don't have enough of that widget's enclosures in stock, I will not hold up production of the widget waiting on the enclosure. Instead, I will start production of the two items concurrently, knowing that the enclosures will be finished prior to the assembly completion of the widget. As soon as the enclosures are milled, then I will post the assembly for that particular part into PeachTree. Would this not undo the fact that it went negative earlier in the day?

As discussed earlier, most of our widgets require up to two weeks in production, and contain anywhere from qty 100 to 3000 component parts per build. I want to have the work in progress assembly posted as soon as possible such that our parts re-ordering process is not delayed unneccesarily. This is especially important to us as a significant amount of our parts have long lead times.

Please understand that I am not the company controller...I am the operations manager...I understand a lot more about production management than accounting. From the perpective of a production manager, it is important to me to be able to view my current inventory status in fairly real-time. I also still do not comprehended the difference in an item going negative because of sales, or as a result of an assembly.

TIA
Reply With Quote
  #5  
Old 09-28-2003, 08:55 AM
TheWolf TheWolf is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 2,535
With this additional information I might recommend you look for a program that is geared more towards manufacturing. While you are handling it correctly by creating assemblies to represent WIP areas, the limitation of assemblies in Peachtree will be a pitfall for you. I can think of ways to supplement your process using Excel to track the items that cannot be created because the qty is 0 but depending on the amount of extra time for data entry, you may want to look for another program.
__________________
Tom Sechler
www.software-link.com
Sage Certified Consultant
Reply With Quote
  #6  
Old 09-28-2003, 09:25 AM
chikamic chikamic is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 1,183
Just for informational purposes, I suggest that you contact David Ringstrom (dringstrom on this forum) at www.acctadv.com

David may be able to custom design an Excel DDE solution, I have seen him work miracles with Peachtree and Excel !!

Good Luck !

Michelle
Reply With Quote
  #7  
Old 09-28-2003, 10:06 AM
RetroCanino RetroCanino is offline
Senior Member
 
Join Date: Apr 2003
Location: USA
Posts: 184
I was told that Peachtree is working on some enhancements that might be useful to us.

Peachtree a few months ago released some Vertical kits, that were the step in the right direction. http://www.peachtree.com/mfgindustry/ is for Manufacturing.

My understanding from talking with the Product Specialists in Peachtrees tech support that R&D are working on making some really cool enhancements for Manufacutring and Distribution companies.

They told me to keep an eye on www.peachtree.com and in our mail boxes for information, because they think we should start seeing more information coming soon. They couldnt or should I say wouldnt give me a release date, but they said it would be soon.

So, if anyone has more info, please share.

Thanks
RC
Reply With Quote
  #8  
Old 09-28-2003, 10:29 AM
TheWolf TheWolf is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 2,535
Yes they are coming out with verticles for Distribution, Manufacturing and Non-Profit but the limitation of needing the items to be above 0 to create an assembly will still be there.

The verticles released before were not true verticles. They have excellent guides on how to use the existing program to get alot done in the various areas and a copy of Crystal Reports with some more canned reports.
__________________
Tom Sechler
www.software-link.com
Sage Certified Consultant
Reply With Quote
  #9  
Old 10-08-2003, 01:49 PM
RetroCanino RetroCanino is offline
Senior Member
 
Join Date: Apr 2003
Location: USA
Posts: 184
Darren,

I have seen the beta version of Peachtrees upcoming releases, today actually. They look really good. I think you will be surprised at the new features.

RC
Reply With Quote
  #10  
Old 10-08-2003, 06:42 PM
TheWolf TheWolf is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 2,535
I agree RC. I still need to play with this more but so far I like what I see and Peachtree now has a solution for mnaufacturers.
__________________
Tom Sechler
www.software-link.com
Sage Certified Consultant
Reply With Quote
  #11  
Old 10-08-2003, 07:02 PM
chay chay is offline
Junior Member
 
Join Date: Sep 2003
Posts: 5
First, thanks to all for the discussion.

TheWolf, RetroCanio- Based on what you've seen, would you say that the functionality from the upcoming product from PeachTree overlaps with the MRA system offered by Invertech? I've been leaning toward purchasing MRA from Invertech to replace an overworked MRP system that I slapped together in Access. If, however, the new features from PeachTree would overlap with MRA, then I would be inclined to hold out to see what PeachTree offers.

Are you guys under an NDA, or can you discuss some of the new features that your seeing?

Thanks,

Chay
Reply With Quote
  #12  
Old 10-08-2003, 08:23 PM
RetroCanino RetroCanino is offline
Senior Member
 
Join Date: Apr 2003
Location: USA
Posts: 184
I am under an NDA.

I have 4 clients that I am going to be recommending the new version as soon as it is available. They all have compliacted inv tracking issues. They are very service oriented in addition to them manufacuting from raw materials and having to track the distribution.

I would recommend that you wait, If you can wait a little while until Best releases the new version of Peachtree.

I am interested in what Wolf says to. :-)
Reply With Quote
  #13  
Old 10-09-2003, 05:28 AM
TheWolf TheWolf is offline
Registered User
 
Join Date: May 2002
Location: Atlanta
Posts: 2,535
Quote:
Originally posted by chay
First, thanks to all for the discussion.

TheWolf, RetroCanio- Based on what you've seen, would you say that the functionality from the upcoming product from PeachTree overlaps with the MRA system offered by Invertech? I've been leaning toward purchasing MRA from Invertech to replace an overworked MRP system that I slapped together in Access. If, however, the new features from PeachTree would overlap with MRA, then I would be inclined to hold out to see what PeachTree offers.

Are you guys under an NDA, or can you discuss some of the new features that your seeing?

Thanks,

Chay
I am unfamiliar with the MRA system so I cannot offer a comparison. While I am not under an NDA, I do have an obligation as a Certified Consultant to not say anything until the product is released. Hopefully the hype is matched by the functionality of the program.
__________________
Tom Sechler
www.software-link.com
Sage Certified Consultant
Reply With Quote
  #14  
Old 10-09-2003, 10:44 AM
smueller smueller is offline
Junior Member
 
Join Date: Oct 2003
Location: Dallas, TX
Posts: 2
TheWolf / RetroCanino,

I am a new user of Peachtree and a small manufacturer as well and am also curious about this new functionality. I know you cannot disclose the details of the new release, but can you tell us if it does actual materials requirements planning? Or is it more along the lines of additional reports included in the "manufacturing" add-on. Thank you in advance.

Steve Mueller
Reply With Quote
  #15  
Old 10-12-2003, 07:41 AM
RetroCanino RetroCanino is offline
Senior Member
 
Join Date: Apr 2003
Location: USA
Posts: 184
Quote:
Originally posted by smueller
TheWolf / RetroCanino,

I am a new user of Peachtree and a small manufacturer as well and am also curious about this new functionality. I know you cannot disclose the details of the new release, but can you tell us if it does actual materials requirements planning? Or is it more along the lines of additional reports included in the "manufacturing" add-on. Thank you in advance.

Steve Mueller
Yes, I would say there IS actual materials requirements. It is not just reports changes! There are actual new features and enhancements too, that includes new windows and functionality that is intergarted through out the program exsiting task screens.

Last edited by RetroCanino; 10-12-2003 at 06:02 PM.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 03:08 AM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
all contents copyright (c) by AccountingUsers Inc.