Subject: | Surcharge Code for Prescription and POS Payments should be configurable |
Summary: | Prescription and POS Payments use the same SURCHARGE product codes, however, Prescription Surcharge is Taxable while POS Payments are NOT TAXABLE. To handle this, we need to separate the surcharge codes. We will use the following Configuration Items: - Prescription Surcharge
- Prescription.Surcharge.ProductCode
- Tax Code will be extracted from "Prescription.Surcharge.ProductCode"
- Prescription Surcharge Amount will be extracted from the Product Code defined in 1.1 above
- The default will be: Product Code: "SURCHARGE", Sell Price will be: 0.45
- POS Surcharge
- POS.Surcharge.ProductCode. Used for Payment Surcharge and Cashier Short/Surplus penalties
Since this change requires UI changes, we will make this change in the 14.91 release. |
Audit Notes: | Edited by sanjay on 17/04/24 16:13. Edited by sanjay on 26/03/24 16:56. Edited by sanjay on 22/02/24 11:54. Edited by sanjay on 22/02/24 11:54. Edited by sanjay on 22/02/24 11:53. Edited by sanjay on 22/02/24 11:52. Edited by sanjay on 08/02/24 11:58. Edited by sanjay on 12/10/23 10:19. Edited by sanjay on 18/09/23 15:18. Edited by sanjay on 11/09/23 09:24. Edited by sanjay on 08/09/23 11:47. Edited by sanjay on 08/09/23 11:46. Edited by sanjay on 07/08/23 15:30. |
08 Sep 2023 | 11:46AM Comment 1 by Sanjay (Link Technologies) This comment has been removed |
08 Sep 2023 | 11:46AM Comment 2 by Sanjay (Link Technologies) ETC was changed from 04/08/2023 to 15/09/2023 |
11 Sep 2023 | 09:23AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-09-2023 09:18 AM Time Taken: 8.00 Notes: ETC extended from: 15/09/2023 to 13/09/2023 |
| Hi guys, we have decided to exclude this change due to the following reasons: - The requirement states "Prescription Surcharge is Taxable while POS Payments are NOT TAXABLE". This can be achieved since the Prescription Tax Code can be marked as "Taxable" by setting this in configuration "POS.Surcharge.TaxCode - Surcharge on prescription items tax code". The Surcharge on "POS Cashier Shift and Payments" can be marked as Taxable if required by setting the Tax Code on the product code "SURCHARGE"
- We will remove the HARDCODING of the surcharge in the next major release.
|
|
18 Sep 2023 | 03:18PM Comment 4 by Sanjay (Link Technologies) Case L12934 added to project 15.10 |
12 Oct 2023 | 10:19AM Comment 5 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 31-10-2023 10:17 AM Time Taken: 1.00 Notes: ETC extended from: 13/09/2023 to 31/10/2023 |
| Hi Vineshwar, I have had a look at this issue and I am able to have the Prescription Surcharge as Taxable while the Payment Surcharge as Non Taxable. Can you set this up in a demo and send a meeting request to go through the issue so I can design a solution? thanks. |
|
12 Oct 2023 | 10:19AM Comment 6 by Sanjay (Link Technologies) Case L12934 removed from project 15.10 |
04 Jan 2024 | 10:13AM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-01-2024 10:10 AM Time Taken: 1.00 Notes: Edited by sanjay on 04/01/24 10:26. |
| Teams - Sanjay and Vineshwar The issue is that in the "Sales Analysis Report" we are unable to identify what amount is Taxable and what amount is Not Taxable since we are using the same Surcharge Product Code. Important Notes: - A Medication (Product) can be TAXABLE or NOT TAXABLE depending on:
- Has it been processed through Prescription (In this case, the Fiji Govt has asked this item to be Not Taxable)
- Is it a direct Sale from the counter (In this case, the Fiji Govt has asked this item to be Taxable)
Based on 1. above, we need to keep the General Settings Configuration for POS "Charge Tax on Prescription Item" There are two types of Surcharge: - POS Payment - POS-Surchage
- Prescription - PRE-Surcharge
If we change the Product Code used for Surcharge, we will resolve the issue identified in comment 7 (Sales Analysis Report) |
|
08 Feb 2024 | 11:58AM Comment 8 by Sanjay (Link Technologies) Case L12934 added to project Review |
08 Feb 2024 | 11:58AM Comment 9 by Sanjay (Link Technologies) ETC was changed from 31/10/2023 to 30/06/2024 |
22 Feb 2024 | 11:51AM Comment 10 by Sanjay (Link Technologies) Assigned To: Kinisimere Tamanisau (Pacific Islands Development Forum) Followup Date: 07-03-2024 11:49 AM |
| Case assigned to development in version 15.30 |
|
22 Feb 2024 | 11:53AM Comment 11 by Sanjay (Link Technologies) Case L12934 added to project 15.30 |
19 Mar 2024 | 03:14PM Comment 12 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-03-2024 03:08 PM Time Taken: 1.00 Notes: Edited by sanjay on 19/03/24 15:21. |
| Teams - Vineshwar and Sanjay - Consider using defaults specified in comment 7, however, make the codes configurable as some external systems have restrictions on code lengths.
- Preference is to have the following General Settings configuration:
- Override Tax Code for Prescription Items: Default is "EXEMPT". Is Blank, do not override
- Product code for POS Surcharge. Default is "POS-Surcharge" or "POSSC"
- Product code for Prescription Surcharge. Default is "PRE-Surcharge" or "PRESC"
|
|
16 Apr 2024 | 01:13PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-04-2024 12:29 PM Time Taken: 2.00 Notes: ETC extended from: 30/06/2024 to 18/04/2024 |
| Hi Vineshwar, I had a look at the sales analysis report and it clearly shows Taxable ad Non Taxable portions. Can you do an example where we can see the issue so we can complete the tet cases to pass these changes? Thanks. |
|
17 Apr 2024 | 02:54PM Comment 14 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-04-2024 02:41 PM Time Taken: 1.00 Notes: Edited by sanjay on 17/04/24 15:54. |
| Teams - Vineshwar and Sanjay: - The Sales Analysis report groups the SURCHARGE for TAX and NO TAX into one line.
- We need to see two lines as the POS Surcharge is bank related expense
Use Product Codes:
SURCHG-PRE SURCHG-POS
|
|
17 Apr 2024 | 04:12PM Comment 15 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 19-04-2024 04:09 PM Time Taken: 18.00 Notes: Edited by sanjay on 17/04/24 16:16. |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.30 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - Added a new Product for Prescription Surcharge. Product Code: "SURCHG-PRE"
- The original product "SURCHARGE" will be used for Payment Surcharge only
3. Affected Areas: - When Prescription is created, the SURCHARGE PRODUCT CODE is "SURCHG-PRE" instead of "SURCHARGE".
4. The issue was caused by: - Using the same product code in Prescription and POS Payments caused the "Sales Analysis Report" to consolidate the two surcharges into one line. Users requested this to be separated for reporting purposes. See figure 1 below.
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
Figure 1 - Prescription and Payment SURCHARGES are separated
|
|
23 Apr 2024 | 11:57AM Comment 16 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 25-04-2024 10:01 AM Time Taken: 4.00 |
|
The following tests were performed:
Test Setup Instructions: - DEMO setup using 15.30
Table 1 - Test Results
No | Test Case | Expected Result | Pass/Fail | Comments | 1 | Process Prescription Item and complete sale through POS
|
| Pass
|
| 2 | Process POS using payment with Surcharge
|
| Pass
|
| 3 | Generate "Sales Analysis Report"
| Verify SURCHARGE and SURCHG-POS values are correct
| Pass
|
| Figure 1 - Prescription Sale
Figure 2 - POS Sale
Figure 1 - Sales Analysis Report
Environment Details - OS version: Win11
- Application version:15.30
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|