Welcome, Guest. Please Login.
05/11/25 at 21:37:20
News:
Home Help Search Login


Pages: 1
Send Topic Print
Raw Material Inventory (Read 454 times)
LJ
Member
**


I love YaBB 1G -
SP1!

Posts: 79
Raw Material Inventory
08/29/05 at 15:20:25
 
We have metal that is ordered by a vendor in bulk for a part that he machines. We purchase the material ahead of time and he stores it until it is time to make the parts. I am not quite sure how to set up the BOM so that the raw material shows in inventory before it is actually machined. Any ideas?
 
Thanks.
Back to top
 
 
  IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Raw Material Inventory
Reply #1 - 08/29/05 at 18:55:16
 
1. Create a Part Number for the metal.
2. Create a BOM for the Parent Part listing the Raw Material and the Qty consumed per part.
3. Create a Routing with the vendor's Labor added as an Outside Process.
4. Issue a Work Order for the required Qty of the Parent Part.
5. Issue a PO to the vendor for the required processing.
6. Receive PO and Enter Finished Production and Roll-up when the goods are received.
7. When you do a Physical Inventory, have the vendor count the material on-hand for you.  
Back to top
 
« Last Edit: 08/30/05 at 05:58:06 by Tim Keating »  

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Raw Material Inventory
Reply #2 - 08/30/05 at 05:30:55
 
or maybe...
1. Create a Part Number for the metal.  
2. Create a BOM for the machined Part as a make-from listing the Raw Material and the Qty consumed per part.  
3. no Routing  
4. no Work Order  
5. Issue a PO to the vendor for the machined part (which automatically includes negative qty for material).  
6. Receive PO and automatically consume material when the goods are received.  
7. When you do a Physical Inventory, have the vendor count the material on-hand for you.  
 
We do this for castings we have machined.
Back to top
 
 
Email   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
Re: Raw Material Inventory
Reply #3 - 08/30/05 at 07:14:23
 
We have been following the process Mike listed since 2002.  HOWEVER, there is a bug in the system and if you change the price via PO-C it will throw your RNI out of balance (RNI report vs. Balance Sheet) along with wacking out the Last Cost for the part.  This will really freak out those who review your COGS vs Income Rec'd GL lines.
 
I have recently changed my default not to let PO-C update prices.  HOPEFULLY, with this in place and Lynn's promised bug fix the problem will go away.
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Pages: 1
Send Topic Print