Hello,
Can I get some help with above subject.
I have tried to adjust the negative balance of the item but with no success. Everytime I adjust the total value to match the stock on hand, it works. Then when there is a sale of the item, the average cost is changed again increasing the cost negatively.
I am not sure how to fix the average cost to be normal again
Can anyone help please?
Thanks
SH
Hi PSE1
Apologies for the delay in response.
Average cost in AccountRight is calculated automatically using the formula: Average Cost=Total Value of the item÷Total Quantity of items.
If you wish to make any changes to it, you will have to make an inventory adjustment and if the results are not as expected, please check if the following changes were made to the item as the average cost will be recalculated if you make any of these changes to a recorded bill:
enter a memo
update the ship to address on the bill screen
change the date
change the purchase number
enter a supplier invoice number
If the total value or stock on hand is displaying incorrectly as negative, we can run a script to fix the negative values but average cost can only be fixed by doing the inventory adjustment journals as explained above.
