+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Costing (/showthread.php?tid=2089)
Costing - agaluski - 02-07-2014
Hello, I have a question regarding the Average Cost Calculation I am hoping for some clarity on.
Setup an item with no cost. Received 100 on a P/O with a price of $1. Invoiced the P/O. Cost went to $1 as expected. Wrote down 5 units. Issued another P/O for 100 at $2. Received P/O. Entered Invoice. Expected new cost of around $1.50. Cost showed $2.03
Setup an item with cost of $1. Received 100 on a P/O with a price of $1. Invoiced the P/O. Cost went to $1 as expected. Wrote down 5 units. Issued another P/O for 100 at $2. Received P/O. Entered Invoice. Expected new cost of around $1.50. Cost showed $1.51.
So is this a bug? Should the rule be to set the Cost to first P/O price at least? Also attached G/L Listing
Here are the transactions:
Not as Expected:
Type Number Date Customer Branch Quantity Reference Price Discount New Qty
Purchase Order Delivery 11 02/06/2014 100 10001 (Resin Suppliers of Arizona) - 10 2.00 0.00% 195
Stock Adjustment 2 02/06/2014 -5 0.00 0.00% 95
Purchase Order Delivery 10 02/06/2014 100 10001 (Resin Suppliers of Arizona) - 9 1.00 0.00% 100
As Expected:
Type Number Date Customer Branch Quantity Reference Price Discount New Qty
Purchase Order Delivery 13 02/06/2014 100 10001 (Resin Suppliers of Arizona) - 12 2.00 0.00% 195
Stock Adjustment 3 02/06/2014 -5 0.00 0.00% 95
Purchase Order Delivery 12 02/06/2014 100 10001 (Resin Suppliers of Arizona) - 11 1.00 0.00% 100