Company: Link Technologies
Case No: L09293. Project: 09.40: LinkSOFT Version 9.4
Logged By: Karishma Kartika Devi (Link Fiji) on 14 May 2018 09:55AM
Priority: High
Product: Financial & Asset Management
Group: Software Defect
Time Taken: 4.50 (Weight: 4.50)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Karishma Kartika Devi, Rashna, Sanjay, Vineet
Resolve By: Friday, 16 February 2018 10:41 PM [2146 days since logged date]
Status: Closed
Subject: Incorrect figures in "VAT Form" report
Summary:    

The VAT Return form generated from FMS Portal displays incorrect figures in the following:

  1. B1: Total Taxable Supplies
  2. B2: Zero-Rated Supplies
  3. B6: Due to the above, B6 is calculated incorrectly.
Refer to Figure 1: VAT Return Form


The following diagnosis was carried out from our end:

  1. The FMIS Tax Maintenance was verified against the Tax Maintenance in Jiwa
  2. The FMIS Integration views were created again
  3. The values in the VAT Return form have been verified against the values in the Tax Return report as well as Debtor Transactions report.

Figure 2: Tax Return Report

Figure 3: Debtor Transactions report




Figure 4: Parameters Used to Generate the VAT Return form


The actual figures in B1 and B6 should be as per the Tax Return report and Debtor Transactions report.

B1 - $1,143,716.08

B2 - $706,204.06

B6 - $36,124.80


Environment Details

Server Name: QA4

Database Name: CLIENT_CAAF_JIWA_LIVE-Upgraded

FMS Portal URL: http://localhost/FMSPortal/Account/Login.aspx?ReturnUrl=%2fFMSPortal%2f

Login: Ashwin

Password: 12



Audit Notes:
18 May 201801:01PM Comment 1 by Karishma Kartika Devi (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 21-05-2018 12:00 AM Time Taken: 0.50

Dear Alvis,

As discussed in the development meeting today, please find attached the screenshot showing the parameters used to generate the VAT form in the case header.


Regards
Karishma


23 May 201803:47PM Comment 2 by Alvis (Link Technologies) Case 9293 added to project 09.4
23 May 201803:51PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-05-2018 03:51 PM Time Taken: 2.00
Development work for this case has been completed.
The change will be available in version: 9.4 Beta3

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

  1. Tax report uses the tax configured in FMS Portal. We have changed the integration to have 3 tax codes for each tax code in JIWA. These are [TaxCode], [TaxCode]-I, and [TaxCode]-E. The "I and E" extensions are used by JIWA inventory setup for POS.

2. The issue was caused by:

  1. N/A

    3. Next Step

    1. UAT

    Note that: Tax rates must be configured in FMS Portal for the tax report to show data correctly.


    24 May 201802:51PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 24-05-2018 02:51 PM Time Taken: 1.00

    System test completed.

    Verified that Tax Return report and Fiji VAT Report shows the data correctly based on the "Tax Maintenance" setup in FMSPortal.


    06 Jun 201809:22AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-06-2018 12:00 AM Time Taken: 1.00

    Hi Sanjay, 

    This case has been successfully tested.

    Documentation on the case has been completed.

    • FMIS Management System Portal -- Tax Return Report
    • FMIS Management System Portal -- Fiji VAT Return Form

    Test Environment

    Test Plan

    TestDescriptionStatus
    1Create a Sales Order with item price 755.00 and tax rate as 9%.  Inclusive Price = 822.95Pass
    2Generate the "Tax Return Report" tax amount should be $67.95Pass
    3Generate the "VAT Return Form". B1 should be 822.95, B2 should be 0, B3  should be 822.95 and B4 should be 67.95.Pass
    4Create another Sales Order with item price 755.00 and tax rate as 0.
    Pass
    5Generate the "VAT Return Form". B1 should be 1577.95, B2 should be 755, B3  should be 822.95 and B4 should be 67.95
    Pass

    Thanks

    Rashna


    06 Jun 201806:15PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 06:15 PM
    Thanks Rashna 

    09 Oct 201908:14AM Comment 7 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09293 in the subject line of all emails regarding this issue.

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