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. - Posting accounts from Linksoft needs to be created as Inventory Items in Jiwa
- Supplier details from Link needs to be created in Creditor Maintenance in Jiwa
- Tax details in Link has to be under Tax Maintenance in Jiwa
- Customers from LinkPOS has to be recreated in Jiwa under Debtor Maintenance.
- Returns reasons in Linksoft has to be created under credit reasons in Jiwa
- Payment methods in Linksoft has to be created as Payment types in Jiwa
- 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: - Why do users have to recreate the master details as this was a feature in the previous versions.
- This will be the cause for most mismatch and XXXXX will have to place in additional resource for monitoring now.
- 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 - 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 2018 | 10: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: - 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.
- 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".
- 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 - Posting accounts in Linksoft needs to be created as Classifications in JIWA
- Tax details in Link has to be under Tax Maintenance in Jiwa
- Returns reasons in Linksoft has to be created under credit reasons in Jiwa
- Payment methods in Linksoft has to be created as Payment types in Jiwa
- Currency in Linksoft needs to be recreated under currencies in Jiwa.
|
|
19 Apr 2018 | 10:42AM Comment 2 by Sanjay (Link Technologies) Case 9259 added to project 09.4 |
27 Apr 2018 | 10: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: - Create 1 JIWA inventory item for each different posting account
The design will be as follows: A. Add integration for: - 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".
- 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 - Posting accounts in Linksoft need to be created as a product in JIWA
- Tax details in Link have to be created in JIWA
- Returns reasons in Linksoft has to be created for credit reasons in Jiwa
- Payment methods in Linksoft have to be created as Payment types in Jiwa
- Currency in Linksoft needs to be recreated under currencies in Jiwa.
|
|
27 Apr 2018 | 04: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):| - Added flag to ARMasterSQL named "AR Master is maintained in LinkSOFT".
- Added flag APMasterSQL named "AP Master is maintained in LinkSOFT".
- When these flags are set to Yes, Customers and suppliers from LinkSOFT will be created in JIWA.
2. The issue was caused by: - N/A
3. Next Step - UAT
|
|
02 May 2018 | 09: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: - Configured LinKPOS integration to JIWA using LinkSOFT Inventory system.
- Enabled the following integration processes:
- APMasterSQL
- "Accounts Payable Master is maintained in LinkSOFT" = Yes
- ARMasterSQL
- "Accounts Receivable Master is maintained in LinkSOFT" = Yes
Verified the following processes where enabled:- 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.- The following mapping is used to map supplier from LinkSOFT to JIWA:
LinkSOFT | JIWA | Supplier Code | Account No | Name | Name | Address 1 | Address 1 | Address 2 | Address 2 | City | Suburb | State | State | Country | Country | Contact Phone | Phone No | Email | Email | TIN | ABN | Default Currency | Foreign Currency (when default currency is different to JIWA local currency) | Void | Trading Status |
Created a new customer in Link POS. After process POSFMISMasterImport was executed, verified debtor created in JIWA.- The following mapping is used to map customer from LinkSOFT to JIWA:
LinkSOFT | JIWA | Customer Code | Account No | Name | Name | Street No | Address 1 | Street Name | Address 2 | City/Suburb | Suburb | State | State | Post Code | Post Code | Home Phone | Phone No | Email | Email | Credit Limit | Credit Limit | Tax File Number | ABN (Added this in beta 2) | Customer Type -> No New Business | Trading Status |
|
|
08 May 2018 | 10: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 Plan | Description | Status | 1 | Create a Customer as "Peter Singh" at head office. The details of the customer should be updated in JIWA under Debtor | Pass | 2 | 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 | 3 | Edit the phone number for Patel and this should be updated in JIWA. | Pass | 4 | Create a Supplier as "S001" at head office. The details of the customer should be updated in JIWA under Debtor
| Pass | 5 | Create a Customer as "S002" from Branch 1. The details of the customer should replicate to HQ and record should be created in JIWA
| Pass | 6 | Edit 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 2018 | 11: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 2018 | 11: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 2018 | 12: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 - 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 2018 | 02:53PM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-05-2018 02:53 PM |
| Thanks Rashna. |
|
09 Oct 2019 | 08: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 |