ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> material costing
http://www.istechforum.com/YaBB.pl?num=1252966693

Message started by Prier Products on 09/14/09 at 15:18:12

Title: material costing
Post by Prier Products on 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.

Title: Re: material costing
Post by dameng on 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?