Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inventory item setup as a stock item, not assembly

Status
Not open for further replies.
mcarey101

mcarey101

IS-IT--Management
Aug 8, 2002
4
US
We have 4 items that we sell. They are assemblies in Peachtree as they are made up from several compenents from different vendors. The 4th item was setup as a stock item instead of an assembly by a former employee. This was done a year ago and we have sold several thousand of these.

The other 3 items are assemblies and are being processed normally- create a PO, do a Purchases/Receive Inventory for the items, then build the assembly.

For the bad stock item, to make our inventory numbers for this unit in Peachtree match the actual numbers, I created inventory adjustments to "build" these items. But that created very large credits to COGS, which throws our financial statements off.

HELP! How can I correct this situation ?


__________________
 
Sort by date Sort by votes
You need to set up a new inventory item using the item class of "assembly" and start using it immediately. Change the item description of the bad item to "DO NOT USE-XXXXXX" where XXXXXX is the old description and mark the item as "inactive".

You need to make a journal entry to correct your inventory and COGS accounts. You may need to do this as a prior period adjustment so you don't affect the current financial stmts: Maintain, Chart of Accounts. Select beginning balances button and select the prior period you want to post the amounts to.
 
Upvote 0 Downvote
If you're using Peachtree 2000, I just discovered a solution to the same problem. I exported the stock ID & type in a text file, imported it into Microsoft Access, changed the type from "U" to "A", exported it as a text file, and then imported it into Peachtree. It is then set up as an assembly item.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to make the GetPeach() functions available in Crystal?
Replies
0
Views
277
dgillz
dgillz
mujji
  • Locked
  • Question
I've saw a thread where some one me
Replies
0
Views
327
mujji
mujji
andymann
  • Locked
  • Question
Easiest way to transfer a 'company' to another install.
Replies
1
Views
422
SBTBILL
SBTBILL
bobpv
  • Locked
  • Question
How do you link a credit memo to the sale invoice?
Replies
1
Views
351
bobpv
bobpv
gjanes
  • Locked
  • Question
Removing a Company
Replies
1
Views
394
blueboyz
blueboyz

Part and Inventory Search

Sponsor

Back
Top