Change Request

Need replication rule that allows Inventory list to be sent from HQ to all sites. 

1. Branches need to be able to review the stock level of a particular branch before making a transfer request.
2. Branches need to be able to review the stock level before referring customer to their different location. Eg: A Spare parts company has 2 locations, A and B. Customer comes to buy spark plug for tyota belta at location A. If location A does not have it in stock, they should be able to check if it exists in Location B and either refer customer to visit location B or arrange for location B to deliver to location A for pickup. 
3. No need to send any transactions such as sales, adjustments, stock take and Purchases across.
4. Owner can easily verify last cost of purchase for each location for either of the location not necessarily from HQ.

Development Meeting: 19/04/2018

Vineet to setup this environment on QA4 so we can understand how best to resolve this.

The following changes will be made:

1. Remove Rule R1100 as Data flowing into HQ needs to be sent to the OUT Queue. Rules will determine what data in the OUT Queue will be transmitted.
2. Treat Inventory List as Masterfile information
3. Create Rule R1130 - Send Masterfiles and Transactions from Headoffice to configured BRANCH/Locations
4. Create Rule R1140 - Send Masterfiles from Headoffice to configured BRANCH/Locations
5. If a location is not configured for a branch, do not send location data related data.

We will address customer-specific needs after this change is made.

The following changes have been made:

1. Changed rule R1100 description to "Synchronize data to all SERVERS (Active rules restrict data transmitted to BRANCH servers)". This rule is not editable.
2. Changed rule R1081 description to "Do NOT send customer Masterfile data to BRANCH (Rule R1130 must be ACTIVE for this rule R1081 to be ACTIVE)"
   Masterfile Data:
   - Customer Maintenance
   - Fleet Maintenance
   - Customer Notes
3. Changed rule R1130 description to "Restrict transactional data transmitted to BRANCH by configured server locations."
   Transactional Data:
   - Inventory Adjustments
   - Stocktake
   - Transfer (Request, Ship & Receive)
   - Purchase Order
   - POS Sales & Payments
4. Added new rule R1140 "Restrict Masterfile data transmitted to BRANCH by configured server locations."
   Masterfile Data:
   - Inventory List
   - Location Price
   

System test completed.

Verified the following:

1. Configured replication between HQ and branches (B1 - Retail Location, B2 - Wholesale Location).
2. In HQ environment, enable the rule R1130 "Restrict transactional data transmitted to BRANCH by configured server locations." and made changes to product master retail location.
3. Verified data flowed to B1 server only.
4. In HQ environment, disabled the rule R1130 "Restrict transactional data transmitted to BRANCH by configured server locations." and made changes to product master retail location.
5. Verified data flowed to both B1 and B2 servers.

Hi Sanjay, 

I have successfully tested the case.

Documentation has been updated on the case.

• POS - WEB - Replication - Rules

Test Environment

• Version
• HQ - LINKSOFTHQ on QA1
• Branch 1 - LINKSOFTB1 on QA1
• Branch 2 - LINKSOFTB2 on QA4

Attached is the test plan.