Page History

2

System Localization Code: list ofSupported 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. 

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 code.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

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

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 ='';

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 `lastPrice` = '0.' , `averagePrice` = '0.00' , `currentLocalStock` = '0.00' , `currentLocalStockVolume` = '0.00' , `currentStockValue` = '0.00';  Must be done during commissioning before the training.