Difference between revisions of "Thai Localisation Project"

Latest revision as of 21:13, 3 July 2012

Headline text

AUTHOR: Kittiu

COMPANY: ecosoft

Instructions for Adempiere version 3.6.0lts

Overview of Features from this project

Localisation is an important need for implementing ERP in Thailand. In addition to Thai translation, there are certain features that is quite different from the use in other countries. The functionalities to be include in this project will include but not limited to

• Localised Chart of Accounts
• Localised Language of Translation
• Localised Extension for Thai Partial Withholding Tax
• Localised Billing feature
• Localised Taxation
• Localised City and Region Location Table (In Progress)

Download Source Codes

This section contain all the source code that I did for this project. Everyone are free to download, explore and even enhance. This is by no mean the best solution for Thailand, but mere the result of a project implemented in Thailand by EcoSoft.

1. Thai Localisation and extension for Partial Withholding Tax (Download)
   • Source Codes
   • Language Pack th_TH
   • Sample Chart of Account - CoA_Thai_SME_manufacturing.xls
2. Bill Module (Download)

Install Adempeire 3.6.0lts

Install Adempiere normally 3.6.0lts

You will find installation guides Getting Started. Do not forget to download and install the patches as instructed by Patches Installation

Thai Language Pack Installation

Package install Translation

1. Enter Adempiere with System Administrator role
2. Open the "Language" window
   1. Setup Thai Language (TH) as System Language
   2. Click button "Language Maintenance" and click to "Add missing translation"
3. Open the "Translation Import / Export"
   1. Select Thai Language option
   2. Leave fields blank (Client and Table)
   3. Press the Import button and select the directory where you downloaded or unzipped files th_TH xml translation
   4. When this process is complete you can close the window
4. Run Synchronize Terminology process now
5. Login again with Thai language, you will start seeing labels in Thai

Note: Not all the translation is completed. But you can always modify or add your own translation by using feature "Language Translation Check" window.

Installation Steps

The Thai Localisation is based on Colombia Localisation, as such, there are certain JAR and Packages that are required to install first. Although, not all the JAR and Packages is needed, you might want to explore these excellent package from here LCO Installation Instruction.

The Thai Localisation's JAR files will overwrite the Colombian one to extend some features that is required for Thailand, i.e., Partial Withholding Tax.

Install Prerequisite (Colombian's JAR)

1. Download the Colombian JAR file packages_LCO360lts_20110504.jar
   • Renaming to packages_LCO360lts_20110504.jar --> LCO_original.jar
   • Create the directory $ ADEMPIERE_HOME / packages / LCO / lib - in windows ->% ADEMPIERE_HOME% \ packages \ LCO \ lib
   • Copy this LCO_original.jar into this directory (not that, the naming is important to ensure that the Run Time pickup JAR files in correct order)
2. Download the PackIn Package LCO_Retenciones_20090827.zip
   • Enter Adempiere with System Administrator role and run Packin the following values:
   • Type: File
   • Source: [directory] / LCO_Retenciones_20090827.zip
   • Package dir: c: \ temp - anyone with write permission is temporary
   • NO MARK Dict Override
   • WARNING! Import the package LCO_Retenciones_20090827.zip - model adds a validator for all existing companies at the time of import.

Install Extension for Partial Withholding Tax

Download Page: here

1. Download the Thai JAR file package_lco_360_extend_th_20110719.jar
   • Create the directory $ ADEMPIERE_HOME / packages / LCO / lib - in windows ->% ADEMPIERE_HOME% \ packages \ LCO \ lib
   • Copy this file -- LCO_extension.jar -- into the same LCO / lib directory
   • WARNING! the naming is important to ensure that the Run Time pickup JAR files in correct order
2. Download the PackIn Package LCO_Partial_Withholding.zip
   • Enter Adempiere with System Administrator role and run Packin the following values:
   • Type: File
   • Source: [directory] / LCO_Partial_Withholding.zip
   • Package dir: c: \ temp - anyone with write permission is temporary
   • NO MARK Dict Override

Run migration script for function openinvoice

• Download the migration file Fix_func_openinvoice_for_withholding.sql and patch for underlining database.

Thai Geography (Cities/Provinces)

When installing the package File:Thai-Geography.zip installed all Cities / Provinces in Thailand. You can always make changes in Country Region and City window.

Thai Withholding Tax Configuration

When installing the package File:Thai-Taxation.zip installed an example of Withholding Taxation Rules in Thailand. You can always make changes in Partial Withholding Configuration windows.

Note: This sample will upload for GardenWorld client. If you are playing with other client, make sure in PackOut.xml

Install Additional Feature

Billing Module

1. Download the JAR file Billing.jar from here
   • Copy this file --Billing.jar -- into the same LCO / lib directory
2. Download the Packin Package - Billing.zip from here
   • Enter Adempiere with System Administrator role and run Packin the following values:
   • Type: File
   • Source: [directory] / Billing.zip
   • Package dir: c: \ temp - anyone with write permission is temporary
   • NO MARK Dict Override

Finalize the Installation

1. At %ADEMPIERE_HOME%, Run RUN_setup. [Bat / sh] or RUN_silentsetup. [Bat / sh] - this step should be integrated into the classes Adempiere.jar Colombia location
2. Login as Client Admin
   1. Run Role Access Update to ensure that all newly installed process, the Client Admin will have the right to access.
   2. Run Verify Document Type to ensure the new Document Type and Periods is created for this client
   3. Run Update Sequence No to ensure that the new Document Type (i.e., Billing) will have the document sequence setup properly.