EHORS WINX CHECKLIST BEFORE GOING LIVE & TRAINING & V3 - WinX conversion

2

System Localization Code: list of supported code

System Localization Code: Property Settings Name:

This is the currency that appears in the GUI of FO also.

make sure to change the currency here. 

en-MY , en-PH, en-ID, ko-KR, en-US, en-AU

mUST BE DONE BY EHORS.

make sure that the taxes are there, if it's not there, check tblAccTaxServiceCharge maybe the country code is not updated

click edit and check if the service type is filled in (this must be done by the customer)

SELECT
A.itemCategoryName, 

-- GOOD RECEIVE COST ACCOUNT
B.accountLedgerType, 
costAccount.accountID AS accountIDCategoryCost,
costAccount.accountName AS accountIDCategoryCostName,

-- GOOD RECEIVE BALANCE ACCOUNT
C.accountLedgerType,
balAccount.accountID AS accountIDCategoryBal,
balAccount.accountName AS accountIDCategoryBalName,

-- GOOD DISTRUBATION COST ACCOUNT
D.accountLedgerType, 
distributionCostAccount.accountID AS accountIDDistributionCost,
distributionCostAccount.accountName AS accountIDDistributionCostName,

-- GOOD DISTRUBATION ALANCE ACCOUNT
E.accountLedgerType, 
distributionBalAccount.accountID AS accountIDDistributionBalance,
distributionBalAccount.accountName AS accountIDDistributionBalanceName,

-- WASTAGE COST ACCOUNT
F.accountLedgerType, 
wastage.accountID AS accountIDWastage,
wastage.accountName AS accountIDWastageName

FROM
  tblPurItemCategory AS A
  LEFT JOIN tblAccAccounts AS costAccount ON A.accountIDCategoryCost = costAccount.accountID
  LEFT JOIN tblAccAccounts AS balAccount ON A.accountIDCategoryBal = balAccount.accountID
  LEFT JOIN tblAccAccounts AS distributionCostAccount ON A.accountIDDistributionCost = distributionCostAccount.accountID
  LEFT JOIN tblAccAccounts AS distributionBalAccount ON A.accountIDDistributionBalance = distributionBalAccount.accountID
  LEFT JOIN tblAccAccounts AS wastage ON A.accountIDWastage = wastage.accountID
  
  LEFT JOIN tblAccAccountLedger B ON costAccount.accountLedgerID = B.accountLedgerID   
  LEFT JOIN tblAccAccountLedger C ON balAccount.accountLedgerID = C.accountLedgerID 
  LEFT JOIN tblAccAccountLedger D ON distributionCostAccount.accountLedgerID = D.accountLedgerID 
  LEFT JOIN tblAccAccountLedger E ON distributionBalAccount.accountLedgerID = E.accountLedgerID 
  LEFT JOIN tblAccAccountLedger F ON wastage.accountLedgerID = F.accountLedgerID 
   
WHERE A.active = 'y'
ORDER BY A.itemCategoryName;

make sure the linking is created. (Include default outlet Finance & FO in the linking)

Default outlet can be linked by ehors

have to teach the customer during the training. 

PARTNERS
SELECT * FROM tblSamAgency   GROUP BY agencyCountryID;  this is to see how many different countries need to be updated.

Then go back to their old property and check the ID with the correspondent country.

check tblAdmCountry in winx for the new value of the country ID based on the country name.

Example
OLD VALUE & New Value IN WINX
# 103 South Korea new value = EH116
# 52 phil, new = EH173
# 187, singapore new = EH196

#124, Malaysia New value = EH132

#71, Indonesia new value EH102

#94, China new value EH44

SAMPLE FOR ph
UPDATE `sampleproperty`.`tblSamAgency` SET `agencyCountryID` = 'EH173' WHERE agencyCountryID ='52'; 

The COA has defaults accounts which have not been linked, they need to be linked to ledger and account group

Supplier Management

Check if the countryID is correct based on current value of tblAdmCountry in winx. 

SELECT * FROM `tblPurSupplier`   GROUP BY countryID;

Update based on the current value

# 103 South Korea new value = EH116
# 52 phil, new = EH173
# 187, singapore new = EH196

#124, Malaysia New value = EH132

#71, Indonesia new value EH102

#94, China new value EH44

#219, New Zealand NEW VALUE EH157
#229 United States EH231
#77  Israel EH106

SAMPLE

UPDATE `sampleprop`.`tblPurSupplier` SET `countryID` = 'EH44'  WHERE countryID ='94';

item (NP/ML) set the purchase status based on the itemtype. SOme of them have blank purchase status

SELECT * FROM tblPurItem WHERE itemType ='inventory' AND purchaseStatus ='';

SELECT * FROM tblPurItem WHERE itemType ='asset' AND purchaseStatus ='';

Also check this SELECT * FROM tblPurItem WHERE itemType ='p&L' AND purchaseStatus ='NP';  - there should not be any result, otherwise have to check the item for the correct status & type

SELECT * FROM tblPurItem WHERE itemType ='P&L' AND purchaseStatus =''; this is tricky because some items are mixed meaning items related to inventory but tagged as P&L. So what I did here is I checked their old property and compare the purchaseStatus by categoryID.

 
Then update the following columns in tblPurItem, UPDATE `sampleProperty`.`tblPurItem` SET `averagePrice` = '0' , `currentLocalStock` = '0' , `currentLocalStockVolume` = '0' , `currentStockValue` = '0';
 Must be done during commissioning before the training.

check, there should not be an item without mst, you can check this by using the filter in the program, click the arrow up or down to sort. 

there should not be Asset item type & P&L purchase status, if there is, check the items and change the status or type accordingly.

there should not be p&L item type & NP purchase status, if there is, check the items and change the status or type accordingly.

check tblAccAccounts

 these are the old accounts 28 accounts.

SELECT * FROM tblAccAccounts WHERE accountID IN ('10','11','12','15','16','17','21','22','23','24','27','29','30','31','32','33','34','35','36','37','38','39','40','43','44','6','7','8');

SELECT * FROM tblAccAccounts WHERE accountID IN ('10','11','12','15','16','17','21','22','23','24','27','29','30','31','32','33','34','35','36','37','38','39','40','43','44','6','7','8') AND ACTIVE='y';

database

COA Managament

Outlet Owner

SELECT * FROM `tblAdmOutletOwner`   GROUP BY countryID; 

Update based on the current value

# 103 South Korea new value = EH116
# 52 phil, new = EH173
# 187, singapore new = EH196

#124, Malaysia New value = EH132

#71, Indonesia new value EH102

#94, China new value EH44

existing data must be copied during the conversion, check if data is there. (recipe & barcode)

Unless the customer is not using retail.

TAX LINKING - check the ff records in winx and v3 db

Tax Linking
Accommodation
Winx
SELECT * FROM tblAccAccommodationMiscCharge WHERE ACTIVE='y';
V3-can't use active because no active field in v3
SELECT * FROM tblAccommodationMiscCharge WHERE accommodationID!='';

Item
Winx
SELECT * FROM tblAccItemMiscCharge WHERE ACTIVE='y';
V3
SELECT * FROM tblFbItemMiscCharge WHERE ACTIVE='y';

Recipe
Winx
SELECT * FROM tblAccRecipeMiscCharge WHERE ACTIVE='y';
V3
SELECT * FROM tblFbRecipeMiscCharge WHERE ACTIVE='y';

BDI
Winx
SELECT * FROM tblAccBDIMiscCharge WHERE ACTIVE='y';
v3
SELECT * FROM tblBDIMiscCharge WHERE BDIID!='';

Department Item Linking
Winx
SELECT * FROM tblPurItemDepartment WHERE ACTIVE='';
v3
SELECT * FROM tblFbDepartmentItem WHERE ACTIVE='y';

Item Supplier Linking
Winx
SELECT * FROM tblPurItemSupplier WHERE ACTIVE='y';
v3
SELECT * FROM tblFbItemSupplier WHERE ACTIVE='y';