No | Description | Program Group/Program | Remarks | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Check and set up all the currencies | Currency Management | must be added by the customer | |||||||||
2 | Check and set up All the settings under property management | Property Management | ||||||||||
3 | Check the Outlet | outlet setting | ||||||||||
4 | check the payment authorization | accounts payable | this must be check and set by customer | |||||||||
5 | employee program | employee management | User must change their password based on the current criteria of winx | |||||||||
6 | outlet authorization | employee authorization | must be done by customer | |||||||||
7 | payment method link | Coa Management | ehors can create the basic like (Bank, Cash, Cheque, Voucher), the rest must be done by customer DOUBLE CHECK THE CHEQUE CLEARING ACCOUNT, SOMETIMES IT;S DOUBLE IN THE RECORD, DELETE THE NON DEFAULT ACC. | |||||||||
8 | purchase authorization | purchase management | this must be check and set by customer | |||||||||
9 | property auth | employee authorization10 | to start, ehors must be authorized. This will be discussed during training. | |||||||||
10 | System Localization Code: list ofSupported of supported code
| Admin & System | ||||||||||
11 | Tax & Sc Linking | coa management | check the linking - | |||||||||
12 | taxes country code | coa management | 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) | 13 | revenue account link | coa management | 14 | purchase account link | coa management | |||
15 | stock location management | item management | make sure everything has value especially the new field | 16 | outlets Pos set up | Pos program | 17 | Check the payment processing if the payment methods appear in the dropdown | Accounts payable | |||
18 | payment class link | property management | make sure the linking is created. (Include default outlet Finance & FO in the linking) | 19 | If the Live database is copied to the training site, always pay attention to the IP address of the kitchen printer when doing POS this might affect operation the same applies to the supplier emails, the supplier might deliver the goods. Please set the supplier email to one of the email addresses of the purchasing in train site. | 20 | Discount Link | Coa Management | 21 | Discount Management | Revenue management | 22 | Designation program Template | employee management |
23 | PAYMENT METHOD ACCOUNT USED | coa management | set the account to selectable yes or no | 24 | PARTNERSPartner Management | Check if the country is not null, | ||||||
25. | Property Settings | Admin & System | Check the settings by module, focus on the blue ones, it means that those fields have no value yet. | |||||||||
26. | The COA has defaults accounts which have not been linked, they need to be linked to ledger and account group | coa management | when you open account management and click edit, unlinked accounts will be populated | |||||||||
27. | The default outlets FO, Fin, BQ, TP need to be linked to department | outlet management | use the edit function in outlet management where department is blank. | 28. | Supplier Management | Check if the suppliers are copied from v3 to winx. If it's existing customer only. | ||||||
29 | Item Measurements | Item Measurements | Check if the item measurements are copied from v3 to winx | |||||||||
30 | Venue | Function Rooms | Check if the venues are copied from v3 to winx | 31 | Rate Code Group | COA MANAGEMENT | 32 | Check the forms if they exist (REGISTRATION FORM, PO FORMAT, TAX INVOICE, REGISTRATION FORM (PROFORMA) EVENT ORDER, FO TAX INVOICE) | Check in the train site only. Compare the result with their format in V3. | 33 | 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. | Inventory Management |
34 | check the tblAccAccounts, column opening balance | database | should be zero during commissioning | |||||||||
35 | check tblAccRateCodeGroup | database | check if there's a status for active=y | |||||||||
36 | check tblAccAccounts Delete the old accounts, these are the old 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') | database | check default acct v3 vs winx (set active n and retain active y for winx) | |||||||||
37 | Segment Source Link | Sales & marketing | Ehors only check if the linking has been done - this must be redone by the customer. | |||||||||
38 | Market SOurce | Sales & marketing | check if the sources are copied, if not ask AlexAdmin & System | 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. mUST BE DONE BY EHORS. | ||||||||
11 | Tax & Sc Linking | coa management | check the linking because some of them have blank service type. | |||||||||
12 | taxes country code | coa management | 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) | |||||||||
13 | revenue account link | coa management | ||||||||||
14 | purchase account link Run this query and prepare the list highlights the ones that needed to be redone by customer so easy for them to see. SELECT -- GOOD RECEIVE COST ACCOUNT -- GOOD RECEIVE BALANCE ACCOUNT -- GOOD DISTRUBATION COST ACCOUNT -- GOOD DISTRUBATION ALANCE ACCOUNT -- WASTAGE COST ACCOUNT FROM | coa management | check and make the list of category that has incorrect linking. In the new winx linking is blank if the sleected account for Balance is PL | |||||||||
15 | stock location management | item management | make sure everything has value especially the new field, check if the default stock location -1, stockLocationDescription name is (Uncleared POS Used) is there, That location have to be linked to outlet EHORS -002 FIN EHORS-002 FIN | |||||||||
16 | outlets Pos set up | Pos program | ||||||||||
17 | Check the payment processing if the payment methods appear in the dropdown | Accounts payable | ehors have to check | |||||||||
18 | payment class link | property management | 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. | |||||||||
19 | If the Live database is copied to the training site, always pay attention to the IP address of the kitchen printer when doing POS this might affect operation the same applies to the supplier emails, the supplier might deliver the goods. Please set the supplier email to one of the email addresses of the purchasing in train site. | ehors have to check this | ||||||||||
20 | Discount Link | Coa Management | this will be done by the customer | |||||||||
21 | Discount Management | Revenue management | This will discuss during the training - customer | |||||||||
22 | Designation program Template | employee management | assign all programs to ehors support position, the rest must be edited by the customer. | |||||||||
23 | PAYMENT METHOD ACCOUNT USED | coa management | set the account to selectable yes or no | |||||||||
24 | PARTNERS 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 #124, Malaysia New value = EH132 #71, Indonesia new value EH102 #94, China new value EH44 SAMPLE FOR ph | Partner Management | Check if the country is not null, | |||||||||
25. | Property Settings | Admin & System | Check the settings by module, focus on the blue ones, it means that those fields have no value yet. | |||||||||
26. | The COA has defaults accounts which have not been linked, they need to be linked to ledger and account group | coa management | when you open account management and click edit, unlinked accounts will be populated | |||||||||
27. | The default outlets FO, Fin, BQ, TP need to be linked to department | outlet management | use the edit function in outlet management where department is blank. | |||||||||
28. | 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 #124, Malaysia New value = EH132 #71, Indonesia new value EH102 #94, China new value EH44 #219, New Zealand NEW VALUE EH157 SAMPLE UPDATE `sampleprop`.`tblPurSupplier` SET `countryID` = 'EH44' WHERE countryID ='94'; | Supplier Management | Check if the suppliers are copied from v3 to winx. If it's existing customer only. | |||||||||
29 | Item Measurements | Item Measurements | Check if the item measurements are copied from v3 to winx | |||||||||
30 | Venue | Function Type & Configuration Type & Function Rooms | Check if the venues are copied from v3 to winx. Compare the list in the new winx to old. | |||||||||
31 | Rate Code Group | COA MANAGEMENT | check if there's a status for active=y, set to active =n, the one that belongs to V3. | |||||||||
32 | Check the forms if they exist (REGISTRATION FORM, PO FORMAT, TAX INVOICE, REGISTRATION FORM (PROFORMA) EVENT ORDER, FO TAX INVOICE) | Check in the train site only. Compare the result with their format in V3. | ||||||||||
33 | 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. | Inventory Management | 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. | |||||||||
34 | check the tblAccAccounts, column opening balance | database | should be zero during commissioning | |||||||||
35 | check tblAccRateCodeGroup | database | check if there's a status for active=y | |||||||||
36 | 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 | check default acct v3 vs winx (set active n and retain active y for winx) | |||||||||
37 | Segment Source Link | Sales & marketing | Ehors only check if the linking has been done - this must be redone by the customer. | |||||||||
38 | Market SOurce | Sales & marketing | check if the sources are copied, if not ask Alex | |||||||||
39 | Outlet Owner SELECT * FROM `tblAdmOutletOwner` GROUP BY countryID; Update based on the current value # 103 South Korea new value = EH116 #124, Malaysia New value = EH132 #71, Indonesia new value EH102 #94, China new value EH44 | Admin & System | check if the country s blank. | |||||||||
40 | Recipe Type | Food Beverage | Click the edit button for each recipe type and edit the recipe type code. Compare from old. | |||||||||
41 | Retail Price & Barcode | Point of sales | existing data must be copied during the conversion, check if data is there. (recipe & barcode) Unless the customer is not using retail. | |||||||||
42 | During Switch, set the prefix and the last invoice number of v3 in winx so that the invoice number will remain in sequence. This is not tblPK, this is no longer in use. The table is tblAccDocPrefix | |||||||||||
43 | SITEMINDER | Please take note before I forget again... For conversion planning please add in SiteMinder check on existsinf linkage. In this case of OFPPI because local need to off and migrate / format, the MySQL database cannot be access anymore, thus the reservatiuon push from SiteMinder will mark as undelivered and I'll have to manually push the booking again 1 by 1. In this case not much 78 booking, about 1-2 minutes per push manually. Thus if for next migration, please please check with me first if SiteMinder need to plan to move to another domain before shutting down for formatting | ||||||||||
44 | During commissioning these tables should just be empty. If it;s not empty and the customer went live already, set the old records to active 'no'. tblPosMenuPerOutlet, tblPosMenuPerOutletDetails, TblPosMenuOutletPrinter tblSetMenu TblSetMenuCourse TblSetMenuCoursedetail TblPosMaps TblPosTable | |||||||||||
45 | TAX LINKING - check the ff records in winx and v3 db Tax Linking Item Recipe BDI Department Item Linking Item Supplier Linking | compare the records with v3, if v3 is higher that is okay. Meaning they have done some linking after the conversion, but if winx has lower records than v3 then you have to report to Alex. Specify the table names. | ||||||||||