Build POS integration for JIWA inventory using the standard integration framework.

1. Design:

1. A scheduled process will import data from JIWA into LinkSOFT.
2. When JIWA inventory is ON, the user should not login to Link Backoffice. Changing any values in Backoffice may cause the integration to fail. 
3. Users using JIWA inventory will have zero user license for Link Backoffice.
4. No transactional data will flow from JIWA to LinkSOFT tables. As a result, transactional reports must be run from JIWA. Sales analysis reports will reflect transactions performed via POS screen.
5. The following Link POS reports can be used when JIWA integration is turned on:
   1. Shift Reports
   2. Banking report
   3. POS Sales Transactions audits
   4. Receipts and reprint.
6. Masterfile information will be integration as shown below.
7. The following master file data will be imported on a scheduled basis using a background process:
   1. Inventory
   2. Stock, lot bin
   3. Prices
   4. customers
   5. creditors
   6. locations

Figure 1 - Integration for LinkPOS / JIWA version 8.X

1. A scheduled process on LINKSOFT head office server will extract, create and maintain master records from JIWA.
2. There are 3 types of items in JIWA.
   1. Non-Physical Item - We do not check stock levels for this
   2. Physical Item - We do not check stock levels. We will set the allow negative to true in LinkSOFT which will send items to JIWA and create backordered sales order.
   3. Physical Item with Serial tracked. We refresh the LinkSOFT serial items on a preset interval. If the serial number is not available when the transaction flows into JIWA,
   4. Jiwa will place this item on backorder. This can happen when LinkSOFT has extracted serial item from JIWA and the serial item has been removed from JIWA.
   5. When serial items are added,edited,removed in JIWA the scheduled process will sync the data.
   6. All inventory reports will be generated from JIWA
3. Debtors master file will be copied into LinkSOFT.
   1. All debtor reports will be generated from JIWA.
4. Pricing
   1. When replication is in use, all branches will extract price information from LinkSOFT.
   2. Head Office LinkSOFT will always extract price information from JIWA.

   
   

Figure 3 - POS JIWA Integration for 9.4

1. Development completed. The following has been done:

1. Added Integration setup for InventoryMaster, ARMaster, TaxMaster in POS Web.
2. Added Process "POSFMISMasterImport" - FMIS Integration for POS Master File. This process extracts FMIS master file data and updates LINKSOFT master file (Inventory Master, Barcodes, Serial No, Locations, Debtors). This process will perform FMISImport and update LinkSOFT master file, therefore process FMISImport must be disabled before enabling this process.
3. Removed system process SYS009 and replaced with 3 processes "FMISAP, FMISAR, FMISGL"
4. POS Stations connected to the Head office Linksoft database will extract prices from ERP system's price matrix when an item is scanned in POS when integration "InventoryMaster" is enabled.
5. POS Stations connected to the Branch databases will use the LinkSOFT price structure.

2. Notes:

1. Inventory is extracted from JIWA and populates LinkSOFT standard tables based on scheduled process "POSFMISMasterImport"
2. JIWA inventory classification is mapped to LinKSOFT Posting accounts
3. JIWA inventory category 1 is mapped to LinkSOFT category
4. JIWA Inventory category 2 is mapped to LinkSOFT subcategory.
5. JIWA Inventory default item unit price is mapped to LinkSOFT product price quantity 1.

3. Integration Options:

1. If your bandwidth is sufficient and stable, all POS stations can connect directly to head office. The advantage of this is pricing is setup in JIWA only.
2. If bandwidth is insufficient, you need to use LinKSOFT replication for remote branches. In this case, integrate LinkSOFT head office with JIWA and setup replication with remote branches. It is important to 1.4 and 1.5 above.

System test completed.

Verified the following:

1. Configured LinkSOFT (using the new database) to use JIWA Inventory system.

1. APMasterSQL (UseLinkSOFTAPMaster = N)
2. ARAdjustmentSQL
   
3. ARMasterSQL (UseLinkSOFTARMaster = N)
   
4. ARReceiptSQL
   
5. ARSalesOrderSQL (UseLinksoftInventory=N, POSPartNoSubstitution=N, POSTransactionGroup=N)
   
6. GLJournalSQL
   
7. InventoryMasterSQL
   
8. TaxMasterSQL
   

1. POSFMISMasterImport
   
2. FMISAR
   
3. FMISGL
   

Hi Alvis, 

This case has been tested.

Test Environment

• Version 9400 Beta 2
• LINKSOFT Database - LINKSOFTNEW on QA1
• JIWA Database - JIWA 9235 on QA1
• OS - Windows 7.

Test Plan

Thanks

Rashna 

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

1. Resolved issue with returns to top up stock under inventory warehouse summary.
2. "Statement Discount on Invoice" is not a feature for JIWA POS integration. Use LinkSOFT standard discount feature to manage discounts given.

System test completed.

Verified processing returns in POS, adds quantity in JIWA Stock on hand screen.

regards

Alvis

This case has been successfully tested.

Test Environment

1. Version 9 Beta 3
2. Database - LINKSOFTNEW  and JIWA9235 on QA1
3. Application on QA1
4. OS - Windows 7.

Test Plan

Hi Sanjay, 

Documentation on the case has been updated.

Following menus have been updated:

• Integration -- Integration Settings - Integration Setup
• Integration -- Integration Settings - Linksoft Inventory and POS Integration 
  
• Integration -- Integration Settings - FMIS Inventory and POS Inetgration
  

Thanks

Rashna