Potential accounting issue with Helios?

[unity]

Hello!

I know master inventory is not intended to do book, and I never would use it as such. But I just did a master report of inventory. I had it sub-total. With Swedish Beauty products I have just two bottles of Skin Embrace in stock.

The retail total is right, $85.00.

However the total cost of SB products is not. Its correct if you bases it on the "cost" ended into the inventory end of the sales code, its right. However I get all products less than the set price and enter that correct total when receiving. Essentially its reporting a total cost of goods $2.xx too high.

So the red flag went up.

Does helios report correct cost doing "Department and Division" reports? Nope, thats wrong too. I checked a REALLY slow day and added up what Helios thought he cost of products were for the 27th of Jan. Then I checked the receiving reports and of course the true cost was a lot less.

Since changing the cost in the sales code EVERY time I receive something is NOT a solution, where I can I get and accurate report of the cost of goods sold, profit on goods and total retail on good for January?

[unity]

My first call on this a week ago to Helios assured me it was not a problem, but the way. I just called again with the reports I ran so I had some solid number to address my concern. Jeremy shall call me tomorrow since the rep i talked too was not sure.

The rep told me to change the "cost of" in the inventory tab every time, but that makes no sense.

Let me run this scenario by you all to simplify this puzzle.

Your salon sells just one bottle, its called "Goo" by "Goo inc.". It retails for $20.00 and you will sell 12 bottles this year.

For the first 6 months of the year your cost is $10.00 a bottle and you sell 6, one each month.
In Helios you have the cost set to $10.00.
Now Goo inc. calls you to tell you for the next three months you can get it for $9.00 a bottle.
You get three more over the next three months and when you receive it in Helios you adjust the price after you enter the quantity to reflect the dollar less.
But now the last three months the cost is back to $10.00 a bottle and again you order three more over those last three months of the year.

This would mean:
Retail sales: $240.00
Cost: $117.00

However, Helios sees:
Retail sales: $240.00
Cost: $120.00

This is because it does not look that the amount you received it for under the "Inventory Adjustment" tab and add it up, it only looks at the cost you set in the "Inventory Tab".

And even if you had adjusted the cost amount for three months, you would have set it back for the last three anyway.

Does this make sense?

Normally I use the "Department and Division" report to get totals - like for taxes - and if this is true then my REALL cost of good sold last year was much less since I often, but not always, get products below the "cost" price I set.

[Mojave Tan]

Helios has sooooooo many issues. I called them when I first bought the product and offered many suggestions, business needs and error assistance since I used to design CRM products. They called me back 8 weeks later. not like they cared...