logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
Daily sales reports are not calculating properly - Daily sales reports are not calculating properly
Options
Go to last post Go to first unread
Previous Topic Next Topic
ray22901031  
#1 Posted : Saturday, October 31, 2020 7:48:19 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
The daily sales reports are not calculating properly the profit margin when you have options included. This is a very serious issue. Here's an example.

Base SKU: AAH84RCS8AA1AN
Price: 165.99
Cost: 150.00

This product has an option called extra battery,
Price: 24.99
COGS: 18.00

We go to the admin backend and I place a test order, we add:

Qty: 1 of SKU AAH84RCS8AA1AN ($165.99) with an extra battery ($24.99).

TOTAL TICKET PRICE: $190.98 - This is correct
TOTAL COS FOR THIS TICKET SHOULD BE: $ 168.00

When I run the daily sales report, Ablecommerce thinks the total COS for the entire ticket is $150.00, given me a profit of $40.98, when the actual profit should be $22.98. Ablecommerce is not taking into account the cost of sale of the option.

Can you imagine four years from now, if I tried to sell my business based on these reports what legal actions someone can take against me. This is a very serious issue for us, and it should be easily produced by anyone using this product. I have verified my numbers multiple times, I have verified that in my options, the cost of sale is filled in. Is there a setting somewhere in the software that I am missing?

If anybody else is using options that manipulates ticket totals, I would suggest that you run your reports to see if you're seeing the same thing. Using the latest version9.0.3 with no modifications.

I await your reply, and like always many thanks.
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
ray22901031  
#2 Posted : Monday, November 2, 2020 5:41:50 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
I think it's important to let you know that the report is correct when you're using kitting. I will need to run more complex orders to verify this again.

I hope this helps
Back to top
shari  
#3 Posted : Monday, November 2, 2020 6:05:10 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
I have run a test locally with the same configurations. I am able to confirm the issue.

Again thanks for identifying the issue. I am opening a bug report for this issue.

Edited by user Monday, November 2, 2020 6:10:38 AM(UTC)  | Reason: Not specified
Back to top
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.139 seconds.