Two Questions
Hi, If anybody could help with these questions it would be much appreciated.
In the Stock report section their is a Default cost and cost column, whats the difference? In 95% of my stock the figure in both columns is the same but in the others the two figures are different and sometimes the cost figure is zero??
Is their a way in reports of seeing my stock value on a certain date, say 30th dec 2012?
All help would be gratefully appreciated.
cheers
Simon.
Support Staff 2 Posted by CO Michele on 01 Feb, 2013 01:46 PM
Simon,
The default cost on the reports is pulled directly from the default cost field on the product. The cost column is calculated by the actual cost paid on purchase orders and is also used to calculate the inventory value.
Yes, with the latest build 3.5.7 the Stock Report now can be run for a date range.
To make sure that you are on the latest build, from the Checkout Menu (next to the apple in the upper left hand corner of the screen) select Check for updates.
Regards,
Michele
Checkout Support
I hope this helps
Mihele
3 Posted by simon on 01 Feb, 2013 04:21 PM
Hi Michele, Thanks for the reply, I don't use the purchase order function so why am I getting a different figure in the default cost and cost columns every now and then?
Regards
Simon Luther
[email blocked]
Support Staff 4 Posted by CO Michele on 04 Feb, 2013 03:57 PM
Simon
Can you check the margin on your sales reports? This comes from the actual cost, not the default cost. How do you import inventory? If you are doing stock corrections this uses the default cost as well. This would indicate the default cost had been set to zero and there was no actual cost it would show as zero cost, or if the items were imported without a default cost.
I hope this helps.
Regards,
Michele
Checkout Support
5 Posted by simon on 06 Feb, 2013 10:54 AM
Hi Michelle, I input stock using the new product tab in products, so the cost and default cost should be the same but on some items it is different, in the screen-grabs I have sent you can see that the default cost in the stock room for the pillow is 13.75 and the retail is 27.50, in the stock report the default cost as you can see is correct but the cost column has a totally random figure, which is in turn making my stock value wrong, This has happened on quite a few products and as you can imagine is making my monthly stock figure rather difficult to work out, if you can help in anyway it would be greatly appreciated.
Regards
Simon Luther
[email blocked]
Support Staff 6 Posted by CO Michele on 06 Feb, 2013 02:44 PM
Simon,
Could you check the Stock Correction Report to see if there are any adjustments to the price on this product.
Regards,
Michele
Checkout Support
7 Posted by simon on 06 Feb, 2013 03:21 PM
Hi Michelle, As you can see I entered the product on the 22nd and altered the price the day after because I made a mistake and entered the correct price.
Regards
Simon Luther
[email blocked]
8 Posted by simon on 06 Feb, 2013 03:25 PM
Here is another example where no adjustments have been made on the price at a later date.
Regards
Simon Luther
[email blocked]
Support Staff 9 Posted by CO Michele on 06 Feb, 2013 03:32 PM
Simon
On your first item 34199, 1 was received at $27.50 and 1 was received at $13.75 therefore the cost would be $20.62 per item. That is why the $20.62 is shown in the cost column.
I hope this helps
Michele
Checkout Support
10 Posted by simon on 06 Feb, 2013 04:13 PM
Thanks Michelle, that makes sense but not sure how to fix it other than deleting them from stock and putting them back in at the correct price.
Also it doesn't explain the slight discrepancy in the second example I sent to you?
I am going to print out every Report thats related and sit down tomorrow and go over them a fine tooth comb and see what I come up with.
Regards
Simon Luther
[email blocked]
Support Staff 11 Posted by CO Michele on 06 Feb, 2013 04:30 PM
Simon,
Yes the only way to fix it is deleting from stock and putting them back in at the correct price. What are you showing in your second example? What is the report you are pasting here? Have you checked the stock correction report for that item as well? The cost on the reports will show the cost that was used at the time it was put into stock. I hope this helps.
Regards,
Michele
Checkout Support