Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Costing
02-07-2014, 06:00 AM,
#1
Costing
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


Attached Files
.pdf   gl_list.pdf (Size: 27.94 KB / Downloads: 8)
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)