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: - The Foreign Currency Transaction figure and the Foreign Currency Rate is not displayed correctly.
- 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: - Setup “BUY” currency as:
- Currency From: AUD
- Currency To: FJD
- Rate: 2.00
- Created PO - LTPO000004. [Refer to image 1]
- Posted this PO with the supplier reference as “Supplier Ref: REC06”.
- When the Creditor Purchase is created in JIWA, the “Foreign Currency Trans.”, and “Foreign Currency Rate” is updated incorrectly. [Refer to image 1]
- 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; - 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.
- 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 2017 | 10:43AM Comment 1 by Alvis (Link Technologies) Case 8718 added to project 8.17 |
18 Aug 2017 | 03: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):| - Requested changes have been completed.
|
|
22 Aug 2017 | 09: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: - The local currency is AUD.
- Setup buy currency: FJD TO AUD = 2.00
- Created supplier "Aarti" and setup currency as "FJD"
- Created PO LTPO000022, this was received as $0.00
- 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 2017 | 10: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 2017 | 10: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 |
- Original case assigned to Development
- When the product is ready for release, System test details are entered into comments and the CASE HEADER Table updated.
- If system test passes, assign case to Consulting Manager for UAT
- If UAT Passes, Assign case for Documentation or close case
|
|
09 Oct 2019 | 08: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 |