DEPARTMENT OF COMPUTER INFORMATION SYSTEMS

>

NEAR EAST UNIVERSITY

FACULITY OF ECONOMICS AND ADMINISTRATIVE SCIENCES

DEPARTMENT OF COMPUTER INFORMATION SYSTEMS

2005/2006 SPRING TERM

cıs ⁴⁰⁰

(Graduation Project)

ELECTRONICS SHOP SHOWROOM SYSTEM

••

SUBMITTED TO: DEPARTMENT OF c.ı.s.

SUBMITTED FROM: ÇAGLA DELİCEIRMAK 20000115

.,

LEFKOŞA 2006 '

ı~ıı ı ~tı ^{ımıııtıı ~ıııı}

NEU

CONTENTS LIBRARY

I. ACKNOWLEDGEMENT 2

II. ABSTRACT 3

III. INTRODUCTION 4

IV. DESING OF THE SYSTEM 5

> Explanation ...•... 5

> Data Flow Diagram 10

> System Block Diagram 18

> Database Design ~ 19

V. USER MANUEL 21

> User Guidelines 21

> User Flow Charts 27

VI. REFERANCES 50

APPENDIX I "'. 51

> Screen Outputs .._ -, 51

APPENDIX II 83

> Source Code 83

I. ACKNOWLEDGEMENT

First I would like to thank very much Mrs. Nadire Çavuş who never left his support and always encouraged me during my study.

I would also like to thanks all instructors of department of Computer Information System for their support.

I would like to thank very much to my family, and my friends who have much contributions to my all studies which are invisible .

••

2

II. ABSTRACT

1\i

Electronics shop showroom system is a program to help the electronic shops to control their stocks as play stations, dvd players, stereos, tvs etc. This program is taking attentions with its user friendly interface also it is very easy to use with high level of functionality.

The program provides the stock controlling features and evaluation criteıia is based on a small to medium manufacturing company. A scheduled user manual prepared for helping

the users to select an appropriate action.

System provides manage and take hold of records to business transactions.

System has a database for storing data of transactions in company and has an interface to easy use of users.

••

3

III. INTRODUCTION ıl

The companies were doing their jobs manually, such as accounting, receiving and order, stock controlling... Etc. But recently IT (Information Technology) started to help

companies or fınns. Then it has been very popular because it is faster, cheaper than manually and so easy work with IT.

At this point Electronics Shop Showroom System will provide easiness and quickness of controlling stock.

Electronics shop showroom system is a program to help the electronic shops to control their stocks as play stations, dvd players, stereos, tvs etc.

This program is taking attentions with its user friendly interface also it is very easy to use with high level of functionality.

4

IV. DESIGN OF THE SYSTEM

EXPLANATION

The minimum requirements of the system are as follows :

o· Intel Pentium III Processor o 550 MHz

o 128 MB of Ram

o 30 GB Free Hard Disk Space o 14" Monitor

o Microsoft Windows 2000

o Toshiba CD-ROM Drive WM-6802B

The recommended requirements of the system are as follows:

o Intel Pentium IV Processor o 800 MHz

o 256 MB of Ram

o 360GB Free Hard Disk Space "

o 17" Monitor

o Microsoft Windows XP Professional o Toshiba CD-ROM Drive WM-6802B

I used Delphi for writing this program and Access database that has connection with Delphi

5

1) PROJECT IDENTIFICATION AND SELECTION

THE AIM OF THE PROJECT:

^l\i

Electronics shop showroom system is a program to help the electronic shops to control their stocks as play stations, dvd players, stereos, tvs etc. This program is taking attentions with its user friendly interface also it is very easy to use with high level of functionality.

The existing system's handicaps, the easyiness and flexibility that the new system wishes to bring the users and the corrections to be made on the existing system are explained in detail, under the headlines "The Existing System's Capabilities" and "New System's providences".

PROJECT BOUNDARIES :

1. The system will be effored in one pc without network.

2. In this system manager can define different users with some limits.

3. Every user will have his/her password to enter the system.

4. Each product have been checked before delivery. According to the checking operation, Electronics Shop Showroom System does not contain returned goods process.

5. Customer process does not include deleting process because, any current record ın the same name of the customes won't be erased.

6. Supplier process does not include deleting process because, any current record ın the same name of the supplıers won't be erased.

RESOURCE LIMITS :

System need approximately 1000$-1200$ cost common PC. Some of the employeees may be sent to computer courses. So ail the expenses for courses and hardware will be affored by the business's own budget.

6

2) PROJECT INITIATION AND PLANNING

Technical Feasibilty:

The hardwares that are necessary for the system are as follows:

- One computer - One printer

Beside this hardwares, some hardwares and softwares for the new system that will applied and should be affored as well.

Operational Feasibilitv:

· A test has been made among the employees to find out the computer knowledge levels. According to the results, can choose the employees who have some knowledge about the basics of computer and capable to use the system. However they should be educated about the system.

Economical Feasibility:

All the expences will be affored by the business's own budget as mentioned before.

••

7

I

^>

I I I

3) ANALYSIS

THE REQUIRMENT DETERMINATION:

The requirments made by the users are as follows:

I I

To increase the speed of operations To prevent the loss of data

To prevent the data duplications To provide easy and quick data access

To prevent the caos caused by the increasing number of customers and stocks To restrict data access with the means of system security with password entry

I

I EXISTING SYSTEM CAPABILITIES:

I

The shop works in manual system. All of the documents are held in hand.

All the customer, supplier, product and employee cards are held in hand.

All archive stores are not in order so finding them is difficult.

I I

NEW SYSTEM PROVIDENCES:

Complete security with user's profile:

Manager can add or delete users who work in his/her business. Manager can give authorize or restrict access to users with security process. Electronics shop automation system can recognize users that manager define and prevent others authomatically.

I I I

Customer controll :

Users can see registered customers debts. Also users can make it possible to determine percentage discount of sales.

Product control :

Users can see most demanded products of stocks. Also users can see stocks which are under minimum stock level.

I Code based selling and purcahsing:

For selling and purchasing process program use code base sysytem. Users enter the code and sell registered products to customers or add new products in stocks more secure with this system. Code property cause keep more than one product with same name without mix them.

I I I

Code based cash or credit receipt:

One of the most extensive properties of the system is code basen cash or credit receipt process. Users can follow products bougth by whom, product information and payment type with code base system. Also it can help to control sellings and customer informations quicker and better.

I

I ⁸

I I I I I I I I I I I I I I I I I I I I

>

Chance to see details cash accounts:

Users can see details of cash operations either daily or between two dates. Program can list selling processes of manager or employees. Program can pint the list on printer.

Extensive reports:

Program canprepare extensive reports concerned with customers,, products, accounting, suppliers of choice.

Appearance and themes options for users: Electronics shop automation system addressing users pleasure. Users can change desktop background of program.

DATABASES:

Customers Stocks Suppliers Users Categories S Stocks P stocks Invoice Bills Installment Sup_payments

9

...J

o,

I ~ I

a, :::>

Cl) ii

"O tJ) Cl)

Q)

.!!2

^"O

- •••. Q)

o

$ Ocı O

o gı-o O)

C: -

Q)

Q) .:.:: ~~ "O "O

Ol

o ·- aı

"O ~ ~ C

ı...

Cl)

Q)

aı 8 ~ .92 ro

]ll~~

1 _r r

...

C

ı

E aı

I ^~

>, ro

C.

o.. w

I OJ-

I Cl) Cl) >-

Ü Cl)

-~ ZO 00

~~ bs

WQ ...ı I WCI)

••

"O

- ^cu ro

"O

+-'

^"O

C

^C:

Q)

cu

^Q)

E ^E

Q) "O^O)

>-

^{"O (l)}

co ı... $

o.

^Q)

o

E

^C

o ^.x.

-

^Cl):::::ı

(.)

(/)

t:::'.

o o.

~ ı...

Q) O)

co

C

co

E

Q) O)

"O Q)

o 3:

.:::t:.

C

~ o

Q) (/)

ı:ı::

lLI

::::;

a. a.

::ı

(/)

~ I·

_!/)

^I

d

"C ~

__iı~~

.2

£

cıı _!/)

ro

-""-(.)

"O o

-""-(.) 1i5 .l!! "O

.,..,

o

"' _'

^a,

'

j

'

cıı

.2 .E ~

.E .E

!/)

!/)

ro ~ Q)

·c:

- Q)

ro ıı,

o

"O ::,

Cl

V,

I

^Q)

cii

V,

Cl C: !/)

~ en

. C Q)

"q"::, (.)

o o

(.)

~

(.) a.

<(

"'

iii"C

a;

Eo

;;;:,

'"

~ °' '""C

.8 ;:E~

"'o

:, C:

"-"

a;

"*£

Eo

_a

>

,I ı,

'"

°' -

"C

'" -

jo

-"'

C:

"'

~

:,

I I I

~

cıı

ro

"O

"O

~

Q)

1i5"ö,

2

_(il

~

_.8

.~ ^.£:

.1

""O

"'

'5 o.

"C

o. o_o

C ::,

o

_!/)

°'

"C

E ~

(il

"'

V, Q) s:

f::!^:,

s

(.)

ı

^o.

s

>

~

cii C

Ol

"'

C:

"'

!;:

2 -=

V,

cii o

E

1i5::,

(.)

1\~L _{~ ! r~~}

(/) •... (/') .£

c.92...., ""'2

Q)- C Q)C

Eo, aı

~§-E

a.V, -

~ cıı ~ \

~ U)

2

a. C: C:

g- l E

--- iu' ~ 1---

_{o. -}

.,

::, ın

iii

"C

"' g

;;;

"C

i

C:

~~---~

"'~

B

o:: uı

o ~ I­

C/) ::J

Ü

U) Cl)

ı.... O)

Cl)

^"O

E ^Cl)

·-.e ~

U)

o

::::ı C

Ü

.:::ı::.

ı.... ~

^(I)

(I) (.)

..- E e

...: .8 o.

If) ..:.:::

:::ı (.)

(.) (I)

.c

(.)

ı.... J2 C Cl) ·­

E

^"O

••.•• !'Cl) o~

U) ••••••

::::ı

^U)

ü"- 0

~

ı....

(I)

E o 1n :::ı

(.)

(I)

;;:::

(I)

~ E o 1n :::ı

(.)

o::: uı

...J

o.. o..

::>

Cl)

(l)

~ O)

(l) "O

·- (l)

f--

o..~

0..0 ::::ı ı::::

(J')~

>

~ ro

'O

~---~-~---, ~

Cl..

Cl..

~

.E w c

"O

(l)

O) ı::::

ı--- ..c: ro ---.ı

Ü

ı...

(l)

o, c,

::::ı

(J')

O)

-~ ro

"O (/)

C'? §- Kl

C'\i~8

Q) L.

·- o.

"i5..

o. ::ı

(/)

~-~ .E

(l) "O

= _o..

^(l)

_ı...

o,

^(l)

::::ı u5

(J') ·-

o

~

.E _c

"O

.•...

(l)

"O ro

c, •.•

::::ı ı...

(l)

o, o,

::::ı

(J')

ı...

(J) Cl..

c,

~ w

Q)

ffi ~ i

I ^I I ! ^o

r

.•....

Cl)

r

[

t

I I

I'

I

ro a,

.•...

ro ..::

"O

~ I _I ^q

,_ a, a,

^I,

a. o..

a. a.

:::ı :::ı

CJ) CJ)

.•... ro ^ro ı ^a,

"O

ro ^..::

.::£

.•...

Ü

ro

^CJ)

o

"O

a,

....,. ^Ol

^CJ)

·c

• .::£

C CJ)

e- ^o

s::t"

Ü ·-

a, o ^Ol

. o

"O Ü

Ol a,

C") ••••• "O

o a, .•...

cn ro ,_ .•... ^ro

a. ro

^Ü

Ü

\ ^~

^GJ)

^C

(lj

..c

Ü

.:::t:.

Ü

o

.•....

Cl)

.2

C

.::ı:.

Ü

o

-

^Cl)

Ol

.2 ~I I :!

C

r~;

:;:; (/)

..::

aı cıı

(") Q)

aı

^Ü

a,

^CJ)

(") "O

_{~ ,._} 8 .•.•. ro ^{o::::: .::£}

^Ü

cn E

Ü

a. o

o .•...

üi

,_

^CJ)

.2

.2

C

"O

.•... a,

"O

ro a. :::ı .::£

Ü

o

U)

15 cıı

:~ ~

-

lf)

~o

.: =: u~

c

_QJ

E

~

~

QJ

·5 ~ .£ >

ci3~

E 16

0

i·~~

::ı

o

o ~

Q)

I ^.;:::

(ti

-

C/)

.:::ı!.

(ti

Ü

"O

- o

^C/)

ı....

Q) ti)

Et: o o -

_{ti) Q)}

a.

::ı ı....

(.)

m

(O

Q)

"O y

.;:::

.:.t.

.:::ı!.

Ü

o

^(O

u, ^ro

Ü

- o

"O "O

cıı I o

CJ)

C/)

Q)

-oro/

^{Q) -ti)}

_{ro -o}

^(O

s:

.:.t.

(.) (.)

ı....

o ::ı­ a.

ti)

..;:::

.:::ı!.

Ü

o

~

o::

r

~~

uı

^{-~ ti)}

ro ro

(.9 ·Ct

^"O

Ol

~::ıg_

^ı....

<(

_{C l!lOaı} ^Q)

z

^·-

_-t

^{(/) (.)}

_(.)

^ı....

E _o

<(

C O <( \

ui

~ ---- ::ı o, ::ı

o

^{Q) . (.)}

Ü ı....

Ü

ro

Q)

-

C/)^CQ)

E >,

^Q)

ro= o.'+-

o! :::ı

C/)

t:'.

ti)

_o

a.

Q) ı....

ı....

.92 Q.

a.

::ı

Q)

..;:::

C/)

,.__

Q)

o E

-

^(/)

:::ı

Ü

- ro ^ro

"'O Q) Ü

o >

C

..;:::

Q)

·o

Ü

>

C

-

^CQ)

= E~ ^ro-­

ro -o

-

^CJ)C

2

(/)

C

ro ro

"O

c

_QJ

E >,

ro

a.

••

^Q)

..;:::

-

^CQ)

E

Q)

ro

..;:::

""

(/)

cu I~

"O

,.__

~ o. o.

:::ı

(/)

~ ~ E-<

(/)

v: ^.92

~

ı... aı o

^Ol

v:

oı-o

~

2..92

t,

Ctl ~

o

Ü

o

~c

o

Ü~

o

~ in

r

~ o

=

rrı

~

I ^o = ^tr: _u

f

~ z o ~ E-<

I ^{~ ....:ı ~ u}

~ o

~

~ ~ o:::

~ ....:ı

uı

~

(.9

<

<(

E-< z

~

<(

~ :E

v: v:

~ u

o ^aı

~

Ol

~

"O

aı

~ ı

z

.O£C

~

^(/)

E-<

ı...

E-<

aı

(/)

~

::ı

v:

(/)

·c Cl)

f~

Q)

ı;::

(/)

·.:

Q)

o

O)

.•....

Q)

co

(.)

Q)

ı;::

(/)ı...

Q) (/)

::ı

c ^!.: g-

Cı)

o

Cı)

-ı::,

Oı Oı Cl)

ı:::

:§ ~ a

::ı

(/) ~ J ~~

(!) Q)

ı::: ...:

~ aı ^.§ ~a;

r:: ::l c3

^Ü

co

(/)

uı

I

^t·'·,$

I ~

Cı)

t::

t::

Cı)

o

o t::

Q.

~ ı ~ ~ &

< a::

^Cl)

o

Oı

iZ aı a:: ı ^.s

r ~

Cl)

E: ai ct 1:

~ r o ~ ...:

::ı

< a:: .•...

^{Q. o}

o

"""' o ~ §- .2 8

Q o..

^{Ü ~ ~ ~}

~ uı a::

u o

~ ~

~ I

^Cı)

~ Oı Cl)

E-<

^(!)

ı::: aı:O

^tı

^..._eıı

u: ~ ·en E: ~ I .çe ~

~ r eı ~ .2 .cii

ı-.ı

o. ^cu

r/1

z .s o co o '

Q. ::,..,

:::ı :::: ı....

::ı Q) ::ı

cu

rtJ. o ~ & i Oct '

~Q

~ 8

~ ~

E-<

r/1 00

~I I -

ır:

~ o

~ ^~ O ~>- ^~a:: >r ^{H. :} · ^~~ ~w t-H (/) ^I , ^G O

~ (f)Z , ~~

r

...,. (f)W tı Cl)

r/1 ~ ' ^j

~ o,

o =

tr: u ...

z ~ H (/)

0 ~ ^{lr 1·} ı~ı;i ı~

~ o,

'l::ı•ı

-ı· ^-ı::,

.~ o, 'Ot

Cl)

:::ıQ.

~ 55 ~· a

(/)

a::

uı ~

I ^{. I} ı ^I ı~

o _-ı::,

I

(/)

r -ı::,

:::ı ~

Ü

I . I ~

• ~ • u • -

EES~~~§

~~t~~oe

>

o N

V. USER MANUAL

USER GUEDILENES:

1. MAINMENU

Use main menu items to make any operation or use shortcut buttons to reach specified processes.

-Shortcut to selling is take you to selling process quickly.

-Shortcut to purchasing is take you to purchasing process quickly.

-Shortcut to customer receivables is take you to customer receivables process quickly.

-Shortcut to under minimum stock level report is take you to stocks under minimum stock level report process quickly.

2. CUSTOMERS

You can search, add, delete or update customer records in this process.

-To find any customer, select an item from the list, enter necessary data and click Find buton.

- To add new customer record click new buton, enter necessary data and click Add buton.

-To delete any customer record select customer's record from the list (or use guide buttons) and dick delete buton. If selected customer have debts, program will not allow you to delete.

-To update any customer record select customer's record from the list (or use guide buttons ) and click update buton.

-Cancel buton enables you to cancel last changings.

-Main menu button returns you to main menu

21

...J

3. SUPPLIERS

You can search, add, delete or update supplier records in this process.

-To find any supplier, select an item from the list, enter necessary data and click Find buton.

- To add new supplier record click new buton, enter necessary data and click Add buton.

-To delete any supplier record select supplier's record from the list (or use guide buttons ) and click delete buton. If you have debts to selected supplier, program will not allow you to delete.

-To update any supplier record select supplier's record from the list (or use guide buttons ) and click update buton.

-Cancel buton enables you to cancel last changings.

-Main menu button returns you to main menu.

4. STOCKS

You can search, add, delete or update stock records in this process.

-To find any stock, select an item from the list, enter necessary data and click Find

· buton.

-To add new stock record click new buton, enter necessary data and click Add buton.

-To delete any stock record select stock's record from the list (or use guide buttons) and click delete buton. If selected stock's quantity is not zero or if it is found in returned goods , program will not allow you to delete.

-To update any stock record select stock's record from the list (or use guide buttons) and click update buton.

-Cancel buton enables you to cancel last changings.

-Main menu button returns you to main menu.

-Add new category button take you to categories process quickly.

22

5. ACCOUNTING:

5.1 SELLING Steps to selling:

1. To sell new product enter customer id, product id , or use help button to find any customer or product. To find any customer or product select an item from the list,

enter necessary data, click find and add buttons.

_,,I

l

I

2. Then enter the quantity that you going to sell, press enter key. Program will automaticly calculate sub total, total and total quanttiy.

3. Click add to sales button to add selected product to sales.

4. Click calculate total button if multiple stocks have been added to sellings.

5. Choose payment type and click done button. If you choose credit selling enter necessary data and then click done button.

Main menu button returns you to main menu.

Program prepare bill automatically.

5.2 PURCHASING

Steps to purchasing:

1. To purchase new product enter supplier id, product id , or use help button to find any supplier or product. To find any supplier or product select an item from the list, enter necessary data, click find and add buttons.

2. Then enter the quantity that you going to buy, press enter key. Program will automaticly calculate total quanttiy.

3. Click add to purchases button to add selected product to purchasing list.

4. Click calculate total button if multiple stocks have been added to purchasing list.

5. Choose payment type and click done button. If you choose credit selling enter necessary data and then click done button.

Add new product take you to stock process quickly.

Main menu button returns you to main menu.

23

>

5.3 CUSTOMER RECEIVABLES

Steps:

1. To get new payment from the customers select invoice information from the list and click make new payment button. To find any record, select an item from the list, enter necessary data and click Find buton.

2. Enter payment amount and pres enter key. Program will automaticly calculate remaining payment amount. If this is last installment program get remaining payment amount as payment.

3. Click add button to get payment.

Cancel buton enables you to cancel last changings.

Main menu button returns you to main menu.

5.4 SUPPLIER PAYMENTS

Steps:

1. To make new payment to the supplier select bill information from the list and click make new payment button. To find any record, select an item from the list, enter necessary data and click Find buton.

2. Enter payment aıİıount and pres enter key. Program will automaticly calculate

remaining payment amount. If this is last installment program get remaining payment amount as payment.

3. Click add button to make paymen •.

Cancel buton enables you to cancel last changings.

Main menu button returns you to main menu.

24

,

6. REPORTS:

6.1 CUSTOMER REPORTS

Make report choice and click print preview button.

6.2 SUPPLIER REPORTS

Make report choice and click print preview button.

6.3 STOCK REPORTS

Make report choice and click print preview button.

6.4 ACCOUNTING REPORTS

Make report choice and click print preview button.

When allo sales, all purchases or cash analyse report has been selected, select any date from date interval ection and click fitler button.

7. SETTINGS

7.1 USERS

You can search, add, delete or update user records in this process.

buton.

-To find any user, select an item from the list, enter necessary data and click Find

••

-To add new user record click new buton, enter necessary data and click Add buton.

-To delete any user record select customer's record from the list (or use guide buttons) and click delete buton.

-To update any user record select customer's record from the list (or use guide buttons ) and click update buton.

-Cancel buton enables you to cancel last changings.

-Main menu button returns you to main menu

25

7.2 CATEGORIES

You can search, add, delete or update categories in this process.

buton.

-To find any category, select an item from the list, enter necessary data and click Find -To add new category click new buton, enter necessary data and click Add buton.

-To delete any category select customer's record from the list (or use guide buttons) and click delete buton.

-To update any category select customer's record from the list (or use guide buttons ) and click update buton.

-Cancel buton enables you to cancel last changings.

-Main menu button returns you to main menu.

7.3 CHANGE BACKGROUND

To change program's background select a Picture file from the window and click ok.

••

26

USER FLOWCHARTS:

>

Password Entry

>---Y---0

N

EXIT

27

l

! ..

>

1 - MAIN MENU 2 - Customers 3 - Suppliers 4 - Stocks 5 - Accounting 6 - Reports 7 - Settings

CHOICE

t

>---Y-0

N

>-Y-G

N

N

>--Y--0

N.

N

>-Y---0

N

0

28

I

^>

2 - Customers

^>

2.1 - Find 2.2 - New 2.3- Add 2.4 - Update 2.5 - Cancel 2. 7 - Main menu

CHOICE

y

ıl

N ¹¹ Search ~ustomer

!l

~ y

N IIAdd ^{New tc}

~

ustomer

y

N II

}

Save Changes

Y---.

Update Changes N

>---Y~~~~~~--,

Cancel Changes N

"">----Y-0

29

3 - Suppliers ., . 3.1 - Find 3.2 - New 3.3- Add 3.4 - Update 3.5 - Cancel 3. 7 - Main menu

CHOICE

y N

j

Search Supplier

I

>--Y

l

Add New Supplier

I

>--Y

l

Save Changes

I

>--Y _iı

Update Changes

I

>--Y ••

l

Cancel Changes

>-Y---{0 I

N

N

N

30

4 - Stocks

\

^>

4.1 - Find

4.2 - Add New Category 4.3 - New

4.4- Add

ı· -. 4.5 - Update

4.6 - Delete 4.7 - Cancel

I ^' 4.8 - Main menu

I ^CHOICE

I ^{y l}

N Search Stock

I .ı ^L

I ^~L~Y~ _N

ılı

I ^{«: 4? ~y}

^{- - ----}

I ^I Add New Stock

N

I

I <. ^{- - 4.3 >--Y}

Save C;hanges

I ^{__..J____ N II II}

.y :,

Update -.

N II II

:,

.y y

Delete: Stock

ı· ~

II II

N N

:,

lı _<4.6~Y

N II Cancel ~hanges II

y---0

⁾

y--

N

0

31

>

5 - Accounting 5.1 - Selling 5.2 - Purchasing

5.3 - Customer Receivables 5.4 - Supplier Payables

CHOICE

~ v-€)

N

">---v-@

> v-@

N

N

32

r

r

r

/ 5.1 - Selling

5.1.1 - Help 5.1.2 - Help

5.1.3- Add New Customer 5.1.4 - Add To Invoice 5.1.5 - Calculate Total 5.1.6 - Done

5.1.7 - Main Menu

,.

< ^N .y

~ .y

< ^N

~ .y

~ N

~ .y

Add Product To Sales N

~ .y

rr-

Calculate Total

I II

N

I

_!l

Y-<" ^I"

^{V JV\.A}

^{,.,. >-Y}

Save Changes

N

I

Print lnvoice L, _

>-Y-0)

33

>

5.1. 1 - Customer List 5.1.1.1 - Find 5.1.1.2-Add

CHOICE I

Y---~

N Search Customer

N

••

34

>

5.1 .2 - Stock list 5.1.2.1 - Find 5.1.2.2 - Add

CHOICE I

.Y---~

N Search Stock

N

35

5.2 - Purchasing 5.2.1 - Help

5.2.2- Add New Product 5.2.3 - Add To Purchases 5.2.4 - Calculate Total 5.2.5 - Done

5.2.6 - Main Menu

N

N

Add Product To Purchases N

Y---,

Calculate Total N

••

y _Y--~

Save Changes N

>-Y--0

N

36

>

5.2.1 - Supplier List 5.2.1.1 - Find 5.2.1.2 - Add

CHOICE I

N Search Supplier

N ••

37

>

5.3 - Customer Receivables 5.3.1 -Find

5.3.2 - Make New Payment 5.3.3 - Cancel

5.3.4 - Main Menu

CHOICE

N Search Customer Invoice

N

> Y~~~~--,

Cancel Changes N

l

I N

38

5.3.2 - Make New Payment 5.3.2.1 - Add

5.3.2.2 - Cancel 5.3.2.3 - Return

CHOICE

l I _l

Y---~

N

Add New Payment

y t

II

I

Cancel Changes N

l

r _N y~

I ••

39

5.4 - Supplier Payables 5.4.1 -Find

5.4.2 - Make New Payment 5.4.3 - Cancel

5.4.4 - Main Menu

CHOICE

N Search Supplier Account

N

~ Y~~~~~

Cancel Changes N

l

I N

40 f,

>

5.342 - Make New Payment 5.4.2.1 - Add

5.4.2.2 - Cancel 5.4.2.3 - Return

CHOICE

Y---~

N

Add New Payment

Y---~

Cancel Changes N

> v-+@

N

••

41

ı ı

I _i

I .

I

t

l

t .

l

6 - Reports

6.1 - Customer Reports 6.2 - Supplier Reports

6.3 - Stock Reports 6.4 -Accounting Reports

CHOICE

N

N

">---Y-@

N

N

6

42

6.1 - Customer Reports 6.1.1 - Print Preview 6.1.2 - Main Menu

CHOICE

y Print Report

N

v---0

N

••

43

I

ı-

ı ·

ı-

I I I I Ii I I I I I

I I

I I

,

6.2 - Supplier Report 6.2.1 - Print Preview 6.2.2 - Main Menu

CHOICE

Print Report y---,.ı

N

N

••

44

>

6.3 - Stock Reports

I 6.3. 1 - Print Preview

6.3.2 - Main Menu

I CHOICE

I

_{...__}

_- I ^~ Print Report

\.J •...__J. I

~

I - I

l

I ^N

I

...__

~ y--0

I

N I

I

I ^••

I I I

I I

ı· ⁴⁵

6.4 - Accounting Reports 6.4.1 - Print Preview 6.4.2 - Filter

6.4.3 - Main Menu

CHOICE

Y-- Print Report

N

Y---~

Search Selected Criteria

N

Print Report ~--

46

,.

7 - Settings

7 .1 - User Settings 7 .2 - Define Category 7 .3 - Change Background

CHOICE

>----Y-@

N

>----Y-@

N

N •• Set Background Picture

47

i i i I I i I i i I I I I I I I I I I

7.1- User Settings 7.1.1-Find 7.1.2-New 7.1.3 - Add 7.1.4 - Update 7.1.5 - Delete 7.1.6 - Cancel 7.1.7 - Main menu

CHOICE

Y----~

N Search User

>-Y---,

N Add New User

Y---~

Save Changes N

Y---.

Update Changes N

.Y----,

Delete User

N •• _N

Y---,

Cancel Changes

>-Y-8

I

N

48

7.2 - Define Category 7.2.1 - New

7.2.2- Add 7.2.3 - Update 7.2.4 - Delete 7.2.5 - Cancel 7.2.6 - Main menu

CHOICE

N

N

N

N

I

N

Add New Category

Y----~

Save Changes

.Y---,

Update Changes

Y--~

Delete Category N

••

Cancel Changes

y---G

49

VI. REFERENCES

I .

Books:

Borland Delphi 7 - İhsan Karagülle (Türkmen Kitabevi) Borland Delphi 7 - Ezel Balkan (Seçkin Yayıncılık)

Borland Delphi ile Veritabanı - İhsan Karagülle & Zeydin Pala (Türkmen Kitabevi)

I i

I I i i i i

i

i i

Web Sites:

www.delphiturk.com www.programlama.com

www.dwlphidunyasi.com

50

i

i i i i i i i i i i i i i

APPENDIX I.

SCREEN OUTPUTS:

ABOUT FORM:

PASSWORD FORM:

I I I I I I I I I I

I

I I I I

I I I I I

•

[' ~~ 1

! .•~~. Shortcut lo

¹

· ••.••.••• selling

Shortcut lo purchasing

Shoılcul lo customer receivabes

Shorlcul lo under minimum

stock level report

Dale: 08.07.2006 TiRıe: 09:46:33

Shorlcul lo Supplier pa.l'fflenls

5

II

7'custonıeıs...

1-lloırxı

Looking For... ...

I

^{Enter Dala .}

CuılornerNolNıııııe Surnaıııe Phone Mobile

I

Address IIAl

1 cagla 2 ahmel 3 ayıe

deliceirmak kara beyaz

8223520 8152639 2296354

05338647950

jkaraoglanogu

05338693214

05338647941

yukarı girne k. kaymaklı

* .iJlii!l

Cuıtoıııer Number .

~---

Naıııe .

Surnaıııe .

.---

Phone .

,---

Mobile .

ı. City ~---

Country .

T olııl nuıııber ol cuslonıerı 3

PRESS Fl TO HELP

5

7'supplieıs..

f-llD1(8]

Lookinf for

I

Enler Data ...

,,Surname

I

CompanyName JPhone . !Mobile

aıcelik 2265789 0533864791

kalkan

~-

8156324 053386452:

-

dalan o 8223698 053396321•

-- -!ı!I

LYJI Jll

1 ali 2 selma 3 hakan

*l 4

=iri]

Supplier Number

J

.---

Na ın e .

Surname )'"---

Coıııpan, Name

I .---

Phone .

,... _;. __

4

Cit, ;..·---

Count,, .

Mobile .

Total number of Suppliers 3

PRESS Fl TO HELP

5

I I I I I I I I I I I I I I I

7'

^{Stocks ...}

1- II

^Ll

ırxı

Looking Foı

..ı

^{Enter Dala .}

ProducllD ISU!'!'_lierlD IProductNa- Brand

.!J

^{1 sx·324}

l~

2 mp1·550port

3 [ 2 dvd·rw 200

arçelik son.ıı son.ıı

Unit Cost...

j

^{300 YTL}

Unit Price

l

^{400 YTL}

Quantity

I

¹⁵

Miniıııuın Stock Level ..

I

⁵

%VAL

I

¹⁰

3 Supplier N•• e Json.ıı

..:.J

Supplier ID

I

²

Product ID

I

Product Name..rJd'.:'"v-:d:-·r-w2_0_0 _

Categor.ıı Na-l dvd pla.ııer Categor.ııID

I

Brand

l

^{r.-o-n.ıı _}

3

13

Main

I

~

Total Nunıber of Products 3

PRESSFl TO HELP

5

I I I I I I

ı:

I I I I I i

SELLING~~~~~~~~~--,c--~~~~~~~~~~~~~~~~~~~~~~~~

Customer ID

I

^{1 help}

j

Product ID

I

^{4 helpj __}

Quantitv

J2

128.06.2006

Invoice Number ....

I

Cancel Pıoductj Stock quantitv 5

CustomerNo!ProductlD !ınvoiceN

~ ~i ~

Sub total 5000

Total VAT.. 500

Total... 5500

Calculate;

total

(onfiı m

l'xl

,tegoı.ııN ame

Are you sure to save selling Information?

Pavment TJpe:

jUnitCost

!~

t

Number of Instalment..

1

⁴

(' Cash

Required Paıımenl.. 11375

ıo

^Credit

First Paıment... 11500

Balance

f ⁴⁰⁰⁰

Main

I

PRESS Fl TO HELP ~

5

i

I

I I I I I I I I I I I I

7'

^{PıintPıeview}

1~11~["5<1

~I

INVOICE

Invoice Number:

Customer Number:

Date: 28.06.2006

Product ID Pro du ct Narre Quantity Total

5 el-sx 3 495

4 home theatre 2 5500

Total: 5500

r--lPage

1 of 1

5

i l I I I I I I i I I I i I I I i I I

III

Product No J ·- _ 5 help

I

Supplier Nu•ber

I

²

Quanlit9

ıs

..-;.~ _J::::: =

^Addnew_product

·--

Stock Quanlit, 20

lol.06.2006

Bill Nuınbeı:

PıoductlD

I

SupplieılD

I

BillNo

Cnnfıım

I~

Product 20s-rwl el-sx

ı

Are you sll'e?

!ı

^{!'.es ...}

J

^t!)

Total:

950

p ıı,nıenl t.,pe

ı

Cash Calculat

total

r.

^Cıedil

PRESS Fl TO HELP

!Categoı.,Name !UnilCost

!~

'dvd player_ _

J_ __

müzik seli

.l

·~

~J

N unıbeı Dl Invoice

J-4

Required Pıı,ment... 1237_5 First P ıı,nıenl

!

²⁵⁰

Balance

I

¹⁰⁰

5

•

7' Customer Receiv<1bles... 1- llr:ı IIB.J

CUSTOMER RECEIVABLES';-,---,--~-~--...,.-~--~-...-..----'-~--""-'..._-~--,

LookingFor I ^{Enlerdala .}

T olalAmount:5500

-1- -·-· ^{jDale j~}

• 5500 28.06.2006 1=11

1221 28.06.2006 1J

297 28.06.2006 2750 28.06.2006

T olal Paid: 2800 Balance: 2700 Label7 - ~)

I

CustomerAccountDetail:---'---~ Makenew

pavmenl

_rr _---

lnvoiceNoICuslomerNol Dale IT olalPrice

Cancel

=I~

Main menu

PRESS Fl TO HELP

5

•

CUSTOMER RECEI

Looking For.. .

Customer Acco lnvoiceNo

Customer Acco

CuslomerN

CUSTOMERPAYMENJ~~~~~~~~~~~~~--.

Customer Id 1

~

ıl:

5500 2800 2700

Customer Name cagla

Customer Surname deliceirmak

Invoice No .

Confıını JXI

lnslallmenl No

Are You Sure?

Dale .

Total .

! : .... )'.es... )j ~o

^{Make new}_payment

Required Payment..

1350

Paymenl..

11500

^Cancel

Remaining paymenl.. ...

11200

Main menu

1 TO HELP

6

I

I I I

i

i

I I i I i

i

i i i i

•

7'

Pıinı Pıeview

J-;::JJ~i!'><J

lmiiiiffil

^{14 4 ~ H}

ıssı Iii~,

^Çk>ıej

CUSTOIVER RECEIPT FOR PAYIVENT

Customer No:

Customer Name: cagla

Customer Surname: deliceirmak Invoice No:

14

Payment 1500

Date: 21.06.2006 22: 30: 13

. '/start ^t':

^{C ı;ıı - ,L 7 ~ C T'}

~J

6

I I I I I I I

I I I I I I I

II[

SUPPLIERPAYABLES

7' Supplier P<1y<1bles... 1- H LI ll'xl

LookingFor f ^choose B ^{Enter data .}

SupplierAccount---,

BillNo lSupplierlDlDate Total

--±

SupplierAccountDetaiıı--~---~---~

SupplierlD I Date Total Nuı'.

~I 2101.os.2oos l

TotalAmount. 500

TotalPaid 150

Balance 350

Cancel

Main menu

PRESSFl TO HELP

6

I I I I I I i i i i i i

•

SUPPLIER PAYABLıı~SUPPLIER PAYMENT

Looking For .

1

3

Supplier Acco, BillNo

_JJ~

Customer ID 2

Company Name son,

Invoice No 3

Installment No 4

Date ! ^21.06.2006

Total... 500

Required Paymenl 150

Payment.. fİ50

Remaining payment.Jo

,nt 500 ... 550 ... -50

Make new payment

Cancel

Main menu

Fl TO HELP

6

•

'. .... :::::necHonic Shop A\J!Onı.ation System Main t.lenu::::: . .'.~~.. G]@l~

.... ı, İIDll'xJ

Sur.naaıe deliceiımak kara .beyaz. __

Phone

8223520 8152639 2296354

Mobile

J05338647950 '05338693214 0533864 7941

~::::~~nogul~~1····.·J yukarı gııne k.~ymaklı .

~~

r:-1 ^Pmt I ~~'1

^Mmn

^I

- ~JJ .:::.L ~; .:::J

_ı ~,

T olal found .

PRESS Fl TO HELP

paJmeris

PRESS Fl TO HELP

6

•

7'

Pıiııt Pıeview

ı--=-11-;f"x\

~I

ALLCUSTONERSREPORT

Customer no

cagla deliceirmak karaoglanoglu gime

8223520

ahmet kara 2 yukan girne gime

8152698

halice hoca 3 karaoğlanoğlu gime

8223629

6

t

o:,,.:,u.,,.;,,.,

C.,,.ı.·:~··:::;\p~~tı:9uic§h.9pAutomationSystemMain ~tenu::.. [:.]~\~

~ ~ ~ A

7' Supplier Repoıts... 1- llr:ıl~I

SUPPLIER usı·---~----""'""----~-'----,

Surname CompanJName Phone Mob!~)

arçelik sony beko

2265897 05338647951 02128694563

Print preview

Tolal Count.. .

PRESS Fl TO HELP

paJmenls PRESS Fl TO ~ELP

6

II

ALL SUPPLIERS REPORT I r

Company Name Supplier ID Name Surname Address

£!.!ı

^Phone

arçelik 1 ali kara dereboyu lefkosa

2265897

sony

2

^{selin sari} gime merkez gime

05 33864 79 51

I lı

"

beka 3 ^{murat tepe} yukarı ayrancı ankara

02128694563

I I

6

I I I

I I I I

•

7'

"""< "" N •- .. ·•·- •···:=~ -

Ô 7' Stock Repoıts... , _· II

^i"'j

ırxiD

STOCKREPORTS

r. iAıı _sıocks/

Reporls Choices---.,

t"

Slacks Under Minimum Slack Level

ProducllD ISupplierlDIProduclName Brand Picture I CalegorvlD I Calegorl~I

,v slal

..] ı-

²

^{2 PS2}

^{2 20s-rw1}

3 1 kv-32

~-- · - 1 ho;;;; lhealre

song song arçelik beko

~lob) (BLOB) (BLOB)

(BLOB) 1 ^{· ı 4 pie} dvd ~lavU. · 2 televızgc - , dvd plav~

__ ,

·d

PRESS Fl TO HELP

6

Pıinl preview

Tolııl 5

I I I I I

I •

I _7'

Pı int Pı eview

Çjj6 fxl

I ^{Im •fml}

^{1~ ~.. ~ ~1}

^{I a ei I ı.ı fii: I.El}

STOCK REPORT

All

Product Name Product ID Brand Category Supplier Quantity Minimum StockLevel

PS2 1 sony play station 2 19

20s·rw1 2 sony dvdplayer 2 8

l(v.32 3 arçelik teleı.izyon 1 10 5

home theatre 4 beka dvdplayer 1 2 10

et-sx 5 sony müzik seti 2 30 10

·,. start

F C

,ı;; ,ı;; 7 c;a. e /'

^c

6

•

7'

Pıiııt Pıeview

l~ll6i:XI

STOCKS UNDER MNII\IIJM STOCK LEVEL REPORT

Product No Product Name Supplier ID

4 home theatre bek o dvd player

h

- '. start

^{f'. C}

ıa.

Ii JL

7 ~ ,..

C 1' <

7

•

7' Accounting Repoıts... 1- II ^t:l 115<1

r< !CustomerPa1111enıs, c: All Sales

Customer Selecı---~

Looking For .J

Choose !

r Supplier Pa,ıııenls ı All Purchases

c.CuıtomerNo Name Surname Phone Mobile Address I~

~ ^{1 cagla} deliceirmak 8223520 05338647950 karaoglanoglu

~

ı- -I--"'--

1 cagla deliceirmak 8223520 05338647950 karaoglanoglu

ı-

1 cagla deliceirmak 8223520 05338647950 karaoglanoglu

- ₁ -

~ deliceirmak 8223520 05338647950 karaoglanoglu

- 3 halice hoca 8223629 05338627282 karaoglanoglu

- ^{--- -- ----} ----

WJYi[I rnı a

Print

preview Tolal 5

PRESS Fl TO HELP

7

I I I I I I I I I I I I

ı.

I I I I I

•

7'

Pıint Pı eview

ı-=:-ıı;f'xj

CUSTONER PAYrıENTS

CuslxımerName Customer Surname CustomerID

cagla del ic eirmak karaoglanoglu gime 8223520

Invoice No Required Payment

21.06.2006 22 30 13 1500

21.06.2006 22: 30: 13 1300

4 28.06.2006 600

28.06.2006 1500

Total

1200

1350

550

1375

ı [Pooeıotı

7

I I

•

7'

Pr ini Preview

ı-=-ıw "><I

lm•ffil ,. • ~ ~, ıasılil~I .c:1°•• j

,ğjl

SUPPLIER PAYNENTS

CompanyName SuppllerlD Name

sony selin sari gime merkez girne 05338547951

Regulr.d Payment

3 21.06.2006 22 30 13 150

21.06.2006 22:30: 13 100

21.06.2006 22:30: 13 100

21.06.2006 22 30 13 100

21.06.2006 223013 100

01.06.2006 150

01.06.2006 250

Total

237,5

o

150

150

3 125

3 125

3"

125

_J

-;,-. Start ~ t_

5i; ·=•-•V' 4ii,Jl ] :''='l-•1>ı :;- _; •veJ ~ :-.•>c-cr '-"J ,e_ 7 • < c

7

I I

I ^:!

ALL SALES

Invoice No ProductNam•

~

^{Cateaory Product No Quantity Oat. Total}

el-sx sony 5 3 28.06.2006 495

home theatre beko 4 2 28.06.2006 5500

el-sx sony 5 3 28.06.2006 495

home theatre beko 4 2 28.06.2006 5500

2 20s-rw1 sony 2 3 28.06.2006 726

2 el-sx sony 5 3 28.06.2006 495

el-sx sony 5 3 28.06.2006 495

home theatre beko 4 2 28.06.2006 5500

2 20s-rw1 sony

••

^{2 3} 28.06.2006 726

2 el-sx sony 5 3 28.06.2006 495

3 PS2 sony 1 1 28.06.2006 297

----

·7

,,staıt et

ııı lıdL- 7::,-:-1-,ııı::- (;,J,fc-,J ça,~._l';"':"l•.•'J

c

7' <ı... :o:-w

7

If

ALL SALES BElWEEN TWO DATE

Invoice No Product Name Brand Category Product No Quantity

Q!l!. .!ın!

el-sx sony 5 3 28.06.2006 495

home theatre beko 4 2 28.06.2006 5500

el-sx sony

~

^{3 28.06.2006 495}

home theatre beko 4 2 28.06.2006 5500

2 20s-rw1 sony 2 3 28.06.2006 726

2 el-sx sony

~

^{3 28.06.2006 495}

el-sx sony 5 3 28.06.2006 495

home theatre beko 4 2 28.06.2006 5500

2 20s-rw1 sony 2 3 28.06.2006 726

2 el-sx sony

••

5 3 28.06.2006 495

PS2 sony ^{1 1} 28.06.2006 297

fPaoeıofı

',,s~~1 e. e

Qıı,:,_,p,·:·>:, li.JL, 7:•a,,1,,7 ,u,,,-,J ~,-.,--,, ..,, C,

7', <c;

^O.dl

7

ALL PURCHASES REPORT

BIii No Product Name Brand Category Product no Quantity Date Total

el-sx sony müzik seti 5 5 O 1 .O 6 .2 006500

20s-ıw1 sony CMiplayer 2 3 O 1.06.2006450

2 20s-ıw1 sony CMiplayer 2 3 01.06.2006450

2 20s-ıw1 sony CMiplayer 2 3 O 1.06.2006450

I ^ı,,

20s-ıw1 sony CMiplayer 2 3 01.06.2006450

el-sx sony müzik seti 5 5 01.06.2006500

3 el-sx sony müzik setı 5 5 01.06.2006500

!l

4 el-sx sony müzik seti 5 3 01.06.2006300

Total Number B Total

3eyoo

•

7'

Pıinı Preview

[-:-[[6!'x[

r--[Po,;ıe IolI

~I

'\, start

F

C.

iti It"

7 0 e. r ·

c

7

7'

^{Pıiııt pıevtew}

[-;--11~!~1

Im •lfil_ı4

⁴

^~

^H

ıs~ıı.ı~ı ^ı;kısel

I ^{ıc;J B}

ALL PURCHASES BETEWEEN TWO DATE

BIii No Product Name Brand Category Product no Quantity Date Total

el-sx sony müzik seti 5 5 01.06.2006500

20s-rw1 sony CMI player 2 3 01.06.2006450

2 20s-rw1 sony CMI player 2 3 O 1 .06 .2 006450

2 20s-rw1 sony CMI player 2 3 O 1.06.2006450

20s-rw1 sony CMI player 2 3 O 1.06.2006450

3 el-sx sony müzik seti 5 5 01.06.2006500

3 el-sx sony müzik seti 5 5 O 1 .O 6 .2 006500

4 el-sx sony müzik seti 5 3 01.06.2006300

Taal Number 8 Total 3600

••

-,;j sfaı1

t:';

e,. .;

·=·-•v:: :·~:ı Iii .JL,

7

=•-:-ptıi ::- ,j·1.1ı_"'.J ~ :..rı;.,-ı,.,,J

C 7'

=· < c.; :cı·-ı:.

7