| Subject: | Design a view to export "VAT on Purchases/Expenses" for FRCS reporting |
| Summary: | Section A - Briefly explain what the change is about - FRCS has introduced the Taxpayer Online Services (TPOS) where customers can register, file tax returns, and make online payments for VAT.
- The above requires customers to upload a CSV file to TPOS with the tax details of purchases.
- The "VAT-on-Purchases-Expenses-Input-Details-Schedule" template for the file is on the FRCS website under "TPOS Excel Templates".
- Currently, the clients extract details from multiple reports to fill and upload the template.
- They have reported the above as tedious and there is a high risk of human error.
- Supermarkets have over 200 purchases orders in a month some with partial receiving.
- Thus we need to design this in LinkSOFT so users can export and upload the data which will make us fully compliant with tax reporting for purchases.
Section B - Explain in detail what this change is about - Create a view that will provide data as per the attached "VAT-on-Purchases-Expenses-Input-Details-Schedule".
- No calculations need to be done for this template, we just need to populate data in the relevant column as per table 1 below.
Table 1: Field Definitions for the template
Column
| Format
| Data from LinkSOFT
| Invoice Date
| DD/MM/YYYY
| Purchase Order "Received Date" from the "Purchase Receive" menu
| Supplier Tin
|
| Supplier Tax ID from the "Supplier Maintenance" menu
| Supplier Invoice Number
|
| "Supplier Reference" from the "Purchase Receive" menu
| Invoice Total (Inc VAT) (FJD)
|
| VIP total in "Fijian Dollars" from the "Purchase Receive" menu
| VAT Incurred (FJD)
|
| VAT in "Fijian Dollars" from the "Purchase Receive" menu
| Capital/Revenue
Revenue - 2
Capital - 1
|
| Default this to 2.
- Capital scenario occurs when a Purchase Invoice has an Asset purchased or Asset Nature and also treated by a Company as an Asset. LinkSOFT Purchasing Module is used by the client for Inventory only therefore Nature will always be Revenue. We will have the option to export the report into excel format, therefore, should any Asset Nature come up, users can edit the field.
|
Section C - Provide a Test plan for this change
Test 1 | Test Item | Comments |
1 | A PO is created for Supplier A with "ITEM P1001 and Quantity as 1". The VIP total is $109.00. The VAT is $9.00. Supplier A is a local supplier. Supplier TIN is 9999999 Supplier Receiving Reference is SA001. The PO is fully received. | Refer to the attached sample. Field A2 |
2 | A PO is created for Supplier B with "ITEM P1001 and Quantity as 2".The VIP total is $218.00. The VAT is $18.00. Supplier B is a local supplier. Supplier TIN is 8888888 Supplier Receiving Reference is SB001. Receive 1 out of the 2 ordered quantities | Refer to the attached sample. Field A3 |
3 | Fully receive the PO in 2 above Supplier B is a local supplier. Supplier TIN is 8888888 Supplier Receiving Reference is SB002. | Refer to the attached sample. Field A4 |
4 | A PO is created for Supplier A with "ITEM P1001 and Quantity as 1". The VEP total is $100.00. The VAT is 0 Supplier C is a internaatinal supplier. Supplier TIN is 7777777 Supplier Receiving Reference is SC001. The PO is fully received. | Refer to the attached sample. Field A5 |
Section D - Additional Information and Costing
1. Request Information | ID | Description (*Required Fields) | Value | | 1 | Customer Name* | New Town Shopping Centre, Absolute Shopping Centre, Laucala Bay Pharmacy, Kundan Singh
| | 2 | Estimated Cost (hrs/$) |
| | 3 | Cost Covered By * |
| | 4 | Workarounds? | Extract data from "Supplier Listing" and "Purchase Order Received Report" to manually fill the template and upload data.
| | 5 | Date Required by * | 31/08/2021 |
|
| Audit Notes: | Edited by sanjay on 25/06/21 10:17. Edited by sanjay on 24/06/21 10:30. Edited by sanjay on 18/06/21 17:32. Edited by rashna on 17/06/21 13:22. Edited by sanjay on 17/06/21 13:20. Edited by rashna on 17/06/21 07:00. Edited by rashna on 17/06/21 06:58. Edited by rashna on 17/06/21 06:38. Edited by rashna on 17/06/21 06:32. Edited by rashna on 17/06/21 06:29. Edited by rashna on 17/06/21 06:28. Edited by rashna on 16/06/21 13:38. Edited by rashna on 16/06/21 13:37. Edited by rashna on 16/06/21 13:29. |
| 17 Jun 2021 | 01:22PM Comment 1 by Rashna (Edge Business Solutions) Case L12283 added to project 12.43 |
| 17 Jun 2021 | 01:24PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 18-06-2021 01:22 PM Time Taken: 1.00 |
| Hi Sanjay, As per the development meeting with Sanjay, Alvis, Sitla, Vineshwar, and Rashna. - Meeting Date: 17/06/2021.
- Meeting Time - 1 pm AEST
The following was agreed - Agreed to design the view in LinkSOFT
Thanks
Rashna
|
|
| 18 Jun 2021 | 03:54PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-06-2021 03:32 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:12.43.0618 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Created a BIVW named: "POS - Purchase Order Received"
- Column names have been changed slightly to correctly reflect data in the column.
- Capital/Revenue column has not been added as it is not defined in LinkSOFT. Users can add this manually
3. Affected Areas: - New BI View
4. The issue was caused by: - New Feature
5. Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT |
|
| 18 Jun 2021 | 05:32PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 17/06/2021 to 17/06/2021 |
| 24 Jun 2021 | 05:01PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-06-2021 05:00 PM Time Taken: 2.00 |
| System Test completed. Proceed with UAT |
|
| 25 Jun 2021 | 10:17AM Comment 6 by Sanjay (Link Technologies) ETC was changed from 17/06/2021 to 25/06/2021 |
| 28 Jun 2021 | 01:31PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 29-06-2021 01:10 PM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary
est 1 | Test Item | Comments |
1 | A PO is created for Supplier A with "ITEM P1001 and Quantity as 1". The VIP total is $109.00. The VAT is $9.00. Supplier A is a local supplier. Supplier TIN is 9999999 Supplier Receiving Reference is SA001. The PO is fully received. | Pass |
2 | A PO is created for Supplier B with "ITEM P1001 and Quantity as 2".The VIP total is $218.00. The VAT is $18.00. Supplier B is a local supplier. Supplier TIN is 8888888 Supplier Receiving Reference is SB001. Receive 1 out of the 2 ordered quantities | Pass |
3 | Fully receive the PO in 2 above Supplier B is a local supplier. Supplier TIN is 8888888 Supplier Receiving Reference is SB002. | Pass |
4 | A PO is created for Supplier A with "ITEM P1001 and Quantity as 1". The VEP total is $100.00. The VAT is 0 Supplier C is a internaatinal supplier. Supplier TIN is 7777777 Supplier Receiving Reference is SC001. The PO is fully received. | Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 12.43.0625GA
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-RASHNA
Next Step: - For Closure
|
|
| 28 Jun 2021 | 04:44PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-06-2021 04:44 PM Time Taken: 1.00 |
| Thanks Rashna |
|