yEd Graph Editor
Lagi ada project untuk buat CRM suatu perusahaan media. Dan kebetulan sekarang lagi dalam proses pembuatan Information architecture yang mengharuskan tim untuk membuat desain layout aplikasi ini nantinya akan seperti apa.
Untuk desain aplikasinya kita pakai Balsamiq. Salah satu software wireframing.
Cuman selain membuat desain mock up, saya perlu juga membuat Roles Structure, Data Source Application, dan juga Flow Diagram dari mock up itu sendiri. Itu semua tidak bisa kalau pakai Balsamiq. Saya musti nyari software yang lain agar bisa menggambarkannya.
Setelah browsing-browsing ada juga sih software yang bisa desain online, cuman resikonya ini nanti file yang di downloadnya saya tidak punya file yang original *or, mungkin bisa sih dapat file originalnya* yang pasti saya tidak mau ambil resiko juga sih.
Saya ada nemu software yang bisa jalan di Linux dan juga bisa support hampir semua desain yang saya perlukan. Namanya yEd Graph Editor. Buat Reader yang mau coba pakai software ini silakan dibaca dulu petunjuk instalasinya yah.
Tata cara install yEd Graph Editor di ubuntu :
1. Download file nya di http://www.yworks.com/en/products_download.php?file=yEd-3.8.sh
2. File yang di download nanti formatnya .sh. buat agar file tersebut executable dengan menjalankan perintah chmod 755 yEd-3.8.sh di terminal. Sebelum menjalan perintah tsb, make sure bahwa perintah tsb sudah diarahkan dimana file .sh tersimpan (kalau saya disimpan di /home/downloads jadi musti buka dulu foldernya dengan cara cd /home/downloads ).
3. Setelah dibuat executable, ketik perintah ./yEd-3.8.sh maka akan muncul tampilan berikut :
4. Pilih yang 'I accept the agreement' kemudian klik next.
5. muncul tampilan dimana yEd akan terinstall. klik Next.
6. Tidak begitu ngerti step yg ini untuk apa, but Just click Next. ;)
7. Installing. tunggu sampai dia selesai.
8. Dan, install yEd sudah selesai, tinggal dicari saja di Application atau ketik 'yEd' maka Anda sudah bisa untuk mulai mendesain ;)
Berikut adalah tampilan dari yEd :
contoh desain family tree :
well, saya cukupkan sampai disini postingan kali ini. Happy design !
5. Manage Bank Account
In this post we will learn how to manage bank account in Adempiere. Every company have minimally one bank account for accounting activities. In adempiere we can add as much as bank account based on the number of company has.
For example, when we register to bank A, then in bank A we have 2 or 3 account numbers. With this case, adempiere provide what the company need.
Well, let's create a bank account now.
To create a bank account we must select Menu | system admin | organization rules | bank . Then the following window will be shown.

Click new icon. In Bank account, fill the field with:
Name : name of your bank
Address : where is the bank located
Routing No : 001 (as for marked bank name with code 001)
leave the active checkbox marked.
then go to Account tab, fill account number, currency and bank account type.
click save button, and you already have one new bank account.
if we have more than one account number in the same bank, we can create new account number on Account tab, click new and fill the form with the information we have (account number, currency, bank account type).
that's all for now..
Nits
4. Business Partner
This post will learn how to create a new business partner in our company. Of course as we know that we cannot create any Purhase Order, Sales Order, or even any transaction without having business partner. Business partner is entity to do business with. It can be Customer, Vendor or even Employee.
For now we will learn how to create a new business partner as Customer. We can do that by navigating to Menu -->Partner Relations --> Business Partner Rules--> Business Partner. You will see screen that similar with it.

Click New Icon, on Business partner tab fill following field :
Search Key :company name of bussines partner (ex: Hempel China Limited)
Name : company name of bussines partner (ex: Hempel China Limited)
then go to Customer tab, mark customer checkbox like following screenshot:

go to Customer Accounting and you will see the information about account that will be related with this business partner.
To set location of business partner, go to location tab, fill the address with business partner address.

click OK button. Go to Contact (user) tab to set contact person of this business partner. Fill information related to contact person of it. After it, click save icon. then you already create a new Customer.
Another business partner is Vendor and employee. Vendor is any person or company that sells goods or services to other party in the economic production chain. While, Employee is a person who performs work for an employer under a verbal or written understanding where the employer gives direction as to what tasks are done.
Actually, the step both of them is similar with creating of new customer. The difference is just if creating a new vendor, we must mark vendor checkbox while if creating a new customer, we must mark Customer checkbox on it.
Don't forget to save every single changes.
happy try guys..
~Nits~
3. Import File Loader
This feature is to load some data of file about accounting such as, chart of account. We need to import the file as a temporary table that will be load next for a permanent account.
To import this file, on menu we have to go to System Admin ? Data ? Data Import ? Import file loader. Then the following window will be shown:

click select file to load , choose AccountingUS.csv then select UTF-8 beside the select file to load button and in import format button, click Accounting- Accounts. Click OK button and wait until the process finish.
When window below shown, that means your chart of accounts is already being saved in the internal Adempiere temporary account for further process : Import Account.

Import Account :
from Menu go to System Admin --> Data --> Data Import --> Import Account then you will see this screenshot.

this is lookup record window. it shows when we want to search specification of account / data / information. click New icon on it and then a window will appear.

click Import account button then you have to fill this window :

fill Elemen with sixtofive.Ltd account (for example) and mark all the checkbox, then click OK button. please wait when it proceed. You already import your account to the Adempiere when this window shown :

well, it's OK for now.. then we will learn about Business partner in the next post.
~Nits~
2. Opening Period
We can't start making any accounting transaction without opening period of transaction. transaction or activities that related to our company activities can be managed based on our accounting period for example, 1 month, 6 months or even 1 year. to setup, we must login as Client User that we already created (see previous post)
here, I login with User ID nitaAdmin

from Menu, go to Perfomances Analysis --> Accounting Rules --> Calendar Year and Period. this is the appearance of Calendar Year and Period window.
click New icon, then on Calendar tab, fill name with your calendar name (ex: sixtofive Calendar 2010) and go to year tab. fill year with 2010. don't forget to mark active checkbox, click Create periods button.
now, go to Period tab and fill start date period (date-month-year). Click Open/Close all button means that the period you create is being open.

when you already click Open/Close all button, don't forget to save it all by clicking save icon on top of menu.
to make sure that your period is already open or not, click another tab, that is Period Control tab. the following screenshot is sample of period that already open.
you can start your company transaction after this.
~Nits~
1. Initial Client Setup
When we start using Adempiere for our ERP solution. first thing to do after installing the application is to setup Client. actually Adempiere has 2 kind of default client that is System Client and Garden Client. System Client used to create other client while Garden Client is used for evaluating purpose. Garden Client contain some sample of Data, Business partner, Product, User, Accounting paramenter, etc.
well, now we will create Client first.
to create new Client, log in with user ID System and password System.
click Ok button and then on default tab, choose System Administator as Role and * as Organization.
just clik OK button.
Adempiere menu will be shown.
in Menu, go to System Admin --> Client Rules --> Initial Client Setup. You will see the window of Initial Client Setup just like following screenshot :
fill Client field with your company name, Organization with HQ, User / Contact Client and User/Contact Organization with your user when you will login. For example here I set nitaAdmin and nitaUser.
select all options. when it's already filled, before you click OK button, you must select Load Accounting Value Format button. This is used to import your COA as a temporary account. here we choose AccountingUS.csv as default.
when it's ok. Now you can click OK button.
wait for processing application.. if the following window shown on your application it means that you already success to create a Client with user ID nitaAdmin.
that's all for now.
thanks
Nits
Oracle XE on Windows
Here are the 8 steps to install OracleXE on Windows.
1. you need to get OracleXE installer in .exe format and then run oracle univ. a window below will appear when you run it.
2. clik Next, and then you need to choose 'I accept..'

3. after you choose 'accept' then just click next button. Next step is to choose destination location where will you save it.

4. then click Next, and you'll find out another step. that is to enter your password for your login. the default username is commonly 'system'

5. Make sure you enter the password right and don't forget it. another step is just to click install button.

6. then installing process will be shown.

7. when this window below showed it means that you already completed your installing process. congrats!

8. the 8th step is after you click 'finnish' button.. then you will be directly open to the Oracle login Menu.. and you can use SYSTEM as your username and of cource the password is some character that you entered before.

there you are. just installed Oracle XE express edition. :)
well, actually I want to learn more about Adempiere and I need OracleXE as its database so I installed it.
Nah about Adempiere installation itself, I already done with it. I'll post about the installation next.
see y!
cri_j