Company: Link Technologies
Case No: L09259. Project: 09.40: LinkSOFT Version 9.4
Logged By: Vineet (Link Business Solutions) on 19 Apr 2018 10:39AM
Priority: High
Product: Point of Sale
Group: Change Request
Time Taken: 11.00 (Weight: 11.00)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, AwaitingApproval, Development, Rashna, Sanjay, Vineet
Resolve By: Friday, 20 April 2018 12:00 AM [2198 days since logged date]
Status: Closed
Subject: Master Files Creation in Jiwa for POS Integration
Summary:    

Current Functionality:

After the new API integration of Jiwa POS and Linksoft, the below master details has to be manually created in Jiwa.

  1. Posting accounts from Linksoft needs to be created as Inventory Items in Jiwa
  2. Supplier details from Link needs to be created in Creditor Maintenance in Jiwa
  3. Tax details in Link has to be under Tax Maintenance in Jiwa
  4. Customers from LinkPOS has to be recreated in Jiwa under Debtor Maintenance.
  5. Returns reasons in Linksoft has to be created under credit reasons in Jiwa
  6. Payment methods in Linksoft has to be created as Payment types in Jiwa
  7. Currency in Linksoft needs to be recreated under currencies in Jiwa.
A UAT for this was done with the XXXXX team and below were the remarks recorded:
  1. Why do users have to recreate the master details as this was a feature in the previous versions.
  2. This will be the cause for most mismatch and XXXXX will have to place in additional resource for monitoring now.
  3. XXXXX has mentioned that they have been wanting the system to auto insert and activate in Jiwa as well but seems like we are going backwards as oppose to forward.
New Functionality
  1. Maintenance to be auto created as before specially the Customers and Suppliers. For POSCASH by month customer, we agreed to create at the next 3 years POSCASH codes.
Audit Notes:
19 Apr 201810:41AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-04-2018 10:41 AM

Agreed to  make the following changes to the API

A. Add integration for:

  1. Inventory Masterfile from Link to be created in Inventory in Jiwa. Add a Flag on the existing Inventory Integration named "Inventory is maintained in LinkSOFT". This will determine if we PULL or PUSH inventory data.  Classifications will be created from LinkSOFT POSTING Code as part of this integration. 
  2. Supplier details from Link to be created in Creditor Maintenance in Jiwa. Add a Flag on the existing APMaster Integration named "AP Master is maintained in LinkSOFT".
  3. Customers from LinkPOS has to be recreated in Jiwa under Debtor Maintenance. Add a Flag on the existing ARMaster Integration named "AR Master is maintained in LinkSOFT".

B. The following items will remain as Manual Setup

  1. Posting accounts in Linksoft needs to be created as Classifications in JIWA
  2. Tax details in Link has to be under Tax Maintenance in Jiwa
  3. Returns reasons in Linksoft has to be created under credit reasons in Jiwa
  4. Payment methods in Linksoft has to be created as Payment types in Jiwa
  5. Currency in Linksoft needs to be recreated under currencies in Jiwa.

19 Apr 201810:42AM Comment 2 by Sanjay (Link Technologies) Case 9259 added to project 09.4
27 Apr 201810:00AM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 27-04-2018 10:00 AM Time Taken: 1.00

LinkSOFT inventory has posting accounts at location level and therefore 1 item will need to have multiple JIWA items to handle this. If a client is using LinKSOFT inventory, JIWA inventory maintenance will not be required, therefore we can continue the current design:

  1. Create 1 JIWA inventory item for each different posting account
The design will be as follows:

A. Add integration for:

  1. Supplier details from Link to be created in Creditor Maintenance in Jiwa. Add a Flag on the existing APMaster Integration named "AP Master is maintained in LinkSOFT".
  2. Customers from LinkPOS has to be recreated in Jiwa under Debtor Maintenance. Add a Flag on the existing ARMaster Integration named "AR Master is maintained in LinkSOFT".

B. The following items will remain as Manual Setup

  1. Posting accounts in Linksoft need to be created  as a product in JIWA
  2. Tax details in Link have to be created in JIWA
  3. Returns reasons in Linksoft has to be created for credit reasons in Jiwa
  4. Payment methods in Linksoft have to be created as Payment types in Jiwa
  5. Currency in Linksoft needs to be recreated under currencies in Jiwa.

27 Apr 201804:25PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-04-2018 04:25 PM Time Taken: 4.00
Development work for this case has been completed.
The change will be available in version: 9.4

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

  1. Added flag to ARMasterSQL named "AR Master is maintained in LinkSOFT".
  2. Added flag APMasterSQL named "AP Master is maintained in LinkSOFT".
  3. When these flags are set to Yes, Customers and suppliers from LinkSOFT will be created in JIWA.

2. The issue was caused by:

  1. N/A

    3. Next Step

    1. UAT

    02 May 201809:06AM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 02-05-2018 09:06 AM Time Taken: 1.00

    System test completed.

    Verified the following:

    1. Configured LinKPOS integration to JIWA using LinkSOFT Inventory system.
    2. Enabled the following integration processes:
    1. APMasterSQL
      1. "Accounts Payable Master is maintained in LinkSOFT" = Yes
    2. ARMasterSQL
      1. "Accounts Receivable Master is maintained in LinkSOFT" = Yes
    Verified the following processes where enabled:
    1. POSFMISMasterImport - Used by APMasterSQL and ARMasterSQL to synchronize customer and supplier master file to JIWA
    Created a new supplier in Link Backoffice. After process POSFMISMasterImport was executed, verified creditor created in JIWA.
    1. The following mapping is used to map supplier from LinkSOFT to JIWA:
      LinkSOFTJIWA
      Supplier CodeAccount No
      NameName
      Address 1Address 1
      Address 2Address 2
      CitySuburb
      StateState
      CountryCountry
      Contact PhonePhone No
      EmailEmail
      TINABN
      Default CurrencyForeign Currency (when default currency is different to JIWA local currency)
      VoidTrading Status
    Created a new customer in Link POS. After process POSFMISMasterImport was executed, verified debtor created in JIWA.
    1. The following mapping is used to map customer from LinkSOFT to JIWA:
      LinkSOFTJIWA
      Customer CodeAccount No
      NameName
      Street NoAddress 1
      Street NameAddress 2
      City/SuburbSuburb
      StateState
      Post CodePost Code
      Home PhonePhone No
      EmailEmail
      Credit LimitCredit Limit
      Tax File NumberABN (Added this in beta 2)
      Customer Type -> No New BusinessTrading Status


    08 May 201810:41AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 09-05-2018 12:00 AM Time Taken: 2.00

    Hi Alvis, 

    This case has bee tested.

    Documentation has been updated on the case. Updated below areas

    • Point of Sale - WEB - Administration - Processes
    • Backoffice -- Purchasing Maintenance - Supplier
    • Point of Sale -- Maintenance -- Customer

    Test Plan

    Test PlanDescriptionStatus
    1Create a Customer as "Peter Singh" at head office. The details of the customer should be updated in JIWA under DebtorPass
    Create a Customer as "Patel" from Branch 1. The details of the customer should replicate to HQ and record should be created in JIWA
    Pass
    3Edit the phone number for Patel and this should be updated in JIWA.Pass
    4Create a Supplier as "S001" at head office. The details of the customer should be updated in JIWA under Debtor
    Pass
    5Create a Customer as "S002" from Branch 1. The details of the customer should replicate to HQ and record should be created in JIWA
    Pass
    6Edit the phone number for S002 and this should be updated in JIWA.
    Pass

    Note: Case will be retested in Beta 2, as the Customer TIN number is not updated in JIWA.

    Thanks

    Rashna 


    08 May 201811:35AM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 08-05-2018 11:35 AM Time Taken: 1.00
    UAT in beta2.

    09 May 201811:29AM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 11:29 AM Time Taken: 1.00

    System test completed.

    Tax file number for customer was successfully mapped to Debtor ABN.


    10 May 201812:58PM Comment 9 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 11-05-2018 12:00 AM Time Taken: 1.00

    Hi Sanjay, 

    This has been successfully tested.

    Documentation on the case has been updated. Documentation updated under

    • Point of Sale - WEB - Administration - Processes
    • Integration -- Integration Setup.

    Test Environment

    • Version 9400 Beta 2
    • Database - LINKSOFTINT on QA1
    • Application on QA1
    • OS - Windows 7

    Test Plan

    1. Create a Customer "Laleen", set the TIN number in POS as "12-56398-2-3". This should be successfully updated under the "Credit Tab" for the debtor in JIWA - Pass

    11 May 201802:53PM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-05-2018 02:53 PM
    Thanks Rashna. 

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

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