Welcome, Guest. Please Login.
11/02/24 at 09:37:01
News:
Home Help Search Login


Pages: 1
Send Topic Print
material costing (Read 355 times)
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
material costing
09/14/09 at 15:18:12
 
We had a problem with material cost on one part when it's evo count went negative do to a PO receit that was not entered before we started shipping the product.  The most we had ever paid for the item was $28.01  We did have 3 negative sales at $72.72, so I would think the highest our cost should have gotten was $72.72.  When we went negative the 1st 10 went out at a cost of $28.67, the next 3@$120.61, 3@$577.19, 2@$1298.77, 4@1298.77, 14@1,298.77, 39@1298.77, 29@1298.77 AND 34@1,298.77.    
The total material cost error was $157,831.82.  What caused that items cost to keep getting larger?  Other than doing our receiving before we ship, how could that have been avoided?  We tried to correct the problem by running UT-K&H, but wound up just deleting all of the inventory and putting it back in at the correct cost and making a journal entry to fix material cost and sales.
Back to top
 
 
  IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: material costing
Reply #1 - 09/18/09 at 11:09:20
 
you might want to look at your settings in IN-B see if you have a conversion multiplier and if the Stock UM is different than the Purchase UM, also take a look at the PO's that this item was purchased on to see if a PUM and conversion multiplier were used.
 
also, what version of EVO or DBA are you on?
definitely the cost shoud not be getting exponentially larger. you finally did correct the costing issue by adjusting inventory out and back in at the correct cost.
 
was it really the cost, i.e. last cost, average cost of the item that was increasing? or was it the Book Value?
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print