Company: Link Technologies
Case No: L12714. Project: 14.00: LinkSOFT Version 14.00
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 04 Apr 2022 03:44PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 18.50 (Weight: 22.50)
Version: 14.00
Assigned To: Development
Circulation: Development, Sanjay, Vineet, Vineshwar Prasad
Resolve By: Saturday, 30 April 2022 11:59 PM [962 days since logged date]
Status: Closed
Subject: Enhancement to Tax Detail Report to provide sales breakdown by tax codes
Summary:    
Section A - Describe what the request/issue is about 
Fiji has introduced 4 types of Tax since April 2022. 
  1. Vat 9%
  2. Vat 15%
  3. zero-rated 0%
  4. Plastic Bag Levy $.0.50

We need a report in Linksoft that can give us a breakdown of Sales Exclusive of each tax vertically. For example, if my Total Tax Exclusive is $200,000 then we need the information as below:

Sales Exclusive: $120,000
Vat 15%        : $18,000

Sales Exclusive: $60,000
Vat 9%         : $5,400

Sales Exclusive $20,000
Zero Rated      $0

Plastic Bag Levy: $500

The new report should have the following filters:

  1. Date From
  2. Date To:
  3. Location:

Group the sales by Tax codes rather than labels and we can show labels in the breakdown.

The sample report below:

Figure 1.1 Sales Tax Detail Report Requirement

Vat15

 

Sales Tax Exclusive

120000

TaxLabel

D

TaxPercent

15%

Tax Amount

18000

Sales Total Including Taxes

138000

 

 

ZeroRated

 

Sales Tax Exclusive

20000

TaxLabel

B

TaxPercent

0%

Tax Amount

0

Sales Total Including Taxes

20000

 

 

Vat9

 

Sales Tax Exclusive

60000

TaxLabel

A

TaxPercent

9%

Tax Amount

5400

Sales Total Including Taxes

65400

 

 

PBL

 

Sales Tax Exclusive

0

TaxLabel

P

TaxPercent|Value

 $                         0.50

Tax Amount

500

Sales Total Including Taxes

500

 

 

 

 

VatEcal

 

Sales Tax Exclusive

120000

TaxLabel

D

TaxPercent

15%

Tax Amount

18000

TaxLabel

E

TaxPercent

6%

Tax Amount

7200

Sales Total Including Taxes

145200

 

 Section B - Cost Information:
1. Request Information
 ID
Description (*Required Fields)Value
 1Customer Name *All POS Customers Fiji
 3Cost Covered By *Discuss Internally
 4Workarounds?Dump Sales Reports and Vlookup
 5 Date Required by *20/04/2022

Section C - Provide a Test plan - List out at least two scenarios that will be used to verify

Audit Notes:Edited by sanjay on 11/05/22 13:12. Edited by sanjay on 22/04/22 15:34. Edited by sanjay on 20/04/22 08:59. Edited by sanjay on 20/04/22 08:59. Edited by vineet on 12/04/22 11:09. Edited by vineet on 12/04/22 11:08. 
08 Apr 202210:06AM Comment 1 by Vineet (Link Business Solutions) Assigned To: Development Followup Date: 12-04-2022 12:00 PM Time Taken: 0.50

Bula

This is a new case to accommodate Fijis 3 tier Consumer Tax for POS

Regards
Vineet Ram


20 Apr 202208:46AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2022 12:18 PM Time Taken: 4.00

*** CASE E01865 - Same request to be considered *** 

Most of the clients are now requiring reports that can show Sales Totals by Tax Labels. This is achievable through the ''Sales Tax Detail Report'' however there are only 3 filters for Tax Labels. When a single Tax Label is selected, this does not give the total for that particular Label.

We can achieve the above by adding a few columns in the "Data View -> POS - Invoice Listing"

Sample

Record Date

Reference No

Transaction Type

Payment Method

Username

Shift

Location Code

Invoice Total

Tax Label

Tax Amount

Amount Received

Amt Returned

Balance

Rounding

Change

Notes

Due Date

Status

01/01/2022 7.34 AM

LTRC001

Cash Sales

Cash

Vinesh

LTSH001

Retail

            100.00

A

             9.00

                    100.00

                     -   

           -   

 

         -   

 

02/04/2022

CLOD

01/01/2022 7.35 AM

LTRC002

Cash Sales

EFTPOS

Vinesh

LTSH001

Retail

            100.00

D

           15.00

                    100.00

                     -   

           -   

 

         -   

 

02/04/2022

CLOD

01/01/2022 7.36 AM

LTRC003

Credit Sales

 

Vinesh

LTSH001

Main

            100.00

B

                 -   

 

                     -   

   100.00

 

 

 

02/04/2022

PRSD

 

Note: Changes highlighted in Grey

20 Apr 202208:59AM Comment 3 by Sanjay (Link Technologies) Case L12714 added to project 14.00
20 Apr 202201:43PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2022 01:00 PM Time Taken: 8.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.00 and Patch for 13.40

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

  1. Added a Business Intelligence View named: "POS-Invoice Detail Listing" to display the columns:

  1. ReferenceNo
  2. Line
  3. TransactionType
  4. Username
  5. Shift
  6. Quantity
  7. UnitCost
  8. UnitPrice
  9. Discount
  10. LineTotalIncTax
  11. TaxAmount
  12. TaxCode
  13. TaxRate
  14. TaxIsPercent
  15. TaxIsInclusive
  16. PaymentMethod
  17. TaxLabel

  1. Since there can be multiple Tax Labels per Invoice Line, I have added a CSV column listing all the Tax Labels
  2. Since there can be multiple Payment Methods per Invoice, I have added a CSV column listing all the Payment Method

3. Affected Areas:

  1. New BI View

4. The issue was caused by:

  1. Tax Analysis by Tax Labels

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): Review and UAT


20 Apr 202201:44PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2022 05:43 PM
Changes have been applied to these two sites for review and comments:
  1. https://linktechnologies.com.au/DEMO-LinkSOFT-EDGE/
  2. https://linktechnologies.com.au/DEMO-LinkSOFT-LBS

20 Apr 202202:43PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2022 05:44 PM
Added LocationID to the BIVW requested by Vineshwar.

20 Apr 202203:11PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-04-2022 07:10 PM Time Taken: 2.00

Hi guys, V13.xx patch is at this link. Apply to the database using SSMS and give access to the BIVW using "Role Menu Access".

There is no version change. 


22 Apr 202203:34PM Comment 8 by Sanjay (Link Technologies) ETC was changed from 05/04/2022 to 30/04/2022
19 Jul 202203:27PM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-07-2022 07:21 PM Time Taken: 4.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Sell item with single Tax label



2Sell item with multiple tax label - Generate BIVW for Invoice Detail
Tax label should show multiple labels
Pass
See figure 1
3



4



5



Environment Details

  1. OS version: Win11
  2. Application version:14.0
  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"

Figure 1 - Tax Label BIVW


Next Step: Closure


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

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