User:Racd

From ADempiere
Revision as of 18:12, 7 May 2008 by Racd (Talk) (Tips for changing SQL Sevrver db compatibility using a sp command)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
Name This user real name is : Mohd rasidi sareh
Sourceforge logo.png This user has a Sourceforge account.


My Background

  • Place Of Birth: Parit Sulong, Batu Pahat, Johor, Malaysia
  • Date of Birth: 28 Jun 1981

Study Background

  • Primary School: Sekolah Kebangsaan Parit Sulong
  • Secondary School: Sekolah Menengah Dato Sulaiman (SMDS) form 1 - form 3
    • Sekolah Menengah Teknik Batu Pahat (SMTBP) form 4 & form 5
  • Matriculation Program : Chermai College, Bahau, Negeri Sembilan
  • Bachelor Science Hons(Information Technology): University Of Mara Technology

My Online Notes

Overall About Adempiere

  • 1. What is Adempiere?
    • Adempiere is open source, fully integrated ERP, CRM, supply chain management and accounting software. More about Adempiere..


  • 2.What is COA?



  • 4. How to create new Client?
    • After we have complete the installation, we need to do initial client setup in order to create new client in our Adempiere application. Adempiere default installation will only have one default client that is "Garden World" as a sample client. Read at the below links to learn more about Initial Client Setup.
  • How to setup Master Data?
  • Adempiere Process Flow


Customization

My Outstanding Project

Under Construction

Adempiere Civil Works

Nearly three years ago i has been introduce with Compiere during i am working in one of IT company in Malaysia. From there i am falling love with compiere. One of my best work is customizing compiere to suit with Construction Business Flow. Now i am trying to put this construction module together with Adempiere. I am sure it will be my best contribution to Admepiere. To suit with construction business flow, me with help from a few friends, has successfully added some new modules.

  • Project Budget
  • Bill Of Quantity
  • SubContractor Letter Of Award
  • SubContractor Progress Claim Record
  • Clinet Progress Claim Record

...download my documentation for more detail of my project here. http://adempiere.red1.org/racd/construction/construction.zip

or go to this link to know the whole story of this project http://www.adempiere.com/wiki/index.php/CivilWorks


Adempiere Implementation from my Perspective

Implementation Process

  • Requirement study

Its will be great if the customer can provide the team with complete of their Business Process Flow. The customer must also give detail explanation on the business process in term of

    • Purchasing
    • Sales
    • Settlement of an open items
    • Customer invoice
    • Vendor invoice
    • Salary
    • Others bills etc: electricity, phone
    • Financial Report
      • What type of report to produce by the system?
      • What is the contents of the report?
      • Sample of current financial report?
    • Chart of Account
      • Customer should also give the team with the actual COA to be used by the system.


  • Customer requirement and Adempiere module analysis

Try to match the customer business process with the adempiere Module base on the requirement study. It will be great if less customization required during the implementation.


  • Installation and implementation

Installed adempiere and implement it base on the user requierement


  • Parallel Run

Use adempiere that implemented and try to compare the end result with the actual result which use the normal process


  • Customization

Customization on adempiere if required in order to fulfill user requirement.

Other Stories Of My Life

Tips for changing SQL Sevrver db compatibility using a sp command

  • SQL: 6.5 Compatibility in SQL Server 2005
    • Reports the current compatibility level of 'MyDBName [ EXEC sp_dbcmptlevel 'MyDBName';GO ]
    • Changes it to SQL 2000 - 80 [ EXEC sp_dbcmptlevel 'MyDBName', '80';GO ]
    • Changes it to SQL 2005 - 90 [ EXEC sp_dbcmptlevel 'MyDBName', '90';GO ]

How to backup and restore SQL Server 2000 database