Subject: | Incorrect figures in "VAT Form" report |
Summary: |
The VAT Return form generated from FMS Portal displays incorrect figures in the following: - B1: Total Taxable Supplies
- B2: Zero-Rated Supplies
- 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: - The FMIS Tax Maintenance was verified against the Tax Maintenance in Jiwa
- The FMIS Integration views were created again
- 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 2018 | 01: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 2018 | 03:47PM Comment 2 by Alvis (Link Technologies) Case 9293 added to project 09.4 |
23 May 2018 | 03: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):| - 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: - N/A
3. Next Step - UAT
Note that: Tax rates must be configured in FMS Portal for the tax report to show data correctly. |
|
24 May 2018 | 02: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 2018 | 09: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 Test | Description | Status | 1 | Create a Sales Order with item price 755.00 and tax rate as 9%. Inclusive Price = 822.95 | Pass | 2 | Generate the "Tax Return Report" tax amount should be $67.95 | Pass | 3 | Generate 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 | 4 | Create another Sales Order with item price 755.00 and tax rate as 0.
| Pass | 5 | Generate 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 2018 | 06:15PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-06-2018 06:15 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08: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 |