Client advised that they are generating the Sales Analysis Report for a week and have noticed that the Total Cost shown is incorrect in this report.

An example given is for item 016000409835 which has a cost of $3.7799 and a selling price of $4.95. When the report is generated from 16/05/2022 for location NAD06, the cost shown is $30.19. This cost should be $15.1196.

This has been noticed for items in the Price class. Other examples include 016000409897,016000409828,9300695005733,016000409941. Refer to the below example for item 016000409835.

Bula Team

We did a diagnostic and below are our findings:

1. From the 4 sold, 3 were sold without Price Class and one Price Class. The total cost is $18.85. The report is showing overstated cost of $30.19.
2. The Selling Price VEP Total of 18.19 is correct.

Figure 1.2 Select from DB

We will review this with our development team and get back to you

Regards
Vineet Ram
222 0085

Bula Sanjay

Environment details below:

1. URL: http://10.0.0.18/LinkWEB-XX/
2. Credentials: Default admin user
3. Version: 13.40.0404
4. Server: LINKQA8
5. Database: LINKSOFT-XXX-Training

Regards
Vineet Ram
222 0085

Hi Vineet, Which machines is this for? What SQL Server and DB name you are using?

Can you schedule a meeting for tomorrow at 10 am AEST or 2 PM aest to go through this so we have all relevant information before the case is assigned to me? Thanks.

Hi Sanjay

Comment 2 has been updated with database detail. This customer production database is on 13.40. As discussed, this item is sold on Price Class when there are markdowns of similar flavors. Its sold at Normal Retail Price as well when there are no markdowns

Regards
Vineet Ram
222 0085

Hi Vineet, here is an explanation of how we get the amounts. Details are in Figure 1 below.

Figure 1 - Sales analysis of Product ID: 016000409835

Bula Sanjay

The cost is overstated because, in transaction LTDSTX243338, there are 4 different items sold combined as a price class. We should not accumulate cost in 1 when calculating the Margin for that item. See the items sold in Transaction LTDSTX243338. So when the user is generating the Sales Analysis report for item 016000409835, it should only take the cost of 3.7799 and not 3.7799 x 4. Please see the table below for transactions for LTDSTX243338

Hope the above explains the entire scenario.

Regards
Vineet Ram
222 0085

Development Log:

1. Changed the Sales cost and Returns Cost  calculation for  class items to use the Class Items COST and Quantity instead of using the Class Quantity

Next Step:

1. Vineet to verify if this using the client's database
2. Sanjay to verify this in DEMO to ensure all scenarios are catered for

Hi Sanjay

After reviewing this, we have seen the following:

1. The quantity column has been removed from the updates applied
2. If the report is generated with the "Group By:" filter as "Product", one will not be able to ascertain the actual sales of an item as it was sold as a price class too. Refer to the Figure below for details of this report. Let's focus on item 016000409835. Note this item has been sold under Price Class "BC WITHOUT FROSTING 432G" as well as a Normal Item as highlighted below. Just grouping by Product at first glance, one will not be able to figure out how much of this product has actually been sold. Showing Price Class separately as below will not give the correct sales interpretation of an item. 

Figure 1.1. Snap of Sales Analysis grouped by Product

Regards
Vineet Ram

Hi Vineet, Re: Comment 12. We have not removed the Quantity column or changed the GroupBy Behaviour. If you run the update before and After, you will see the only difference is the Class Item Cost extraction.

If you need this report changed, please raise a new case so I can attend to this. Thanks.

Environment Details

1. OS version: Win11
2. Application version:14.00 Beta2
3. Setup on:
   1. Server: LinkQA4
   2. Database: LinkSOFT
   3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
4. Login Details: Standard username and password for user "admin"

Next Step: Closure