Company: Link Technologies
Case No: L08645. Project: 08.20: LinkSOFT Version 8.2
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 03 Jul 2017 10:24AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 4.00 (Weight: 4.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna
Resolve By: Tuesday, 04 July 2017 12:00 AM [2490 days since logged date]
Status: Closed
Subject: Incorrect Selling Price displayed in POS for products which have been tagged as "TAXEX" and have a minimum profile set
Summary:    
Hi Sanjay,

The system is incorrectly calculating selling price for products which have the following characteristics: 
1. Tagged as “TAXEX”
2. Have minimum profit percentage set

Consider the following:
1. Create a product as PT001, refer to figure 1.
2. In order to achieve minimum profit of 20%, the system will not allow the product to be sold at anything lower than $7.94: (Cost + Markup: Based on the minimum profit: 6.07 *.20 = 7.28 * 109 = $7.94)
3. Since the product is tagged as TAXEX, the selling price of $7.55 does not include the 9% vat. Therefore, adding that, makes the selling price as $8.23 ($7.55 * 1.09(VAT))
4. When this item is loaded onto POS, the system some how disregards the fact that $7.55 is exclusive of tax and sells it at $7.94 to achieve the minimum profit.

Figure 1:



This is wrong because the VIP price of this product is $8.23 which already achieves the minimum profit markup.

The environment is setup in QA2, DB: LINKSOFT (demo database).

This is an issue faced by our client: GHC, therefore we are requesting an urgent patch for v8.12

Kindly take a look.

Regards
Aarti.

Audit Notes:
05 Jul 201710:11AM Comment 1 by Alvis (Link Technologies) Case 8645 added to project 8.14
12 Jul 201709:10AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-07-2017 09:10 AM Time Taken: 2.00
Development work for this case has been completed.
The change will be available in version: 8.14
Documentation update required(Yes/No. Add change details below): No
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information):|

  1. Changed product price function to handle tax exclusive scenario
The cause of the Issue:
  1. The problem was in the product price function which was comparing Minimum price (including tax) with price setup. In this case price setup was exclusive tax
Can this issue happen again? No
How/When will the correction be delivered? 8.14

14 Jul 201702:44PM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-07-2017 02:44 PM Time Taken: 2.00

Dear Team,

Case has been tested and passed correctly.

Correct price is displaying in POS based on the tax code.

Tax code tested: TAXIN & TAXEX with minimum profit percentage.


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08645 in the subject line of all emails regarding this issue.

Document size: 5.3 KB
For call complaints, please contact the Managing Director of the company using this form.