Company: Link Technologies
Case No: L08718. Project: 08.20: LinkSOFT Version 8.2
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 28 Jul 2017 06:17AM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 7.50 (Weight: 7.50)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Rashna
Resolve By: Saturday, 29 July 2017 12:00 AM [2910 days since logged date]
Status: Closed
Subject: Incorrect exchange rate and tax code are displayed when purchase orders flow from LINKSOFT into JIWA
Summary:    

When the Purchase Orders are created in Link and posted to JIWA:

  1. The Foreign Currency Transaction figure and the Foreign Currency Rate is not displayed correctly.
  2. The GST description gets populated as “VAT” for exempt purchase orders.

The environment is setup in QA4, DB’s: LUNCHBOX_LABASA_JIWA & LUNCHBOX_LABASA_LINKSOFT

Refer to steps below:

  1. Setup “BUY” currency as:
    • Currency From: AUD
    • Currency To: FJD
    • Rate: 2.00
  2. Created PO - LTPO000004. [Refer to image 1]
  3. Posted this PO with the supplier reference as “Supplier Ref: REC06”.
  4. When the Creditor Purchase is created in JIWA, the “Foreign Currency Trans.”, and “Foreign Currency Rate” is updated incorrectly. [Refer to image 1]
  5. The GST description gets populated as “VAT” whereas, the PO was created as “Exempt”. [Refer to image 1]

The reason why this is needed is because;

  1. Currency in JIWA is displaying the foreign rate conversion as 1:1. This will result in vast amounts of FX gain/loss situations when payments are processed in JIWA with given valid foreign exchange rates.
  2. When VAT is displayed on the creditor purchase screen, it’s disabled. If we may ever need to amend the creditor purchase entries to correct any mismatches between Link and JIWA reported in future, upon editing any transaction amount, VAT is calculated and cannot be changed since the field is disabled.

Refer to image 1:




Audit Notes:
18 Aug 201710:43AM Comment 1 by Alvis (Link Technologies) Case 8718 added to project 8.17
18 Aug 201703:50PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-08-2017 03:50 PM Time Taken: 1.00
Development work for this case has been completed.
The change will be available in version: 8.17
Documentation update required(Yes/No. Add change details below): No
QA required(Yes/No.Include areas that require testing): Yes

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

  1. Requested changes have been completed.

22 Aug 201709:48AM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 22-08-2017 12:00 AM Time Taken: 2.50
QA for product and Patch Releases
Step 1 - Developer to system test changes until not issues are found - Alvis and Sanjay to sign off on System Test
Step 2 - Product expert allocated by Consulting Manager for Product QA.
               Consulting Manager to allocate resource
               Consulting Manager to sign off on UAT and Generic Test

STEP 1 - DETAILS OF QA can be entered in case comments. Summary to be maintained in the table below.

While testing this case, it was noticed that LPO: LTPO000022 was received as zero cost.

Steps Performed:

  1. The local currency is AUD.
  2. Setup buy currency: FJD TO AUD = 2.00
  3. Created supplier "Aarti" and setup currency as "FJD"
  4. Created PO LTPO000022, this was received as $0.00
  5. Created PO LTPO000023, with the exact same details as LTPO000022, this was received at the right cost. (LPO -  "LTPO000023" was not a copy record transaction)
Details:
QA: 2
Database: Linksoft



    22 Aug 201710:20AM Comment 4 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 22-08-2017 10:20 AM Time Taken: 1.00

    Hi Aarti,

    I am not able to replicate this on the demo.

    Can you try this again using a fresh demo database?

    regards
    Alvis


    22 Aug 201710:58AM Comment 5 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 22-08-2017 10:58 AM Time Taken: 3.00
    QA for product and Patch Releases
    Step 1 - Developer to system test changes until not issues are found - Alvis and Sanjay to sign off on System Test
    Step 2 - Product expert allocated by Consulting Manager for Product QA.
                   Consulting Manager to allocate resource
                   Consulting Manager to sign off on UAT and Generic Test

    STEP 1 - DETAILS OF QA can be entered in case comments. Summary to be maintained in the table below.

    Table 1 - Summarised list of issues

    Dear Alvis,

    I am logging a separate case for the issue faced while testing this, however, the original case has been passed.

    No

    Issue Description

    Resolved?

    1

    The Foreign Currency Transaction figure and the Foreign Currency Rate is not displayed correctly.

    PASS

    2

    The Foreign Currency Transaction figure and the Foreign Currency Rate is not displayed correctly.

    PASS

     


    1. Original case assigned to Development
    2. When the product is ready for release, System test details are entered into comments and the CASE HEADER Table updated.
    3. If system test passes, assign case to Consulting Manager for UAT
    4. If UAT Passes, Assign case for Documentation or close case

      09 Oct 201908:14AM Comment 6 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 Support@LinkTechnologies.com.au and include the Case No: L08718 in the subject line of all emails regarding this issue.

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