Welcome, Guest. Please Login.
05/13/25 at 16:23:23
News:
Home Help Search Login


Pages: 1
Send Topic Print
real time count of inventory, plant supplies (Read 870 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
real time count of inventory, plant supplies
06/19/13 at 09:13:04
 
I want to be able to keep a real time account of general supplies.   How am  I supposed to increase and decrease inventory as we buy it and  use it?
 
Example:  Safety glasses  
 
         IN-A  shows
On Hand  ...................0
On PO    ....................0
Work in Process ......336    (which is the qty I have ordered over the last few years)
 
Why is the Qty of  336 on WIP and not reflected in On Hand?  
I dont't  understand why safety glasses are going to WIP.  How do I make them go directly to  On Hand?  Am I doing something wrong when I recieve them in  PO-C?
 
Also, how do I tell DBA that I gave out 12 pair of safety glasses today, so that DBA will reduce the qty on hand?   I suppose we need to manually take inventory at he end of the month and make the manual adjustment in IN-K,  unless we go to bar code.
 
 
 
Thanks,
Laura  
 
 
tag : reduce inventory  relieve inventory, accurate count items, reorder re-order
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: real time count of inventory, plant supplies
Reply #1 - 06/19/13 at 09:32:55
 
Laura,  
 
There is chance that the item in question was purchase to a Work Order.
Open the PO, Open the line in question, and check if the work order field has a number.
 
Unreceive the line, add a new one and receive it there.
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: real time count of inventory, plant supplies
Reply #2 - 06/19/13 at 09:34:05
 
Quote from Laura Oliver on 06/19/13 at 09:30:25:
Inventory Quantity reflected in  WIP, but should be reflected in On Hand

We use a generic WO number  for plant supplies on a purchase order  ..... could that be why the qty goes into WIP and not On Hand?  


 
Yes that is the reason.
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: real time count of inventory, plant supplies
Reply #3 - 06/19/13 at 09:36:04
 
So the only time we are suppose to use a work order on a Purchase Order is when the item purchased is going to be part of the job?
 
We have been putting this generic WO on all our POs since 1997 (LOL)    I guess its time to stop.
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: real time count of inventory, plant supplies
Reply #4 - 06/19/13 at 09:37:46
 
Thanks Kelloggs!
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print