Company: Link Technologies
Case No: L12928. Project: 14.90: LinkSOFT Version 14.90 - July 2023
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 24 Jul 2023 01:17PM
Priority: Medium
Product: FMIS (Jiwa/Epicor/etc)
Group: Software Defect
Time Taken: 26.00 (Weight: 1.00)
Version: 14.90.0829
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Sanjay, Sheelta Kumar, Vineshwar Prasad
Resolve By: Thursday, 10 August 2023 09:08 AM [268 days since logged date]
Status: Closed
Subject: Purchase Order appears with multiple lines on Creditor Purchase and Payment form
Summary:    
1. Problem Details

Purchase Order is integrating from LinkSOFT to Jiwa with multiple lines. Processing Payment becomes difficult as Invoices appear multiple times in the Payment Processing form.

2. Error Message (screenshot of the error) - attached due to size restriction
  1. Image 1 - Purchase Order / Creditor Purchase with 1 line entry [LTPO018741] - Before Upgrade
  2. Image 2 - Purchase Order / Creditor Purchase with multiple line entry [LTPO019437] - After Upgrade
  3. Image 3 - Creditor Listing for [LTPO019437] - Inv# WS23-4381 appearing with multiple lines
3. Environment Details
  1. LinkSOFT Version - 14.90.230621.GA
  2. Jiwa Version - 07.02.01

4. Additional Notes

  1. In version 10.155, When we had Multiple Purchase Receipts, the system created a single line Purchase Invoice in JIWA
  2. The "Integration AP Invoice" was grouped by POS NUM, Receiving No. and Supplier Reference No.
Audit Notes:Edited by sanjay on 14/08/23 15:33. Edited by sanjay on 07/08/23 16:11. Edited by sanjay on 07/08/23 15:47. Edited by sanjay on 07/08/23 15:33. Edited by sanjay on 26/07/23 16:36. 
24 Jul 202307:46AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 28-07-2023 07:29 AM Time Taken: 1.00 Notes: ETC extended from: 24/07/2023 to 28/07/2023
Hi Sheelta,

We have reproduced the issue in the copy of your Database in our test environment internally.
  1. Creditor Purchase with 1 line entry - LTPO018741
  2. Creditor Purchase with multiple line entry - LTPO018929
We will get our technical team to diagnose further and advise.

Regards
Vineshwar Prasad

24 Jul 202301:17PM Comment 2 by Sanjay (Link Technologies) Case L12928 added to project 15.00
26 Jul 202307:17PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-07-2023 04:36 PM Time Taken: 16.00 Notes: ETC extended from: 24/07/2023 to 28/07/2023
PART A - Development work for this case has been completed.

1. The change will be available in versions: 15.00 and 14.90.230726 Patch

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

  1. Added grouping to Creditor Invoice by Grouping by GL Accounts and Tax Codes
  2. Added Line Extension to Supplier Invoice Number as we can create Multiple Lines per Invoice if the "Tax Code" or GL Codes are different.
  3. Changed the Order in the Purchase Receive Detail Display to Invoice Number

3. Affected Areas:

  1. FMIS Integration from Purchase Receipts to Creditor Invoice

4. The issue was caused by:

  1. Return old functionality

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


27 Jul 202310:43AM Comment 4 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 02-08-2023 10:27 AM Time Taken: 2.00
The following tests were performed:

Test Setup Instructions:
  1. Created Purchase Orders with multiple Tax Codes and lines [LTPO018947]
  2. Purchase Order Integrated and grouped by Tax Code
Image 1: Purchase Order with multiple Tax Code


Image 2: Purchase Order Integrated and grouped with multiple lines

Environment Details

  1. OS version: Win 10 Pro
  2. Application version: 14.90.230621.GA
  3. Setup on:
    1. Server: LinkQA4\CP1
    2. Database: CLIENT-FoodCity-LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA1-EBS/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


28 Jul 202307:59AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-08-2023 07:58 AM Time Taken: 2.00 Notes: ETC extended from: 28/07/2023 to 02/08/2023
Morning Vineshwar, Patch is available at this link:
https://www.linktechnologies.com.au/ftp/LinkSOFT_Patch/LinkSOFT_14.90.230728.zip
You can apply just the SQL PATCH.SQL script instead of running the DBUpdate

07 Aug 202303:33PM Comment 6 by Sanjay (Link Technologies) Case L12928 added to project 14.90
07 Aug 202303:47PM Comment 7 by Sanjay (Link Technologies) ETC was changed from 02/08/2023 to 31/08/2023
08 Aug 202310:04AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-08-2023 09:08 AM Time Taken: 5.00 Notes: ETC extended from: 31/08/2023 to 10/08/2023
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create a PO and Receive multiple items with different Tax Codes
FMIS Creditor invoice grouped by TAX CODE and GL Accounts
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.90
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12928 in the subject line of all emails regarding this issue.

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