"Avg Cost" nails me again

[Lee]

I checked yesterday's sales report to find a total income of $1400 and a cost of $6,853 for a Gross Profit of -$5497 (rounded figures).

Investigation found that the software decided - for whatever reason - to set the average cost of gasoline to $80.19.  So, that screws up the monthly report AND the historic graphs I had come to use.

This is not the first time this has happened.

[Lee]

Description                               Qty   Cost    Retail   Avg Cost
Rockstar                                 57   1.22      1.83   287.72
Coors Light - 12 Pack                  6   9.25     13.41   229.55
GPC NF SOFT KG                        34   4.11      5.55   196.49
NUTRAGEOUS BAR SINGLES        11   0.61      1.19   145.13
Gasoline                           715.97   3.89      4.45   80.19
Coors - 12 Pack Cans                 10   9.25    13.41   55.91
Keystone - 12 Pack                   3   7.1      10.3   40.06
Budweiser - 12 Pack Cans         11   8.6    12.47   35.69
Lemon                                   5   0.43      0.62   27.09
HERS ALMOND KING 22100          18   1.07      1.79   5.55

Yes, that's an average cost of $27 for a lemon.

[ronaldrwl]

The Avg Cost is updated when using any of these functions: Purchase Order, Multi-Store, Product Import and Inventory Adjust.  Which of these do you use to update your products?  Are you using version 10?

[Lee]

Sometimes, when adding inventory, I use the Inventory Adjust.  Other times, when time permits, I go to the product record directly to adjust the quantity and to check for cost changes.  The ONLY method I have ever used to change the quantity and cost of gasoline is by altering the record itself.

[ronaldrwl]

Sometimes, when adding inventory, I use the Inventory Adjust.

This function will adjust the Avg Cost, performing a 'rolling' average.  I've tested it a 100 times and find no problem.

The ONLY method I have ever used to change the quantity and cost of gasoline is by altering the record itself.

Doing this will never change the Avg Cost except when the Avg Cost is zero.  It then will be set to the Cost.

If you think of anything else or any other clues I would like to know.  I've tried to reproduce any problem but can't find it.

[Ches]

I'm having this problem too..
So in summary you are saying when I do a inventory adjust - to first make the price changes in the product edit - THEN add the inventory (Add stock from list button) which will do the average??

The problem is the logic of that without knowing the rules. I would naturally add the product then adjust the pricing..  Too bad the inventory adjust doesn't have a price update box along with the inventory. But if this works I'm OK with it. Just a little confusing if I didn't find this thread.

[Lee]

What I've been doing is to check the average price in "product edit" and, if necessary, using the "tool/set avg cost to cost" function.

[SteveH]

I believe we encountered this problem when we entered the cost incorrectly once. For example we'd accidentally enter the case price vs the individual item price. You could reset the cost but the damage was already done and there was no way to undo the data already entered. I believe that you had to actually sell some items at the incorrect price for this to happen though.

[ronaldrwl]

You can reset the Avg Cost using the Customer Control / Tools menu.
 - Purchase Order functions changes Avg Cost.
 - Adjust Stock / Add Stock changes Avg Cost.

[Ches]

You can reset the Avg Cost using the Customer Control / Tools menu.
 - Purchase Order functions changes Avg Cost.
 - Adjust Stock / Add Stock changes Avg Cost.

I did the Adjust stock option in the first place but there is no price box - you have to first change the price in the edit area.
On purchase order I need to read up on that because as I was trying it I was afraid it would change my inventory again. Does the PO update inventory or is it just a form?

[ronaldrwl]

The P.O. Receive function updates the Avg Cost.

[Lee]

I just used "product control" to receive gasoline and update the cost.  Ten days ago, when I performed this function all was fine.  Today I found the average cost to be $1.20.  I can't remember when I could get gas for that price....

I have yet to identify the "trigger" for these anomalies.

[ronaldrwl]

I would like to know also.  Which of these do you ever use:
 - Product Import / Export
 - Product Adjuist
 - Purchase Order functions
 - Direct price adjust in Product Edit
 - Anything else related to change product information.

[Lee]

For this one product, gas, the only method by which the number of gallons of fuel are added is by direct edit of the quantity field in the product edit window.  Cost and prices are also modified in the product edit window.  The only other function I use that affects this product is the sales function.

I do have an in-house charge account for the fuel I use and the price for gas is "free" in this account; but that has nothing to do with the cost.

[ronaldrwl]

Changing the price manually will not change the Avg Cost.  Do you ever use on any products any of these:
 - Product Import / Export
 - Product Adjuist
 - Purchase Order functions