Company: Link Technologies
Case No: L11943. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 08 Apr 2020 01:52PM
Priority: Medium
Product: Point of Sale
Group: Software Defect
Time Taken: 6.00 (Weight: 6.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Tuesday, 28 April 2020 05:37 PM [1472 days since logged date]
Status: Closed
Subject: "Purchase Order Post to FMIS" creates duplicate GL Journals when the "AP Invoice" integration is turned off.
Summary:    

When a Purchase Order is posted from menu 577,following integration views are created:

  1. General Journal
  2. AP Invoice

Thus the following should be enabled under Integration:

  1. AccountsPayableInvoice
  2. GeneralLedgerJournal

The below was done:

  1. I enabled the integration for "General Ledger Journal".
  2. Created and received a purchase order from Backoffice.
  3. Posted the purchase order to FMIs from menu 577 in Backoffice.
    1. The message read "Transaction Posted". This created the journal entry, however, the purchase order was not removed from menu 577. I was able to tick and post again which created the duplicate entry. Refer to Figure 1.
The PO was only posted and removed from menu 577 when I enabled "Accounts Payable Invoice".

We need to modify this to avoid duplicates.

Test Environment

  • JIWA Database - JIWA11895
  • Link Database - LINKSOFT-JIWA7
  • Server - 10.0.0.14

Figure 1: Duplicate Gl Journals

Audit Notes:Edited by alvis on 10/02/21 16:57. Edited by rashna on 28/04/20 16:51. Edited by sanjay on 16/04/20 10:05. 
08 Apr 202002:44PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-04-2020 04:35 PM Time Taken: 1.00

Development work for this case has been completed.

The change will be available in version:11.5.0408

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

  1. Changed Purchase order Post to AP to check both "AP Invoice" and "GL Journal" is enabled before posting.

2. Affected Areas:

  1. Purchase order Post to AP

3. The issue was caused by:

  1. Improvement

4. Notes: 
5. Next Step: UAT


24 Apr 202003:44PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-04-2020 05:37 PM Time Taken: 4.00
Hi Rashna, System test completed. Please perform UAT in V11.5.0424.

28 Apr 202004:51PM Comment 3 by Rashna (Edge Business Solutions) ETC was changed from 08/04/2020 to 28/04/2020
29 Apr 202009:30AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-04-2020 11:23 AM Time Taken: 1.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Setup integration with JIWA 7 and LinkSOFT. Enable following integration rules.

  • GL Journal 
  • GL Master
  • AP Master
Pass
2

Create and POST a purchase order to FMIS.

The integration should not integrate the PO.

Pass.
3

Enable AP Invoice. This should create the 

  • AP Invoice View
  • GL Journal View.

There should be any duplicates

Pass

Environment Details

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

Next Step: 

  1. Closure

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

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