Company: Link Technologies
Case No: L12283. Project: 12.43: LinkSOFT Version 12.43
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 16 Jun 2021 01:38PM
Priority: Medium
Product: Point of Sale
Group: New Feature
Time Taken: 11.00 (Weight: 16.00)
Version: 12.43.0706
Assigned To: Sanjay (Link Technologies)
Circulation: Rashna, Sanjay
Resolve By: Friday, 25 June 2021 11:59 PM [1041 days since logged date]
Status: Closed
Subject: Design a view to export "VAT on Purchases/Expenses" for FRCS reporting
Summary:    
Section A - Briefly explain what the change is about
  1. FRCS has introduced the Taxpayer Online Services (TPOS) where customers can register, file tax returns, and make online payments for VAT.
  2. The above requires customers to upload a CSV file to TPOS with the tax details of purchases.
    1. The "VAT-on-Purchases-Expenses-Input-Details-Schedule" template for the file is on the FRCS website under "TPOS Excel Templates". 
  3. Currently, the clients extract details from multiple reports to fill and upload the template.
  4. They have reported the above as tedious and there is a high risk of human error.
    1. Supermarkets have over 200 purchases orders in a month some with partial receiving. 
  5. 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

  1. Create a view that will provide data as per the attached "VAT-on-Purchases-Expenses-Input-Details-Schedule".
  2. 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.

  1. 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
     IDDescription (*Required Fields)Value
     1Customer Name*New Town Shopping Centre, Absolute Shopping Centre, Laucala Bay Pharmacy, Kundan Singh
     2Estimated Cost (hrs/$)
     3Cost Covered By *
     4Workarounds?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 202101:22PM Comment 1 by Rashna (Edge Business Solutions) Case L12283 added to project 12.43
    17 Jun 202101: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.

    1. Meeting Date: 17/06/2021.
    2. Meeting Time - 1 pm AEST

    The following was agreed

    1. Agreed to design the view in LinkSOFT

    Thanks
    Rashna



    18 Jun 202103: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):

    1. Created a BIVW named: "POS - Purchase Order Received"
    2. Column names have been changed slightly to correctly reflect data in the column. 
    3. Capital/Revenue column has not been added as it is not defined in LinkSOFT. Users can add this manually

    3. Affected Areas:

    1. New BI View

    4. The issue was caused by:

    1. New Feature

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


    18 Jun 202105:32PM Comment 4 by Sanjay (Link Technologies) ETC was changed from 17/06/2021 to 17/06/2021
    24 Jun 202105: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 202110:17AM Comment 6 by Sanjay (Link Technologies) ETC was changed from 17/06/2021 to 25/06/2021
    28 Jun 202101: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

    1. OS version: Windows Server 2012
    2. Application version: 12.43.0625GA
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-RASHNA

    Next Step

    1. For Closure

      28 Jun 202104: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

      Attachments:
      General Documents - Case: L12283:VAT-on-Purchases-Expenses-Input-Details-Schedule.xlsx
      VAT-on-Purchases-Expenses-SampleasperTestPlan .xlsx
      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12283 in the subject line of all emails regarding this issue.

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